Maybe you have recently started using Outlook email program or you just wish to have access to contacts added on other email accounts, whatever be the reason, you can easily import contacts from other email account using Excel or a CSV file to your Outlook email account. To know how to import your Contacts from other email accounts using Excel or a CSV file to your Outlook email account, follow the step-by-step instructions provided below.
Steps to Import Contacts from Excel or a CSV File into Outlook
For Newer Versions
When you have plenty of personal or business contact information stored in a spreadsheet, it is best to import to your Outlook 2013 or Outlook 2016. This is how you can do it:
Save Excel documents containing contacts as a .csv file
- Click on the worksheet with the contact information you wish to import in your workbook.
- Next, click on the File option and choose Save As menu from the menu.
- Then, you will need to select the location where you wish to save the file.
- After that, select the CSV option, click on the Save option, then on the OK button and finally on the Yes
- The CSV file of your contact will be created.
Import your Contacts
- In your Outlook program, click on the File option located at the top-left corner on your Outlook ribbon.
- Next, you will need to select Open & Export option and then click on the Import/Export
- Select Import from another program or file option and click on the Next
- Then, locate the .csv file you wish to import on your computer.
- Go to Options, select whether you wish to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates.
- After that, click on the Next option and select the destination folder for your contacts. Although Contacts is selected by default, however, if it isn’t, just scroll up or down to find it. Optionally, you can also select a different folder or you can create a new one.
- Then, click on the Next button and make sure that you have selected the checkbox next to Import “Your Contact’s CSV file”.
- Now, before clicking on the Finish button, you will need to map some of the columns of your CSV file to the contact fields in Outlook. Below you can find the steps to map the columns of your CSV file.
All you need to do is map the Excel Spreadsheet columns with the relevant Outlook fields.
- Click on the Map Customer Fields This will open the Map Customer Fields dialog box on your screen.
- Next, go to “From” Here, you will see a box with column names from the CSV file you are trying to import.
- Then, go to “To” section where you will see the fields used by Outlook for contacts. If a field will match the column in the CSV file, your column will appear under Mapped from.
- The fields that read Name, First Name, and Last Name are standard Outlook contact fields. If the contacts information in your file contains those contact names, you can proceed further.
NOTE: Sometimes, the column appearing in the From field might not have an exact match in Outlook. In such a case, you can find a suitable match by scrolling in the pane on the right section, selecting the + icon located next to Other Address option and finding the appropriate option from the given options. After that, drag the particular values from the left-hand side and drop it to the relevant field in the right-hand side pane. Similarly, you can drag the rest of the values from the left to the right section.
- Finally, click on the Finish Your contacts will be imported to your Outlook.
- Now to view your contacts in Outlook, go to the bottom of the navigation bar and select the People
And this is how you can easily import contacts from Excel or a CSV file into Outlook.
More Details: How to Contact Outlook Support