Create an Outlook Distribution List from Excel Contacts

To create an Outlook distribution list from Excel, first save the email addresses as a CSV file and import them into Outlook Contacts; then create a contact group or contact list from those imported contacts. Excel cannot directly turn a worksheet range into an Outlook list, and the exact steps depend on whether you use classic Outlook, new Outlook, or Outlook for Mac.

What Outlook means by a distribution list

For an individual mailbox, the reusable group of recipients is usually called a contact group in classic Outlook and a contact list in newer Outlook experiences. It is stored with your personal contacts, so you can type its name in a message’s To field rather than entering every address each time. The names and labels can vary slightly by Outlook version.

An Exchange or Microsoft 365 distribution group is different. It is managed by an organization, usually by an administrator, and can have an organization-wide address and membership rules. Importing an Excel file into your personal Outlook contacts does not create that kind of group. If you need a shared address such as sales-team@company.com that colleagues can also use, ask your Microsoft 365 administrator about creating or updating an organizational distribution group.

Prepare the Excel contact list

Set up the worksheet as a simple table with one person per row and a separate column for each kind of information. A basic example is:

First Name
Last Name
Email Address

You can add columns such as Company, Business Phone, or Job Title if you want those details saved as contact fields. Use clear column headings in the first row, and do not combine multiple people or email addresses in one cell. A row containing two addresses may import as one malformed value rather than as two usable contacts.

Before exporting, check for blank email cells, extra spaces, misspellings, and duplicate records. A spelling mistake can send a message to the wrong person or cause a delivery failure. In Excel for Microsoft 365 on Windows, you can use the filter arrows in the header row to review blanks and sort the email column to spot likely duplicates. Also confirm that addresses are genuine email addresses; Excel can store text that looks like an address without verifying that the mailbox exists.

Keep the worksheet’s first row as headers and avoid merged cells, title rows above the headers, subtotals, and decorative formatting. Those features may make a worksheet easier to read, but they can complicate mapping columns during import. If your workbook has several tabs, copy the intended contact table to its own worksheet so you can export just that data.

Save the worksheet as a CSV file

In Excel for Microsoft 365 on Windows, select the worksheet containing the contacts, then choose File > Save As > Browse. In the Save as type list, select CSV UTF-8 (Comma delimited) (*.csv), choose a location, and save. CSV is a plain-text format that stores the active sheet’s values separated by commas; it does not preserve workbook formulas, formatting, or other worksheets. Keep the original Excel workbook as your editable master copy.

If Excel warns that some workbook features are not compatible with CSV, that is expected: choose the option to keep using the CSV format if you intend to import the contact data. Reopen the CSV in a text editor or Excel if you want to check that the headings and rows were saved correctly. Do not change the file extension from .xlsx to .csv by renaming it; that does not convert the file.

On a Mac, Excel also offers a CSV format from File > Save As, though the exact label and available encoding options can vary by release. Select a comma-separated CSV option, then verify that the exported file contains the intended sheet and columns. If you use Excel for the web, download the workbook or a CSV copy and check its contents before importing.

Import the CSV into classic Outlook for Windows

In classic Outlook for Microsoft 365 on Windows, import the CSV before making the group. Open Outlook and choose File > Open & Export > Import/Export. Select Import from another program or file, choose Next, select Comma Separated Values, and choose Next again. Browse to the CSV file, select how Outlook should handle duplicate contacts, and choose the Contacts folder as the destination. The wording of a dialog can vary slightly between Outlook builds.

When the wizard offers field mapping, map the spreadsheet headings to the corresponding Outlook contact fields. For example, map First Name to First Name, Last Name to Last Name, and Email Address to E-mail Address. If a column is not mapped, Outlook may still import the contact but leave that field blank. Complete the wizard, then open a few imported records to check that names and email addresses landed in the right fields.

If the import option is missing, first confirm that you opened classic Outlook rather than new Outlook. The classic Import/Export wizard is not available in every Outlook experience. Also check the destination folder: contacts imported into a different account or folder will not necessarily appear in the Contacts list you intend to use for the group.

Import contacts in new Outlook

New Outlook for Windows uses a different interface and does not use the classic Import/Export wizard. Open the People view, choose Manage contacts, and select Import contacts. Browse to the CSV file and follow the prompts to import it. Microsoft’s interface can change, so if those labels do not appear, check that you are in the People view and that your Outlook account supports contact importing.

Use straightforward headings such as First Name, Last Name, and Email Address to make matching easier. After importing, search for one or two names in People and confirm the addresses. If Outlook reports an error, check that the file is a real comma-separated CSV and that the first row contains headings. A file saved with a different delimiter or an unexpected structure may not be recognized as intended.

Outlook for Mac has its own contact and import interface, which differs from the Windows ribbon paths. Use the Contacts or People area and its import command if available in your release, then verify the imported records before creating a list. Do not follow the classic Windows wizard steps on a Mac; menu placement and supported options differ between versions.

Create a group in classic Outlook

After the contacts are imported into the correct Contacts folder, create a contact group. In classic Outlook for Windows, open People or Contacts, choose Home > New Contact Group, and enter a group name. Select Add Members, then choose From Outlook Contacts. Select the imported contacts, choose Members, and select OK. Review the membership and choose Save & Close.

If the imported people are not available in the selection window, check the address book or Contacts folder being displayed. You can also use Add Members > New E-mail Contact to enter an address directly, but adding a person this way does not correct or update the source Excel file. For a list you expect to maintain, it is usually simpler to update the workbook, import new or corrected contacts, and then review the group’s members.

To use the group, start a new message and type its name in the To field, then select the matching suggestion. You can open the group from Contacts to add or remove members later. A contact group is a saved collection of addresses, not a separate mailbox: members do not receive messages sent to the group unless someone sends a message to it.

Create a contact list in new Outlook or Outlook for Mac

In new Outlook, go to People and look for New contact list. Give the list a name, add the imported contacts, and save it. Depending on the current interface, you may be able to add people by searching your contacts or by entering email addresses. Select the list in People afterward to confirm that the expected members are included.

Outlook for Mac also offers contact-list tools, but the commands and terminology can differ by release and account type. Look in Contacts for a command to create a new list, then add the imported contacts and save. If your version does not expose list creation or CSV import, update Outlook or use a supported Outlook web or Windows experience for the relevant task. A list created in one account should not be assumed to appear in another; check the account and contact folder before sending.

Test the list and avoid common problems

Before relying on a new group for an important announcement, create a draft and add the group in the recipient field. Confirm that Outlook resolves the intended list rather than a similarly named person or an older group. If you can expand the group in the message, review the addresses. Sending a test message to yourself is useful for checking the message format, but it does not prove every recipient address is valid.

Consider recipient privacy. When a group is placed in To or Cc, recipients may be able to see other addresses, depending on how Outlook resolves and sends the group. If recipients should not see one another, use Bcc where appropriate and make sure the message still has a suitable recipient in To. Follow your organization’s communication and privacy policies, especially when the list includes customers or other external contacts.

Contacts missing from the group picker: check whether they were imported into the same account and Contacts folder used by the group.
Names appear but addresses are blank: revisit the CSV field mapping and make sure the email column is headed and mapped correctly.
Some rows are skipped: inspect blank rows, malformed addresses, duplicate handling, and the CSV’s delimiter or encoding.
The list cannot be found while composing: search for its exact name and confirm that it was saved in the account currently selected in Outlook.

Personal contact group or organization distribution group?

Use a personal contact group or list when you need a convenient set of recipients for your own mailbox. It is quick to create from imported contacts and can be edited by you. However, it may not be centrally managed or available to coworkers, and changes to the Excel file do not automatically update Outlook. If a person’s address changes, update the Outlook contact or import the corrected record and check the group membership.

Use an organization-managed distribution group when the address should be shared, centrally controlled, or maintained by a team. An administrator can set who is allowed to send to it and who can manage membership, subject to the organization’s Microsoft 365 configuration. Excel can provide a useful source list for an administrator, but it does not grant permission to create an organizational group.

For a one-time message, you may not need a saved list at all: paste the addresses into a message’s Bcc field if that is appropriate and permitted. For a group that changes frequently, a shared Microsoft 365 group or another organization-managed tool may be more suitable than repeatedly importing spreadsheet updates. Choose based on who needs to maintain the membership and whether the group must be shared.

Frequently Asked Questions

Can I create an Outlook distribution list directly from an Excel file?
No. Save the contact data as CSV, import the records into Outlook Contacts, and then create a contact group or list. A CSV import alone creates contacts, not a grouped recipient list.

Can I import an Excel file instead of a CSV?
Classic Outlook’s Import/Export wizard expects a CSV for this workflow. Save a copy of the intended worksheet as CSV first. This also makes clear which sheet’s values will be transferred.

Will the Outlook list update when I edit the Excel workbook?
No. The imported contacts and saved group are not a live link to the workbook. Import or edit contacts again when details change, and review the group to ensure membership is current.

Can coworkers use the contact group I created?
Usually, a personal contact group belongs to your Outlook contacts and is not automatically a shared company address. Ask your Microsoft 365 administrator about an organization-managed distribution group if coworkers need a common list.

Why can’t I find Import/Export in Outlook?
You may be using new Outlook, Outlook on the web, or Outlook for Mac rather than classic Outlook for Windows. Those versions have different contact-import interfaces; use the People or Contacts view and look for its import command, or switch to classic Outlook if available.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.