Subscribe to How-To Geek

How to Import Gmail Contacts Into Outlook 2007

As your email accounts and email applications change, it seems there is always a different way to get your contacts organized. Previously we covered how to Import Contacts Into Thunderbird, but today we will look at how to import important contacts from Gmail into Outlook 2007.

Importing Gmail Contacts

Exporting your Gmail contact information is basically handled the same for you to use the file to import into any email application.  Just log into your account, select Contacts and then individual or All contact then Export to a location on your hard drive.

1  1   2

Next choose Outlook’s CSV format to allow the file to easily transfer into the application.

1

The next thing we need to do is import that contacts file into Outlook 2007.  Open Outlook and click File \ Import and Export.

1

When the Import and Export Wizard opens select “Import from another program or file” then hit Next.

1

Next select “Comma Separated Values (DOS)” and click Next.

CORRECT DOS!

Browse for the Excel CSV file and choose options about duplicate entries and continue by clicking Next.

1

Here you will want to select the appropriate folder or location you want to keep the information hit Next.

1

The next screen basically verifies what we just did an also offers the option to change the destination or Map Custom Fields (which is a whole other topic we can get into at another time) hit Finish and your done.

5454545

| More
This article was originally written on 11/17/08 Tagged with: Outlook, Office, Email, Internet

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:


Name:
Email:

Comments (49)

  1. Mr. X

    How do you go the other way, synchronizing Gmail contacts with Outlook 2007? Is there anything like the Google Calendar sync program to keep them in sync?

  2. Gakera

    I have "a million" contacts from gmail days of yore and when I wanted to purge my contact list, gmail said I could only delete 20 at a time… any tips on how to go about deleting almost a 1000 contacts?

    The bad news is that now that Google Reader forced the Share feature for all contacts, I've been busy ignoring them one at a time, but I'd rather just purge all the contacts and then import the ones I do want again.

  3. Luís Artur

    Great tutorial! Too bad it doesn't work for me =(

  4. Didier A.

    Mr. X, there's a way to sync your Gmail contacts with Outlook : OggSync

    http://oggsync.com/

    By the way, it also sync your calendars, event betten than the Google App does :)

  5. Farshid

    Hi. Great tips. I translated it into Persian and put it in my blog. Thanks.

  6. martin

    Great tip sheet. easy as 123

  7. Marie Smith

    This is just what I needed. Thanks for the great information

  8. Polly

    Thanks so much, I accidentally wiped out 1000 contacts in Outlook and was able to retrieve them from Gmail by following your excellent instructions.

  9. pracas upreti

    i was hitting my head on microsoft website to import contacts from my gmail account to outlook 2007 for my company email , but there was no enough answer about it , i found it on howthegeek ,

    this is not the first time that HTG has reduced my precious time , im already a big fan of your site , its really a great site ,

    thanks again

    pracas upreti
    nepal

  10. Ferdinand

    The instructions worked as advertised.

  11. Jo

    I do all this and get to where it is importing into Outlook and every time Microsoft Outlook stops working and closes down.
    Anyone? Thanks!

  12. Lee Anne

    Sure wish my screens looked like the ones shown above!! When I select FILE in Outlook 2007 the option of IMPORT AND EXPORT doesn't even exist! How frustrating is that. Anyone else have that problem?

  13. Marco Meerman

    Works well for me! Thanks for your taken effort!

  14. Jitendra

    Great help provide…thank you.

    God Bless.

  15. KINGLIFER

    just use gsync… why make it so complicated?

  16. Angie

    Perfect. Simple and elegant. Thank you.

  17. kara

    i have followed all the steps but when i get to the last one and goto click on map cudtom fields this is greyed out
    why is this?

  18. KBebe

    This was an awesome tip sheet. So easy to use and follow!

  19. Shannon

    This importing is not working and I have tried it several times. Too bad.

  20. Shannon

    Instead of selecting COMMA SEPERATED VALUES (DOS)
    Choose COMMA SEPERATED VALUES (WINDOWS) and it will work if you are using Windows XP.

    Yay!

  21. Superman

    Awesome, worked great thanks for the help…

  22. yogesh

    i deleted 1250 contacts from out look and could get it from gmail .. ogg syn does not work creates double contact

  23. Sara

    GREAT tutorial! I used it for Yahoo! Mail, but it still worked great. :)

    Thanks so much!

  24. shea

    Didn't work for me. Outlook 2007 on Vista 64 Outlook error importing file.

  25. saurav

    viola
    it worked
    it just a magic box

  26. km

    Worked perfectly on my new Vista computer. Thanks so much.

  27. Mr Bigg

    real real good! cheers bo

  28. Shelby

    You rock! This is the 2nd tutorial of yours that I have followed and it worked great the 1st try. Thanks!

  29. darklord

    thanks dude!

  30. George Murithi

    Thanks a million, your tutorial just enlightened me a great deal.

  31. Chakra

    Thanks for your tutorial.

    It's work with me, but the bad thing is (I did not get the contacts name) I got the emails only :(

    Is there another way to Import the contacts with the name?

    Ex.
    User name

    Thanks again…

  32. giriraj bajaj

    Thanks yaar…. it really helped me immensely…. thanks a ton…

  33. Masoud Fayeq

    Folks
    The way you explained is excellent and very easy.

    Thanks a buch

  34. Biby Chalil

    thank you!! it works..

  35. bhush

    thnx buddy… it really helped.

  36. diwakar

    Thank you!! its really helpful.

  37. Aurang Zeb awan

    I love it because I was needed it most thanks budy, Ilove you

  38. Sday81

    Works perfect on XP 1st time……thanks!!!!

  39. RAJ

    Thank you so much

  40. Rishi

    You Guys Rock!

  41. Russell

    I do all this and get to where it is importing into Outlook and every time Microsoft Outlook stops working and closes down.
    Anyone? Thanks!

  42. Hauwa

    Thank you for very helpful information
    Keep up the good work

  43. bishal

    thanks for the help really it was very easy to folllow even a child cud have done with such instructions..

  44. Marco

    When I export from gmail contacts to outlook using the above instructions I lose the "+"s I have before each of my phone numbers so that when they arrive in outlook the numbers are e.g. 447720333444 instead of +447720333444. When I then sync with my mobile phone I cant call anyone as the mobile needs to have the +. Anyone know an easy way to fix this?

  45. indrajit

    super . thank youuuuuuuu very much. excellent job.

  46. Sabir Ali

    very good and easy to you.. Thanks to Share
    Good Work. God Bless U

  47. COURTNEY BIAGI

    I replaced all my contacts when I just wanted to add to them… is there a way to reverse it?

  48. Xhovalin

    great, it was very helful,

  49. Piyush

    That helps me. Now i can use Outlook completely :-) thanx


Leave a Comment




Leave your friendly comment here.

If you have a computer help question, click here to leave it on the forums instead.

Note: Your comment may not show up immediately on the site.