This guide will show you how to export your contacts from Gmail and import them into Microsoft Outlook – and help troubleshoot any issues that may arise during the process.
- Start by opening https://contacts.google.com in your browser. Select Export from the column on the left side of the page.
- Select your Contacts, then select Outlook CSV as the Export as format, and finally click the Export button.
- Now open up Outlook and select File
- Choose Open & Export from the column on the left side of the window and then Import/Export in the main panel.
- From the Choose an action to perform menu select Import from another program or file and then click the Next button.
- This time select Comma Separated Values and then click the Next button.
- Click the Browse… button next to the File to import: field.
- Navigate to the .csv file that you saved way back in step #2, select it and then click the Open button.
- Click the Next button.
- Choose Contacts (This computer) from the list of destinations, and then click the Next button.
- If you didn’t get an error, that’s great – jump down to step #15 below. If you did get a Translation Error stating that A file error has occurred in the Comma Separated Values translator while initializing a translator to build a field map – have no fear. Click OK to close the error message.
- Open up the .csv file you created/saved back in step #2 in Microsoft Excel (or Google Sheets if you don’t have Excel handy). As soon as it’s open, save it again but this time name the file as contacts2.csv or something other than whatever it was called when you downloaded it. When you save it with a new name and Excel asks if you want to keep using that format, make sure to click the Yes button.
- Back in Outlook, click the Browse… button again and this time select the newly saved version of the .csv file.
- Once again choose Contacts (This computer only) and then Next
- This time you should continue without any errors. Make sure there’s a check in the Import box and then click the Finish button.
- Outlook will now import all of the Gmail contacts. This can take anywhere from a couple of seconds to a few minutes – it depends mostly on how many contacts you’re importing. Once the process has completed open up your Address Book and make sure they’ve all been imported.
- That’s it! You’re all done.
4 thoughts on “How to Import Your Gmail Contacts Into Outlook”
thank you for the great help
This was so helpful make sure the file you import from CSV (Windows).
thanks 4 the help
I have been looking around for something like this for a while .
Thanks Guys for the help!