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:
- 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
You should read it
- How to Block Contacts on Outlook Mail
- How to export contacts from Gmail?
- Instructions on how to share contacts in Microsoft Outlook
- How to Convert Vcard Contacts to Microsoft Outlook Format
- How to set up Email, calendar, Outlook contacts on iPhone or iPad
- Add contacts to Outlook.com Email
- How to insert an Outlook contact in Word
- Instructions on how to use Outlook 2013 for new people
- How to fix Outlook error 0x800CCC0E
- Instructions for deleting duplicate contacts on Android
- List of Outlook 2016 shortcuts when working with Mail
- How to Import Contacts from Excel File to Android Phone
May be interested
How to create text color changing effects in PowerPoint
Set of beautiful, professional 3D Powerpoint wallpapers
How to insert background for Google Slides
How to use the MEDIAN function in Google Sheets
Customize settings or change Microsoft Office with Office Deployment Tool
How to combine Index and Match functions in Excel