How to Import Your Gmail Contacts Into Outlook

March 23, 2021 / By

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.

  1. Start by opening https://contacts.google.com in your browser. Select Export from the column on the left side of the page.

    2. an arrow pointing to an Export button

  2. Select your Contacts, then select Outlook CSV as the Export as format, and finally click the Export button.

    3. exporting gmail contacts to a .csv file

  3. Now open up Outlook and select File

    4. an arrow pointing to the File menu in Outlook

  4. Choose Open & Export from the column on the left side of the window and then Import/Export in the main panel.

    5. an arrow pointing to the Import/Export option in Outlook

  5. From the Choose an action to perform menu select Import from another program or file and then click the Next button.

    6. an arrow pointing to a Next button on the Import wizard in Outlook

  6. This time select Comma Separated Values and then click the Next button.

    7. Comma Separated Values selected in the Outlook Import wizard

  7. Click the Browse… button next to the File to import: field.

    8. an arrow pointing to a Browse... button

  8. Navigate to the .csv file that you saved way back in step #2, select it and then click the Open button.

    9. selecting a .csv file

  9. Click the Next button.

    10. an arrow pointing to the Next button to import gmail contacts to outlook

  10. Choose Contacts (This computer) from the list of destinations, and then click the Next button.

    11. selecting Contacts as the option for the gmail import process

  11. 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.

    12. the Translation Error in Microsoft Outlook

  12. 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.

    13. a confirmation dialogue box for Excel with an arrow pointing to a Yes button

  13. Back in Outlook, click the Browse… button again and this time select the newly saved version of the .csv file.

  14. Once again choose Contacts (This computer only) and then Next

    15. selecting Contacts as the option for the gmail import process

  15. This time you should continue without any errors. Make sure there’s a check in the Import box and then click the Finish button.

    16. the final window of the import contacts from gmail wizard

  16. 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.

    17. the Outlook Address Book with Gmail contacts imported into it

  17. That’s it! You’re all done.

If this article helped you, I'd be grateful if you could share it on your preferred social network - it helps me a lot. If you're feeling particularly generous, you could buy me a coffee and I'd be super grateful :)

buy a coffee for simplehelp.net

Home » Email » How to Import Your Gmail Contacts Into Outlook

4 thoughts on “How to Import Your Gmail Contacts Into Outlook”

Leave a Comment

Your email address will not be published.