How to transfer contacts from an Excel worksheet to Outlook

You can easily export contacts and contacts stored in Excel for import into Outlook by saving the worksheet in CSV format.

You can easily export contacts and contacts stored in Excel for import into Outlook by saving the worksheet in CSV format. So how to do specific? Invite you to follow the article below of TipsMake.com.

Step 1: Save contacts as CSV file

The contact list below is stored in an Excel spreadsheet. Note the fields should be in the same format.

How to transfer contacts from an Excel worksheet to Outlook Picture 1 — Save contacts in Excel with corresponding fields to import into Outlook

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

How to transfer contacts from an Excel worksheet to Outlook Picture 2 — Save the file as a CSV

Choose a save location, name it, then select the CSV file type (Comma Delimited) in Save as type.

How to transfer contacts from an Excel worksheet to Outlook Picture 3 — Choose where to save the file as a CSV file

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

Step 2: Transfer contacts to Outlook

To transfer contacts on the newly saved Excel file to Outlook, open Outlook, click File> Open & Export> Import / Export.

How to transfer contacts from an Excel worksheet to Outlook Picture 4 — Click File> Open & Export> Import / Export in Outlook

Next, in the Import and Export Wizard , click Import from Another Program or File and then click Next.

How to transfer contacts from an Excel worksheet to Outlook Picture 5 — Select Import from Another Program or File

Next interface, select Comma Separated Values and then Next .

How to transfer contacts from an Excel worksheet to Outlook Picture 6 — Select Comma Separated Values

Click the Browse button to find the CSV file you want to import.

Select an option you want Outlook to handle duplicates and click Next.

How to transfer contacts from an Excel worksheet to Outlook Picture 7 — Find the location of the CSV file you want to import

In this example, TipsMake.com selects Replace Duplicates with Items Imported , which means that existing contacts in Outlook will be overwritten by the information contained in the imported file.

Next, select the correct Contacts folder on Outlook so that the contacts to be transferred will be here.

How to transfer contacts from an Excel worksheet to Outlook Picture 8 — Selecting the Outlook folder will move the contacts into

Click Map Custom Fields to exactly match the fields from the Excel spreadsheet to the corresponding fields in Outlook.

How to transfer contacts from an Excel worksheet to Outlook Picture 9 — Click on Map Custom Fields

In the Map Custom Fields dialog box that opens, the fields in the CSV file will appear in the From table on the left, and To on the right are the fields from the Contacts folder in Outlook.

How to transfer contacts from an Excel worksheet to Outlook Picture 10

Successfully matched fields appear in the Mapped From column on the right.

For non-matching fields, such as Email Address in the table, click and drag the From to To field, then select OK to complete.

How to transfer contacts from an Excel worksheet to Outlook Picture 11 — Manually match fields in CSV files and Contacts in Outlook

The conversion window appears, notifying the process that took place.

How to transfer contacts from an Excel worksheet to Outlook Picture 12

Wait for the process to finish, your contacts have been transferred from the CSV file to Outlook. Simple as that. Please try it!

See more:

Instructions for scheduling sending emails and delaying sending emails in Outlook
Instructions for basic steps to backup Outlook data
Assign more Background images to emails in Outlook