How to import Contacts from a CSV file into Outlook

Outlook 2016
Outlook proposes easy and fast way to import contacts from the CSV file to your Outlook. It can be prepared in Excel or saved in another Outlook instance (see How to export Outlook Contacts to a CSV file).

   1.   On the File tab, click the Open & Export button:

Open and Export in Outlook 365

   2.   On the Open pane, click the Import/Export button:

Import/Export in Outlook 365

   3.   In the Import and Export Wizard dialog box, choose the Import from another program or file option, and then click Next >:

Import and Export Wizard in Outlook 365

   4.   In the Import to a File dialog box:

   4.1.   Choose the Comma Separated Values option, and then click Next >:

Select file type to import from in Outlook 365

   4.2.   Click the Browse... button:

File to import in Outlook 365
  • In the Browse dialog box, choose the CSV file that contains the contacts that you want to import.
  • Choose one of the options:
    • Replace duplicates with items imported – select this option only if you are sure that imported data is more recent or more complete.
    • Allow duplicates to be created – select this option to keep all duplicates.
    • Do not import duplicate items – select this option to add just new data from the imported file.
  • Click Next >.

   4.3.   Select the Outlook folder into which you want to import the Contacts. It can be the Сontacts folder in the current account, or a Contacts folder in any of other folders.

Select destination folder in Outlook 365

Click Next >.

   4.4.   If it is necessary, click the Map Custom Fields... button:

Map Custom Fields in Outlook 365

In the Map Custom Fields dialog box, map all columns from the CSV file to the fields of the Outlook address book. Outlook automatically maps some fields; change these if they are not mapped correctly.

To map a field, drag the Value to the desired Field:

Map Custom Fields in Outlook 365

After mapping, click OK, and then in the Import a File dialog box, click the Finish button to begin the import process.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.