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. 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.

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

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

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.

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

Next interface, select Comma Separated Values and then Next .

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.

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.

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

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.

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.

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

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:

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