Create an Outlook Distribution List From a CSV

To create an Outlook distribution list from a CSV, first import the CSV’s people as Outlook contacts, then create a contact group or contact list and add those contacts as members. A CSV import by itself does not create a mailing list; the exact steps depend on whether you use classic Outlook or new Outlook.

What Outlook means by a distribution list

In Outlook, a personal mailing list is generally called a contact group in classic Outlook for Windows and a contact list in new Outlook and Outlook on the web. The names differ, but the basic idea is similar: you give a group a name, add email addresses, and address a message to that group instead of entering every recipient separately.

A personal group is not the same as an organization-wide distribution group. Your personal group is part of your Outlook contacts and is intended for your own use. A company or school distribution group is managed through the organization’s directory, often by an administrator. If colleagues need a shared address that they can all find and manage, ask your Microsoft 365 administrator about a shared or organization-managed group instead.

The practical two-stage process matters: Outlook imports rows as individual contacts, then you select those contacts as group members. This gives you contact records you can correct or reuse, rather than treating the CSV file itself as a permanent list.

Prepare the CSV before importing

Check the spreadsheet before saving it as a CSV. Give each piece of information its own column, use one person per row, and include a clear header row. A simple file might have columns named First Name, Last Name, and E-mail Address. Outlook can import more fields, such as company, job title, and phone number, but you only need email addresses to make a basic mailing list.

Remove blank rows and check that each recipient has a valid email address.
Look for duplicate people and decide whether they should appear once or more than once.
Keep names and addresses in separate columns where possible. Avoid putting several recipients into one cell.
Save a working copy of the spreadsheet before exporting, because saving as CSV may remove workbook features such as multiple sheets and formatting.

In Excel for Microsoft 365 on Windows, use File > Save As, choose a location, and select a CSV format such as CSV UTF-8 (Comma delimited) (*.csv) when available. A CSV stores plain text values for a single sheet, not Excel formulas, formatting, or multiple worksheets. If names contain accented characters, UTF-8 is a sensible choice for preserving them. Close or keep the original workbook before proceeding; the CSV is a separate, simplified copy.

Import the CSV in classic Outlook for Windows

Use this route if your Microsoft 365 installation opens the classic Outlook desktop app, with the traditional File tab. The import wizard transfers the CSV rows into your Outlook contacts.

Open Outlook and select File > Open & Export > Import/Export.
Choose Import from another program or file, then select Next.
Select Comma Separated Values and choose Next.
Browse to the CSV file. Choose how Outlook should handle duplicates: allow duplicates, replace duplicates, or do not import duplicate items. The wording and options can vary slightly by Outlook build.
Select the destination Contacts folder, then continue through the wizard.
If the fields do not line up automatically, use Map Custom Fields to match CSV columns to Outlook contact fields. For example, map the CSV column E-mail Address to the Outlook E-mail Address field.
Finish the wizard and check the Contacts folder to confirm the expected people and addresses were imported.

Field mapping is worth checking even when the import completes without an error. A contact can be created with a blank email field if the CSV header or mapping does not match what Outlook expects. Open a few imported records and verify their names and addresses before building the group. If you have several sheets in an Excel workbook, save the sheet containing the contacts as its own CSV first; a CSV file represents one sheet at a time.

Create the contact group in classic Outlook

Once the contacts are in Outlook, create the group and select them as members. In classic Outlook for Windows:

Open People or the Contacts view.
Select New Contact Group. Depending on your ribbon layout, you may find this on the Home tab.
Enter a recognizable group name, such as “Quarterly project updates.”
Select Add Members > From Outlook Contacts.
Select the imported contacts, choose Members if prompted, and confirm with OK.
Select Save & Close.

For example, if the CSV contains Alex Chen, Priya Shah, and Morgan Lee, import those three records and add all three to a group named “Project team.” When you compose a message, type “Project team” in the To field and select the matching contact group. Send a test message to yourself or a small test group first, especially if the list will be used for an important announcement.

Some Outlook versions let you add a new email contact directly from the group window. That can be useful for a one-off member, but importing first is usually easier to audit and maintain when the source is a CSV.

Use new Outlook or Outlook on the web

New Outlook and Outlook on the web use a different interface from classic Outlook. In these versions, go to People, then look for Manage contacts > Import contacts. Choose the CSV file and follow the prompts to import its entries. Labels and available commands can change as Microsoft updates the interface, so the exact placement may differ by account or release.

After importing, create a list from People. Select New contact list, enter a list name, and add the intended people by searching for or entering their email addresses, then save. If the list editor offers suggestions from your contacts, choose the imported records and check the addresses before saving. The contact list is separate from the CSV: later changes to the spreadsheet do not automatically update the list.

If you cannot find an import command, confirm that you are in the People app and not the Mail view, and check whether your organization’s account or interface provides contact import. You can also try Outlook on the web with the same Microsoft 365 account. Do not assume that a command shown in a classic Outlook tutorial will be present in new Outlook; their navigation and list-management features are not identical.

Classic Outlook, new Outlook, and Mac differences

Classic Outlook for Windows offers the Import/Export wizard and a dedicated Contact Group workflow. New Outlook and Outlook on the web use contact lists and a more web-oriented People interface. Both approaches can get from a CSV to a reusable personal list, but the group is not necessarily synchronized as a group object between every Outlook app or account type. Check the version and account you actually use before relying on the list across devices.

Outlook for Mac has its own interface and feature availability can depend on whether you are using new or legacy Outlook for Mac and on the account type. Do not follow Windows ribbon paths literally on a Mac. Look in the People or Contacts area for contact import and list-creation options; if the required CSV import is unavailable in your build, importing contacts through Outlook on the web may be a practical alternative. Verify the imported contacts and list in the app where you plan to send mail.

Also distinguish personal Outlook contacts from the Microsoft 365 address book. A CSV import normally adds records to your personal contacts; it does not publish those people to your employer’s directory or create an address that coworkers can use.

Check the list and keep it current

Before using the group for a large message, open its details and review the members. Confirm that each person appears once, that addresses are current, and that no test or former recipient remains. A contact group is a saved collection, not a live connection to the spreadsheet. If the CSV changes, update the Outlook contacts and the group separately, or recreate the list carefully from the new source.

New recipients: import or create their contact records, then add them to the group.
Departed recipients: remove them from the group; deleting a contact record may not be the same as removing that person from every list.
Changed addresses: edit the contact and verify which address the group uses.
Recurring updates: keep a clean source spreadsheet with an owner and a date, so you can compare it with the Outlook list later.

For a small list, reviewing the members manually may be enough. For a large or sensitive list, use a second-person review or send a test before sending broadly. Outlook and Microsoft 365 sending limits are account- and organization-dependent, so check your organization’s rules if you plan to send to many recipients.

Privacy and delivery considerations

A contact group makes addressing a message easier, but it does not automatically make a message private. Depending on the Outlook version and how the message is addressed, recipients may be able to see other addresses in the To or Cc fields. For a message where recipients should not see one another, use Bcc and put your own address or an appropriate shared address in To. Follow your organization’s policies for bulk or sensitive communications.

Contact groups are also not a substitute for a mailing platform or a managed distribution group when you need subscriptions, delivery reporting, moderation, permissions, or shared ownership. If messages bounce, check for a mistyped address and ask your mail administrator whether there are recipient or sending restrictions. A personal list does not override server rules or guarantee delivery.

Common problems and fixes

The CSV imports, but contacts have no email addresses: Reopen the import process and check field mapping. Make sure the address column is mapped to an email field, not a notes or display-name field.
Names appear incorrectly: Use separate first-name and last-name columns, check the CSV’s header row, and inspect the mapping. A single Full Name column may not split as expected in every workflow.
Some characters look wrong: Export as CSV UTF-8 where available, then import that saved file. Check a few records before deleting or replacing the source contacts.
The group name is not recognized while composing: Save the group, use the address suggestion that appears, and confirm that you are sending from the same account where the group was created.
Duplicates appear: Decide on a duplicate-handling option during classic Outlook import, or review and clean up contacts before creating the list. Identical names are not always duplicate people, so compare email addresses too.
The menu path in a guide is missing: Check whether you are using classic Outlook, new Outlook, or Outlook on the web. Their contact and import commands differ.

Frequently Asked Questions

Can I create an Outlook distribution list directly from a CSV?
No. The usual process is to import the CSV rows as contacts, then create a contact group or contact list and add those contacts as members.

Does importing the CSV create a shared list for my coworkers?
No. It generally creates contacts and a personal list in your account. Ask your Microsoft 365 administrator about an organization-managed distribution group if other people need shared access.

Can I update the Outlook list by editing the CSV?
Not automatically. The CSV and Outlook list are separate. Import or edit changed contacts, then review the group membership to add, remove, or correct people.

Can I import a CSV in new Outlook?
New Outlook provides contact management through People, including an import option for supported accounts and builds. Look under Manage contacts for Import contacts; if it is not available, try Outlook on the web or check your account’s supported features.

Will people in the list see one another’s email addresses?
They may if the message displays the group’s recipients in To or Cc. Use Bcc when recipients should not see each other, and follow any workplace communication rules.

Is a contact group the same as a Microsoft 365 distribution group?
No. An Outlook contact group or list is usually personal to your mailbox. A Microsoft 365 distribution group is managed through the organization and may be available to other members of that organization.

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.