Creating Outlook Group from CSV

I recently came across a need to create a group in Outlook from a comma separated value (csv) file. Outlook has import and export features, but those tools won’t allow you to create a group directly–it will just add a bunch of contacts from a csv and if you have hundreds of contacts that just isn’t an option. This tutorial is based upon Outlook 2016 running on Windows 7. There may be differences in other versions and platforms. Assuming you already have a csv file with first name, last name, and at least an email address, lets get started!

  1. Open Outlook and navigate to the contacts (or people) view:

    Outlook Contact View

  2. Select ‘New Contact Group’ from the menu bar:

    New Contact Group

  3. Enter a name for your group in the ‘Name’ box and use the drop down menu on ‘Add Members’ to select ‘From Outlook Contacts’:

    Add Members from Outlook Contacts

  4. Copy Fields from your csv file:

    Copy Fields

  5. Paste directly into ‘members’ box and press ‘OK’

    Paste Fields

  6. Select ‘Save and close’

Your new group should now be visible in your contacts view and available for you to use.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.