How to Import Contacts to Outlook 2010 from Excel 2010

Just as you can export contacts from Outlook 2010 to a CSV file, you can also import contact data saved in an Excel file to your Contacts folder in Outlook 2010 without too much trouble. In this Outlook 2010 tutorial, you will learn how to import contacts from Excel to your Outlook Contacts folder.

How to Import Contacts from Excel to Outlook 2010 Contacts

1. Select the File tab and choose Open.

outlook import

2. In the right pane, click Import.

outlook import option

3. In the Import and Export wizard, select Import from another program or file and click Next.

How to Import Contacts from Excel

4. In the Import a File dialog box, select Microsoft Excel 97-2003 and click Next.

import a file

5. In the File to import section, click Browse, navigate to the location with the Excel sheet and select the file that you want to import.

6. If necessary, in the Options section, select an option to add, remove, or replace duplicate email addresses.

7. Click Next.

8. In the Select destination folder list box, select the contacts folder in which you want to import the contacts and click Next.

9. Verify that you are importing the correct data and click Finish.

In this tutorial, you learned how to import contacts from Excel to Outlook 2010. Importing contact information from Excel to Outlook 2010 will enable you to sync the data between different applications easily.

Comments

  1. Martin Hill says

    At the importation browse point, Outlook doesn’t recognise an Excel file, only a comma-separated DOS file, which it then refuses to import. No-one on the web appears to have actually tried to use what he or she describes.

    I f anyone has successfully imported in practice from gmail to Outlook, please tell me how!

    • Adeline says

      Hi Martin,
      If you have exported your Gmail contacts using the option “Outlook CSV format (for importing into Outlook or another application)”, please select Comma Separated Values (DOS) in the Import a File wizard. Outlook will recognize the CSV file and you will be able to import the file to Outlook. This has been tested on my machine running Windows 7 Outlook 2010. Let me know if you still have problems. Cheers,
      Adeline
      P.S: This tutorial is to import contacts from an Excel file in XLS format, not a CSV file.