Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to create a contact group (distribution list) from Excel data?

Generally speaking, you can import a CSV file to Outlook contact folder, and then create a contact group from these imported contacts. But how about from an Excel workbook? This article will guide you to create a contact group (or distribution list) from an Excel workbook.

Create a contact group (distribution list) from Excel data

Create contact group based on senders/recipients of emails in Outlook

Normally, we can copy a sender or a recipient from an email, and then add it as a contact group member with Add Members > From Address Book, and it seems no way to add multiple emails' multiple senders or recipients into a contact group in bulk. But, with the excellent Add to Groups feature of Kutools for Outlook, you can easily add multiple emails' senders or recipients into contacts groups in Outlook with several clicks only. Click for 60-day free trial without limitation!
ad add senders recipients to contact groups 9.50

Kutools for Outlook: 100+ New Advanced Tools for Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.

arrow blue right bubble Create a contact group (distribution list) from Excel data

This method will guide you quickly create a contact group (distribution list) from Excel data, without applying the Import and Export Wizard in Outlook. Please do as follows:

1. Open the Excel workbook that you will create a contact group from, select the data, and press Ctrl + C keys together to copy it.

2. Shift to the People (or Contacts) view in Outlook, and click Home > New Contact Group to create a new contact group.

3. Now a Contact Group window is opening. Please click Contact Group > Add Members > From Outlook Contacts. See screenshot:

4. In the popping out Select Members dialog box, put the cursor in the Members box, press Ctrl + V keys simultaneously to paste the Excel data, and then click the OK button. See screenshot:

5. Now you return to the Contact Group window. Please type a name for the new contact group in the Name box, and then click Contact Group > Save & Close button.

So far, you have created a contact group from an Excel workbook already.

arrow blue right bubbleRelated Articles


Recommended Productivity Tools

shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121

Kutools for Outlook - More than 100 Advanced Functions for Outlook, Improve 70% Efficiency For you

  • Complicated and repeated operations can be done a one-time processing in seconds.
  • Forward multiple emails individually with one-click, and auto forward by rules.
  • Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
  • Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
  • 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    koen · 1 years ago
    unfortunately this does not work for large numbers... :-(
    • To post as a guest, your comment is unpublished.
      kellytte · 4 months ago
      Hi koen,
      For a large number of contacts, you can save the Excel workbook as a CSV file, then apply the Import feature to save these email addresses as contacts in Outlook, and finally create a new contact group and add these new contacts as members.
  • To post as a guest, your comment is unpublished.
    guest · 1 years ago
    Thank you!!! This is exactly what I was looking for. Your post is very useful. Thank you.