Applies ToOutlook 2016 Outlook 2013

Step 1: Export Gmail contacts

  1. From your Gmail account, choose Gmail >Contacts

  2. Select More >Export.

  3. Choose the contact group you want to export.

  4. Choose the export format Outlook CSV (for importing into Outlook or another application).

  5. Choose Export.

  6. When prompted, choose Save As, and browse to a location to save the file.

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

Choose contacts to exports and choose Outlook csv format to export Google  contacts

Step 2: Import Gmail contacts to Outlook 2013 or 2016

  1. Choose File > Open & Export > Import/Export.

  2. Choose Import from another program or file > Next.

  3. Choose Comma Separated Values > Next.

  4. In the Import a File box, browse to choose the .csv file you saved your Gmail contacts to.

  5. Choose how you want Outlook to handle duplicate contacts > Next .

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

  7. Choose Finish.

    Outlook imports your contacts to Outlook.

This is what the Outlook desktop ribbon looks like.

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

Step 3: View your contacts in Outlook

  1. In Outlook, 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 issues 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 contacts to exports and choose Outlook csv format to export Google  contacts

      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.

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

Import and export Outlook email, contacts, and calendar

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.