See More About: , ,

How to Import Your Contacts into Outlook 2010

by

When I began using Outlook 2010 the first thing that I noticed was the dramatic change of the File menu compared to 2007 and previous versions of Office. Microsoft has done a great job of condensing the menu and making it easier to navigate, however for those of us who are used to the location of items on the menus it can be a little time consuming to locate what you need.

This was the case with the Import/Export Wizard that is normally found in the File menu (see screenshot below). The item is now tucked away in the Save options in the File menu. The how-to below will walk you through the steps necessary to import contacts from a .CSV file to Outlook 2010’s contact list.

If you have any comments please post them below or if you need help visit our forums.

import contacts in outlook 2010 0 How to Import Your Contacts into Outlook 2010

Import menu in Outlook 2007

Note: I used Windows 7 Ultimate and Outlook 2010 Beta.

Importing the CSV File

import contacts in outlook 2010 How to Import Your Contacts into Outlook 2010

1. Click on File to open the menu.

2. Click on Open which will expand the Open submenu.

3. Click on Import to open the Import and Export Wizard


The Import and Export Wizard will open.

import contacts in outlook 2010 a How to Import Your Contacts into Outlook 2010

4. Select the action you wish to perform. In this case we are importing a file from another program. Click on Import from another program or file.

5. Click Next to proceed.

import contacts in outlook 2010 b How to Import Your Contacts into Outlook 2010

6.Choose the file type to import from, in this case we are importing from a CSV (Comma Separated Value) file.

7. Click Next to proceed.

import contacts in outlook 2010 c How to Import Your Contacts into Outlook 2010

8. Click on Browse to locate the file you wish to import from.

import contacts in outlook 2010 d How to Import Your Contacts into Outlook 2010

9. Locate and select the file you wish to import from.

10. Click OK to select the file and proceed.

import contacts in outlook 2010 e How to Import Your Contacts into Outlook 2010

11. You are presented with 3 options when importing contacts;

  • Replace duplicates with items imported
  • Allow duplicates to be created
  • Do not import duplicate items

Choose the option that best fits your needs.

12. Click Next to proceed.

import contacts in outlook 2010 f How to Import Your Contacts into Outlook 2010

13. Click on Contacts to specify it as the destination of the items being imported.

Note: If you have multiple Outlook files this step in the wizard will allow you to specify a different folder other than the default.

14. Click Next to proceed.

import contacts in outlook 2010 f1 How to Import Your Contacts into Outlook 2010

15. Verify that everything is correct then click Finish to start the import process.

import contacts in outlook 2010 g How to Import Your Contacts into Outlook 2010

Progress of contacts being imported…

import contacts in outlook 2010 h How to Import Your Contacts into Outlook 2010

Once the import process is finished you should see the items that were imported in your Outlook contact list.

See More About: , ,
Originally posted Mar 03, 2010

We close comments after 30 days on GilsMethod.com and ask that you post questions and issues on our Answers website.

This helps us better serve you by allowing us to keep track of unanswered questions that are usually hidden in long comment threads.

Answers.GilsMethod.com is a community-powered support website where you will be able to post questions, and other users including us will respond with expert advice.

So if you are having trouble with your PC, Mac, iPad, iPhone, or other piece of technology, head over to Answers.GilsMethod.com and ask away.

  • Klpmoyer

    I’m comfortable with the process, but need to confirm the layout of my file. I have a file with first and last name in two fields – do you have any information on the format of the excel file before I attempt this import?

    • http://www.gilsmethod.com Gilberto J Perera

      What’s the source of the CSV file? Mine was from Google Contacts which keeps
      the name and last name separate. You may want to give it a try…you can
      always delete the imported contacts if it didn’t pan out.

      Like the GilsMethod.com Facebook page for a
      chance to win an iPod Touch and other prizes.

    • Klpmoyer

      Source is Excel. I’m just wondering if there needs to be a header row that references the same field names as Outlook – and/or if I really should be mapping or not. attempted import, but no records came in.

    • http://www.gilsmethod.com Gilberto J Perera

      Have you tried mapping it or adding headers to the file? Let me know, the
      easiest way to do this is probably to map the fields.

      Like the GilsMethod.com Facebook page for a
      chance to win an iPod Touch and other prizes.

  • KenB

    Thanks! Saved me who knows how much time over trying to use the Microsoft Help!

  • Smknjoe78

    Hey Gil, Very helpful thanks for what you do.

  • Khaxel

    When I try this, I get an error that says “an error has occurred in the microsoft outllook office translator while initializing a translator to build a field map. Unable to load file access engine.”

    What?????????????????

    • Drennen

      Same problem here.

  • Maxchoy

    This is the best article which need not any $ to do so..done well dude!

    • http://www.gilsmethod.com Gilberto J Perera

      No problem, glad you found it useful.

    • http://www.gilsmethod.com Gilberto J Perera

      No problem, glad you found it useful.

  • http://www.bustersanimation.com 122.224.33.4:80

    I agree with everything that was posted in this article, I’m a faithful follower so make sure you keep updating so often!

  • http://www.bustersanimation.com 122.224.33.4:80

    I agree with everything that was posted in this article, I’m a faithful follower so make sure you keep updating so often!

  • http://www.facebook.com/office kim_office_team

    Hi Gil,

    This a great how to! Thanks so much for posting it. I'm sure the Office team would really value hearing about your feedback on Office 2010 Beta. Please, share your expertise and thoughts at the Office page on Facebook. Join here: http://www.facebook.com/office.

    Thanks again for sharing this great tutorial with your community.
    Cheers,
    Kim
    Microsoft Office Outreach Team

    • http://intensedebate.com/people/gjperera gjperera

      Kim – Thanks for the feedback…there are a whole lot of Office How-to's coming up. I'm using the Send a Smile to send feedback, but I'll make sure to stop by the Office FB page…I'm trying to get my hands on RC any chance you could help with that?

  • http://www.facebook.com/office kim_office_team

    Hi Gil,

    This a great how to! Thanks so much for posting it. I'm sure the Office team would really value hearing about your feedback on Office 2010 Beta. Please, share your expertise and thoughts at the Office page on Facebook. Join here: http://www.facebook.com/office.

    Thanks again for sharing this great tutorial with your community.
    Cheers,
    Kim
    Microsoft Office Outreach Team

    • http://intensedebate.com/people/gjperera gjperera

      Kim – Thanks for the feedback…there are a whole lot of Office How-to's coming up. I'm using the Send a Smile to send feedback, but I'll make sure to stop by the Office FB page…I'm trying to get my hands on RC any chance you could help with that?