Home / Blog / How to Export Contacts from an Excel Worksheet to Outlook

How to Export Contacts from an Excel Worksheet to Outlook

Excel Logo

Contact particulars saved in an Excel Worksheet could be simply exported after which imported into Outlook. As soon as the Excel file is saved to a CSV format, you’ll be able to import it into your Outlook contacts listing.

Save Your Contacts as a CSV File

The contacts listing beneath is saved in an Excel worksheet. Guarantee your Excel spreadsheet is labeled similarly.

Contacts list in Excel

To export the doc as a CSV, first click on “File” to open the menu. Subsequent, choose Save As > Browse.

Save as as different file type in Excel

Specify the placement for the saved file in your laptop after which choose “CSV (Comma Delimited)” from the Save as Kind listing. Click on the “Save” button.

Save as a CSV file type

Shut the Excel workbook. The contacts are able to be imported into Outlook.

Import Contacts from a CSV File into Outlook

Open Outlook after which click on on “File” to open the menu. From there, choose Open & Export > Import/Export.

Import a file into Outlook

Choose “Import from One other Program or File” after which click on the “Subsequent” button.

Import contacts from other file

Spotlight the “Comma Separated Values” possibility after which click on the “Subsequent” button.

Select comma separated values

Choose the “Browse” button to seek out the CSV file you need to import.

Select an possibility for the way you want to Outlook to deal with duplicate contact particulars and click on the “Subsequent” button.

On this instance, “Substitute Duplicates with Objects Imported” is chosen. This may replace the present contacts in Outlook with the most recent contact particulars.

Browse for contacts list and replace duplicates

Choose the vacation spot folder for the imported contacts after which click on the “Subsequent” button. The vacation spot folder will most likely be the Contacts folder, nevertheless it might be a distinct folder that may retailer contact particulars.

Select the destination folder for the contacts

Make sure that the motion to import your contacts listing into Outlook is chosen.

Click on the “Map Customized Fields” button. This may allow us to appropriately match up the column headers from the Excel spreadsheet to the corresponding fields in Outlook.

Confirm import contacts actions

Within the Map Customized Fields Window, the fields from the CSV file seem within the “From” pane on the left. Within the “To” pane on the suitable, the fields from the Contacts folder in Outlook are proven.

Any fields which have already been efficiently matched are listed underneath the “Mapped From” column on the suitable.

Mapping fields when importing contacts

The Electronic mail Deal with discipline was not matched. To repair this, click on and drag the Electronic mail Deal with discipline from the left to the suitable. Doing so will map the sector. Click on the “OK” button to proceed.

Mapping the email address field

A window would possibly seem to point out the import progress.

Importing contacts data

The contacts ought to now have been efficiently imported into Outlook.

Contacts imported successfully

About Alan Murray

Check Also

How To Backup Your Kindle Highlights and Notes

Khamosh Pathak In the event you’re within the Kindle ecosystem, your guide highlights and notes …

Leave a Reply

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

Advertisements