how do i create an email list in outlook from an excel spread sheet to include name and email address?

Sharon Overstreet 0 Reputation points
2025-10-23T12:35:17.81+00:00

How do I create an email distribution list in Outlook from an excel spreadsheet with 2 columns, (email & name)?

Outlook | Outlook for mobile | Outlook for iOS | For home
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Arlene D 13,195 Reputation points Independent Advisor
    2025-10-23T13:09:25.7+00:00

    Hi, thanks for reaching out.

    Which version of Outlook you use, like Outlook for Microsoft 365 or Outlook 2021?

    To create a distribution list from Excel, first save your file as a CSV with “Name” and “Email Address” columns. Then in Outlook, go to File, select Open & Export, choose Import/Export, and import the CSV into your Contacts.

    After the import, open People view, create a New Contact Group, select Add Members, choose From Outlook Contacts, and add the imported contacts. This creates your email list.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.