Home » Blog » Consumer Tutorial » How to Create a Distribution List in Outlook 2016 from Excel – Ultimate Guide
Consumer Tutorial, File Format, Mac Outlook, Microsoft Office

How to Create a Distribution List in Outlook 2016 from Excel – Ultimate Guide

Ugra Narayan Pandey | Modified: 2021-11-09T18:50:42+05:30 | 4 Minutes Reading

Imagine you are working with an organization and you received an Excel file that contains a list of new client contacts, now you have to group all of these contacts to a single Outlook Distribution List. So what will you do?

how to import Excel spreadsheet into Outlook Distribution List

Because collecting and sharing of contacts is an essential part of the corporate world. But, there are lots of people face the problem while getting them into there email client. Then, they start searching queries like how to import Excel spreadsheet into Outlook Distribution List?

Well, then no need to worry about because in this article we are going to discuss How to create a Distribution List in Outlook 2016 from Excel in simple ways.

But, before starting let’s discuss some of the terms which are used in the article:

Excel – Microsoft Excel is a software which used to create a spreadsheet, which contains data in tabular form. Excel create various file format like CSV/ XLS/ XLSX/ XLSM/ ODS/ OTS and many more.

excel-file

Outlook Distribution List – Just like the WhatsApp group distribution list is a group of Outlook, it is used to send emails to a group of people without entering the recipient of each email address. It also knows as Contact Groups.

import Excel spreadsheet into Outlook Contact Group

Import Excel file into Outlook Contact Group/ Outlook Distribution List

There is no manual method available to convert Excel file to Outlook Distribution List. So professionals use an automated way to complete this task.

Convert Excel Spreadsheet to Outlook Distribution List – Best Solution

Excel to vCard Converter is the best-automated software to resolve queries like how to turn an Excel spreadsheet into an Outlook Distribution List.

Download Free Purchase Now

Follow the steps below for importing an Excel file into Outlook Distribution List:
Step 1 – Click on the Browse button and select the Excel file then click on the Open button

how to import Excel spreadsheet into Outlook Distribution List

Note – If the file name other then (XLSX, XLS, CSV) the type First letter of the file.

Step 2 – After that, the software will show you all the content of the selected file

import Excel spreadsheet into Outlook Contact Group

Step 3 – Now, click on the Next button to continue the conversion process
Step 4 – To match the Excel with Outlook attributes to choose the Outlook attributes
Step 5 – Now, match the fields in this way :
• First Name –>> First Name
• Last Name –> Last Name
• Email –>> Email Address

importing an Excel file into Outlook Distribution List

Step 6 – After, matching the field, click on the Add button. Then the software will show you all the matched attributes.
Step 7 – in this step there is two option available:
Allow Empty Email address to be Imported – This option allows to convert contacts with empty email addresses fields.
Single vCard File for All Contacts – This option creates a single vCard for all contacts and creates individual VCF for each contact.
So, choose the options you want to import Excel spreadsheet into Outlook Distribution List.

import Excel spreadsheet into Outlook Distribution List

This software supports all versions of vCard i.e. v2.1, v3.0, v4.0.

Note – If you want to import vCard into iCloud then select vCard version 3.0 or 4.0

Step 8 – Select the desired location on your system and click on the OK button.

Step 9 – Now, click on the Convert button to start the conversion.

how to turn an Excel spreadsheet into an Outlook Distribution List

Step 10 – Software will create a separate vCard file for each contact file and save them at your location.

how to import Excel spreadsheet into Outlook Distribution List

Step 11 – After this, open MS Outlook and choose the File menu from the navigation panel

importing an Excel file into Outlook Distribution List

Step 12 – Click on Open & Export option to begin import Excel file into Outlook Contact Group process

import Excel file into Outlook Contact Group

Step 13 – Then select an option Import a vCard file and choose Next button

how to import Excel spreadsheet into Outlook Distribution List

Step 14 – After that, you need to choose a vCard file that you want to import

import Excel file into Outlook Contact Group

Step 15 – Click on Next button to complete the task

Note – If you have (.csv) file then you can easily import Excel spreadsheet into Outlook Contact Group.

Additional Tip

This is How to Create Distribution list in Outlook
Step 1 – On the Home page of Outlook, click on Address Book option to open your Address Book
Step 2 – Now, select Contacts from the list of Address Book
Step 3 – Open the File menu and click on New entry
Step 4 – Under the Select the entry type option, click New Contact Group
Step 5 – Under Put this Entry option, click In The Contacts
Step 6 – Now, click on OK button to complete the process

Now, you know How to create a Distribution List in Outlook 2016 from Excel simply and smartly. So, you just need to follow the steps which are mentioned above to complete the task.