How to Transfer Contacts from an Excel Worksheet to Outlook

This updated guide examines How to Transfer Contacts from an Excel Worksheet to Outlook and organizes the essential facts, background, and practical takeaways in clear American English.

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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 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 — contextual image 12

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

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

FAQ

What is How to Transfer Contacts from an Excel Worksheet to Outlook about?

It provides a structured overview of import contacts into outlook, explains the main context, and highlights practical takeaways for readers.

Why does this topic matter?

Understanding the main concepts helps readers evaluate the issue, avoid common mistakes, and make better-informed decisions.

How should readers use this information?

Use the guidance as a practical starting point, confirm details that may have changed, and follow current product, safety, or security recommendations.