by The tutorial shows how to export contacts from Outlook to Gmail and import Google contacts to Outlook step-by-step.
Switching between Microsoft Outlook and Google Gmail is a very common trend these days. Some people are migrating from a desktop-oriented Outlook app to a cloud-based Gmail while others are using different email clients for their personal and business communication. If you already have a bunch of contacts in one email app, you certainly wouldn't want to re-create them in the other app one by one. Luckily, both Outlook and Gmail make it possible to transfer all your contacts in one go. It's not a one-click operation, but we will comfortably guide you through all the steps.
How to import Outlook contacts to Gmail
To transfer your contacts from Outlook to Google Gmail, you will first need to export them from Microsoft Outlook as a CSV file, and then import that file to Google Gmail.
Part 1: Export contacts from Outlook
The fastest way to export Outlook contacts is by using the inbuilt wizard that will walk you through the process:
- In your Outlook desktop app, click File > Open & Export > Import/Export.
- Choose Export to a file and click Next.
- Select Comma Separate Values and click Next.
- Scroll up or down to the target account/mailbox, select the Contacts folder and click Next.
- Click the Browse button, then select the destination folder, name your .csv file, and click Next.
Note. If you've exported your Outlook contacts before, the previous location and file name will appear automatically. If you don't want to replace an existing file, be sure to give your CSV file a different name.
- Click Finish and Outlook will start exporting your contacts immediately.
Tip. If you want to control what information is saved to the CSV file, click the Map Custom Fields button, and do manual mapping.
To make sure that Outlook has successfully exported all of your contacts, open the newly created CSV file in Excel to view the information.
Tips and notes:
- The wizard only exports the contacts in your personal contact list, but not the ones in your organization's Global Address List (GAL) or any kind of Offline Address Book. If you'd like to transfer an Exchange-based contact list too, first add its items to your personal Contacts folder, and then export. For more info, please see How to export Global Address List from Outlook.
- If you wish to export only a specific category of contacts, say personal or business, follow the instructions provided in How to export Outlook contacts by category.
- If you are using the online version of Outlook, the steps can be found here: Export contacts from Outlook.com and Outlook on the web.
Part 2: Import Outlook contacts to Gmail
To import your Outlook contacts into Gmail, this is what you need to do:
- Log in to your Google Gmail account.
- At the upper-right corner of the page, click the Google apps icon, and then click Contacts. Or go directly to your Google Contacts.
- On the left, under Contacts, click Import.
- In the Import contacts dialog window, click Select file and choose the CSV file you've exported from Outlook.
- Click the Import button.
As soon as the import is completed, the All done notification will appear at the bottom-right corner of the page. If you've inadvertently imported a wrong list of contacts, just click Undo.
Note. For importing to complete correctly, your Gmail account must have the same language as was set in Outlook when exporting contacts. Otherwise, the column headings won't match and you'll get an error.
How to import Gmail contacts to Outlook
To transfer Google contacts to Outlook, first export your Gmail contacts to a CSV file, and then import that file into Microsoft Outlook.
Part 1: Export Gmail contacts
- Go to your Google Contacts.
- On the left, under Contacts, click Export.
- In the Export contacts window that pops-up, select Outlook CSV and click Export. This is the key step that will copy your Google contacts to a .csv file in the format required by Outlook, so no further adjustments will be needed.
- Depending on your browser, you will either be prompted to open the file in Excel or just see the downloaded contacts.csv file at the button of the page. After opening the file, review the info, make changes if needed (but do not change the column headers!), and then save the CSV file to any folder on your PC or to a cloud storage.
Part 2: Import Gmail contacts into Outlook
To import your Google contacts to Outlook, perform these steps:
- In Microsoft Outlook, click File > Open & Export > Import/Export.
- In the first step of the Import and Export wizard, choose Import from another program or file and click Next.
- Choose Comma Separated Values and click Next.
- Click the Browse button and select the CSV file you've exported from Gmail. Then, choose how to deal with possible duplicate contacts (the screenshot below shows the default option), and click Next.
- Under the account into which you want to import Gmail contacts, select the Contacts folder and click Next.
- Click Finish.
Tip. To make sure that all the columns in your CSV file are correctly mapped to the Outlook contact fields, click Map Custom Fields.
Outlook starts importing your Google contacts immediately. When the progress box is gone, the import is finished. To view the imported contacts, click the People icon on the Navigation bar.
That's how to import contacts from Outlook to Gmail and the other way round. That was pretty easy, wasn't it? I thank you for reading and hope to see you on our blog next week!
14 comments
Once Outlook contacts have been imported to Google Contacts, how do you get them to sync?
Thank you for your support, I was about to throw my phone out the window, lol.
Hello Janice,
There is built-in tool to sync Outlook and Gmail contacts automatically, as they have separate address books. However, there are a few third-party free tools to keep your Outlook and Google contacts synced. We have not used any of those tools ourselves, therefore cannot recommend any specific one.
An excellent tutorial, thank you for sharing this post. This is really helpful.
An excellent tutorial, thank you: I've saved a bookmark on Diigo for future reference!
Same issue as Kim >>>
I keep getting a Translator error. It wont transfer the information from Gmail to Outlook. I can create the file and save it, but when I try to import it, I get the error that it is either in use somewhere, or I don't have permission to access the file. This is on my computer, so I can't see the access being an issue. I closed down everything, restarted the computer and only opened Outlook to import the file. Still getting the error.
The error says:
"An error has occured in the CSV translator while initiating a translator to build a field map". Outlook can't retrieve the file information due to either I don't have permission to access the file, or it is open elsewhere.
Any help?
I keep getting a Translator error. It wont transfer the information from Gmail to Outlook. I can create the file and save it, but when I try to import it, I get the error that it is either in use somewhere, or I don't have permission to access the file. This is on my computer, so I can't see the access being an issue. I closed down everything, restarted the computer and only opened Outlook to import the file. Still getting the error.
The error says:
"An error has occured in the CSV translator while initiating a translator to build a field map". Outlook can't retrieve the file information due to either I don't have permission to access the file, or it is open elsewhere.
Any help?
I need help with this too! Does anyone look at these questions?
will the new file overwrite or just add to existing contacts already in gmail
Finally, after several tries I copied the Outlook contacts to Google. Not a clean copy process , though. Google mixes up files that show company names only, randomly assigning first and last names from the company name seemingly just to fill in the name spaces. The Google list dot bubble shows only the first letter of what ever fell in the first name slot, but I want it to show the first letter of the last name, or the first letter of the company name. Then the index location uses that whatever name fell in the last name space that I left blank, which means that letter in the dot bubble is meaningless. I can't find how to change the dot bubble letter. Also, I had several google contacts with invented nicknames that made no sense, such as I.A.M.C.A.P instead of AMCAP.
Oh well, I paired the list down to 200 or so contacts that need editing. At least I didn't have to make new entries for each contact. I also liked that my Outlook notes for each contact were copied to Google as well. Outlook is okay but not very simple to work. Google certainly has room to improve, but I'll stick with it as the cross-platform capability is much more convenient and easier to use.
Can I edit the CSV fur before I import it? I may want to exclude the contacts I’ve already added manually (A-B)
That was supposed to say CSV file! Autocorrect strikes again...
You forgot one step when importing contacts to gmail. You must have the same language choosen in gmail as Outlook used when creating the contacts file. I guess gmail checkes the column headings when importing, because I got an error before I changed the gmail language setting.
Hi Glenn,
Thank you for this very helpful tip! I've added the corresponding note to the tutorial.