How to Import Excel List Into Outlook Contacts

With so many different programs available for managing your email and your email messages, you will probably switch from one program to another at some point in your life. However, the process for exporting your contacts from the old email account into the new one might not be immediately obvious. Most email programs are capable of outputting all of your contact information in an Excel list, of the CSV file type. This list is actually a spreadsheet containing fields and records for each of the contacts in your old email address. When you are switching to Microsoft Outlook 2010 as your new email program, it is possible to import that Excel list directly into your Contacts address book.

 

Import Your Old CSV Contact List Into Outlook 2010

 

Begin the process of getting your CSV contacts into Outlook by launching Outlook 2010. Click the orange File tab at the top-left portion of the Outlook program window, then click the Open option at the left side of the window.

launch outlook's import and export wizard

 

The next thing to do is click the Import button at the center of the window, which will open a new Import and Export Wizard window in Outlook. Click the Import from another program or file option, then click the Next button at the bottom of the window.

import from another program or file

 

Click the Comma Separated Values (Windows) option, then click the Next button again.

choose the file type of the program you are importing

 

Click the Browse button at the top of the window, then locate the CSV Excel list that you want to import into Outlook 2010. Choose the option that you want to use to handle any duplicate contacts files that Outlook may encounter, then click the Next button.

select the excel list file you are importing

 

Click the Contacts option under the Select destination folder option, then click the Next button again.

choose the contacts folder as the destination for your imported file

 

Click the Finish button to complete the process of importing your Excel list into the Outlook Contacts folder.

import excel list to outlook contacts

 

If the information does not import properly, you may need to redo the process and click the Map Custom Fields button on the last screen. This screen looks like the image displayed below. The column at the left side of the window indicates the fields that are defined in the Excel list that you are trying to import, and the fields in the column at the right side of the window are the contact fields in Outlook. You need to map the appropriate field from the Excel list to the appropriate Outlook field by dragging from the left column to the right column. For example, you would drag the First Name item from the left column to the First Name item in the right column. Once all of the fields have been mapped correctly, click the OK button at the bottom of the window.

map custom fields when importing excel list to outlook