After running into this issue one to many times lately, I finally found a fast solution. Problem: Outlook users who want to export their address books (contacts) and import them into Gmail can get almost everything imported except street addresses. It’s maddening. Madness be gone, the solution is now just a few steps away.
Exporting your contacts from Outlook:
- Open Outlook (note this is NOT Outlook Express)
- Click File –> Import/Export
- Click Export to a file
- Click Next
- Click Comma Separated Values (Windows) option
- Click Next
- Click Contacts from the list of your Outlook items on the next screen
- Click Next
- Click Browser and choose My Documents or the Desktop as the destination for your file
- Type a name for the file (why not Contacts for Gmail)
- Click OK
- Click Next
- Click Finish
Importing your Outlook contacts into Gmail
- Log into your Gmail account
- At the top right of the screen near the sign out option, click Older version (see image above)
- Click Contacts on the left of the screen
- Click Import
- Click Browse
- Find and click the file you exported from Outlook
- Click Open
- Click Import Contacts
After the import finishes, remember to click back to the Newer Version of Gmail in the upper right of the screen.
Gmail should now have all your contacts from Outlook complete with street addresses. Come on Google, fix the import function on the newer version of Gmail!
Leave a Reply
10,000 thanks, Rick! I did not relish the prospect of entering them by hand!
Great post for moving Outlook addresses to G-mail.
Thanks.. It worked perfectly and simply.
Glad to help…now I need to research an easy method for Outlook users to import in saved email too.
[...] post last year with a guide to the full Google Contacts CSV file and another post that reveals the trick to importing Gmail Addresses by switching to the Old Version of Google Contacts (which is what I had to do last [...]
Thi worked awesome! Did I say awesome!!! I was about to lose it trying every which way to import until I found this article.
You rock.
I owe you at least one beer!
Man, thanks a lot. I spent nearly 2 hours and was about to write perl script to get the outlook export to look like the gmail export files. You would think they would fix this bug.
That seems like a huge ball dropped somewhere in Cupertino. I’m thankful for the work around though as it works like a charm. Thanks for visiting and please keep coming back!
I tried the work around by switching to older version. However, I have multiple groups and cannot how I can import them into the specific groups. One other thing, when you have multiple groups…..there is not a scroll bar for the different groups. For instance, if you save a new contact and want to see what groups they are in…all of your groups list out and you run out of space to see if you want to add or delete the contact from any groups. This is very frustrating because I love gmail.
I agree. Gmail’s most glaring weakness is the Contacts module. Although it works well, it lacks much of the polish that you would expect. They will continue to improve it, but I hope it is sooner than later.
It´s amazing!!! I did it!!!
Useful and clear. Thanks.
Great job. I couldn’t import my contact list at all until I tried this trick!
Perfect!! I was pulling out my hairs and this was perfect. Thanks again!
Can anyone help me merge outlook groups into gmail? Thank you.
You will have to rebuild those manually in the Gmail Contacts. I have never found away to have it import mailing groups automatically.