Excel Logo

Contact details stored in an Excel Worksheet can be easily exported and then imported into Outlook. Once the Excel file is saved to a CSV format, you can import it into your Outlook contacts list.

Save Your Contacts as a CSV File

The contacts list below is stored in an Excel worksheet. Ensure your Excel spreadsheet is labeled in a similar fashion.

Contacts list in Excel

To export the document as a CSV, first click “File” to open the menu. Next, select Save As > Browse.

Save as as different file type in Excel

Specify the location for the saved file on your computer and then select “CSV (Comma Delimited)” from the Save as Type list. Click the “Save” button.

Save as a CSV file type

Close the Excel workbook. The contacts are ready to be imported into Outlook.

Import Contacts from a CSV File into Outlook

Open Outlook and then click on “File” to open the menu. From there, select Open & Export > Import/Export.

Import a file into Outlook

Select “Import from Another Program or File” and then click the “Next” button.

Import contacts from other file

Highlight the “Comma Separated Values” option and then click the “Next” button.

Select comma separated values

Select the “Browse” button to find the CSV file you want to import.

Choose an option for how you would like Outlook to handle duplicate contact details and click the “Next” button.

In this example, “Replace Duplicates with Items Imported” is selected. This will update the existing contacts in Outlook with the latest contact details.

Browse for contacts list and replace duplicates

Select the destination folder for the imported contacts and then click the “Next” button. The destination folder will probably be the Contacts folder, but it could be a different folder that can store contact details.

Select the destination folder for the contacts

Ensure that the action to import your contacts list into Outlook is selected.

Click the “Map Custom Fields” button. This will enable us to correctly match up the column headers from the Excel spreadsheet to the corresponding fields in Outlook.

Confirm import contacts actions

In the Map Custom Fields Window, the fields from the CSV file appear in the “From” pane on the left. In the “To” pane on the right, the fields from the Contacts folder in Outlook are shown.

Any fields that have already been successfully matched are listed under the “Mapped From” column on the right.

Mapping fields when importing contacts

The Email Address field was not matched. To fix this, click and drag the Email Address field from the left to the right. Doing so will map the field. Click the “OK” button to proceed.

Mapping the email address field

A window might appear to show the import progress.

Importing contacts data

The contacts should now have been successfully imported into Outlook.

Contacts imported successfully

Alan Murray Alan Murray
Alan Murray has worked as an Excel trainer and consultant for twenty years. On most days, he can be found teaching Excel in a classroom or seminar. Alan gets a buzz from helping people improve their productivity and working lives with Excel.
Read Full Bio »