Import Google Gmail contacts into Outlook

If you want to see and use your Google Gmail contacts in Outlook desktop, you don’t have to enter them one at a time. Instead, export your Gmail contacts to a file, and then import them into Outlook. It’s not a one-click button but there’s a wizard that’ll walk you through the steps.

Notes: Don't have Outlook on your desktop? Using Outlook on the web instead? See My ribbon says "Office 365" or looks different from the picture, in the Import contacts to Outlook for Windows article.

If you’re importing Gmail contacts into an Outlook.com account (or another Exchange ActiveSync account) in Outlook 2013 or Outlook 2016, see Import contacts into an Outlook.com account.

Here's a video that shows you what to do. The instructions are below the video.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Export your Google Gmail contacts to a file

Note: Google does not export the photos of your contacts.

  1. Log on to your Google Gmail account.

  2. Choose Gmail >Contacts.

    To import Gmail Contacts to Office 365, in Gmail, select Gmail then Contacts

  3. At the top of the contacts section, select More >Export.

    To import contacts from Gmail to Office 365, in Gmail choose Contacts, More, Export

  4. Under Which contacts do you want to export, choose a contact group or All Contacts.

    Choose Outlook csv format to export contacts that you'll import into Outlook

  5. Under Which export format, select Outlook CSV (for importing into Outlook or another application), and then choose Export.

  6. When prompted to download the export file, choose Save As.

    google gmail export contacts save as

  7. Choose Browse and choose a location on your computer to temporarily save the file. The default file name is contacts.csv.

    Save the contacts.csv file to a location on your computer.

    If you want, you can open the contacts.csv file with Excel to check that all of your contacts were successfully exported. Unless you've been extraordinarily thorough at entering info for your contacts in Gmail, the exported CSV file will likely look something like the following, with info in some cells but not others:

    A sample csv file exported from Google.

    Note:  You can delete this file after your contacts are imported into Outlook.

Import your Google Gmail contacts into Outlook

  1. In Outlook on your desktop (Outlook 2013 or Outlook 2016), choose File > Open & Export > Import/Export.

    To create your Outlook pst file, choose File, choose Open and Export, and then Import/Export

  2. Choose Import from another program or file, and then choose Next.

    import and export wizard - import from another program or file

  3. Choose Comma Separated Values, and then choose Next.

    Outlook Export Wizard - Choose CSV file

  4. In the Import a File box, browse to find the file you saved in step 7 of the previous procedure, and then double-click to select it.

    Browse to the contacts csv file and choose how to handle duplicate contacts

  5. Choose one of the following to specify how you want Outlook to handle duplicate contacts:

    • Replace duplicates with items imported   If a contact is in Outlook and Gmail, Outlook discards the info it has for that contact and uses the info from Gmail. You should choose this option if the contact info in Gmail is more complete or more current than the contact info in Outlook.

    • Allow duplicates to be created   If a contact is in Outlook and Gmail, Outlook creates duplicate contacts, one with the original Outlook info and one with the info imported from Gmail. You can combine info for those people later to eliminate duplicate contacts. This is the default option and the safest one because no info is discarded.

    • Do not import duplicate items    If a contact is in Outlook and Gmail, Outlook keeps the info it has for that contact and discards the info from Gmail. You should choose this option if the contact info in Outlook is more complete or more current than the contact info in Gmail.

  6. Click Next.

  7. In the Select a destination folder box, scroll to the top if needed and select the Contacts folder > Next.

    When you import Google Gmail contacts into your Office 365 mailbox, select Contacts as the destination

  8. Choose Finish.

    When you import Gmail contacts to your Office 365 mailbox, click the Finish button to start the migration

    Outlook imports your contacts to Outlook.

Viewing your contacts in Outlook

  1. In Outlook on your desktop, select Address Book, choose the name of your mailbox, and choose Contacts.

    After you import your Gmail contacts, you can find them in Office 365 by selecting the Address Book

  2. You'll see your list of contacts in the Address Book.

    When your contacts are imported from Google Gmail to Office 365, you'll see them listed in Address Book: Contacts

Fixing problems with importing Gmail contacts

  • You get an error message: If you try to import more than 2000 contacts at a time, you'll see an error message. Use a program such as Excel to open the CSV file, separate your list of contacts into smaller .csv files, and then import each newly created CSV file.

  • No contacts appear in Outlook: If you complete the import process but no contacts appear in Outlook, do the following:

    1. Locate the csv file you exported from Google. The default file name is contacts.csv.

    2. Use Excel to open the CSV file you exported from Google.

    3. Check whether there is any information in the CSV file. If there isn't any information in the CSV file, the export from Google didn't work. In that case:

      1. Delete the contacts.csv file.

      2. Export your contacts from Google again. Be sure to choose to export All contacts, or the right group of contacts.

        Choose Outlook csv format to export contacts that you'll import into Outlook

      3. After you export your contacts, use Excel to open the CSV file and check that there's data. When you close the file, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. If you choose No, the file will get messed up and you'll need to start over with a new contacts.csv file.

      4. Repeat the steps to import your contacts.csv file to Outlook.

  • Contacts are missing info: After you import your contacts, if you open Outlook and see that not all the info was imported, open the CSV file with Excel to see if the information was there.

    • You can edit the CSV file using Excel to add names and other missing information.

    • Outlook requires the column headings in the first row so don’t replace them with something else.

    • When you save the CSV file, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. If you choose No, the file will get messed up and you'll need to start over again by exporting the list from Gmail.

    • Repeat the steps to import your contacts.csv file to Outlook. In step 5, when prompted out to handle duplicates, be sure to choose Replace duplicates with items imported.

Next steps

Here are some other things you can to do set up Outlook:

To learn more about using Office 365, see the Office 365 Learning Center.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×