Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can use the same contacts in both Google Gmail and Outlook, without adding them manually to both locations.

Import your contacts from Google Gmail to Outlook

  1. Log on to Google Contacts.

  2. In the left column, click More.

  3. At the top left, click More.

  4. Click Export.

  5. Under Which contacts do you want to export, click a contact group or All Contacts).

  6. Under Which export format, click Outlook CSV (for importing into Outlook or another application).

  7. Click Export.

  8. When prompted to download the export file, click Save.

  9. Choose a location on your computer to temporarily save the file. The default file name is contacts.csv.

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

  10. Click Close.

  11. Go to Outlook.

  12. Click the File tab.

  13. Click Open.

  14. Click Import.

  15. Click Import from another program or file, and then click Next.

  16. Click Comma Separated Values (DOS), and then click Next.

  17. In the Import a File box, browse to find the file you downloaded in step 9, and then double-click the file.

  18. Click one of the following:

    • Replace duplicates with items imported

    • Allow duplicates to be created

    • Do not import duplicate items

  19. Click Next.

  20. In the folder list, click the contacts folder where you want the imported contact information to go, and then click Next.

  21. To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.

    Note: The Map Custom Fields button in the Import a File dialog box might not be available when you try to import data from another program or file. In the The following actions will be performed box, select the Import check box, and then the Map Custom Fields button is available.

    Additional help on mapping custom fields

    1. In the From box, drag the field that you want to convert onto the Outlook field that is listed in the To box.

      Note: The Name field doesn't appear in the To box because Outlook reserves the first row of a named range for field names. If the range that you import does not contain field names, the first row of data will be interpreted as field names and will not be imported as data. To make sure that all of the data in the named range is imported, use the first row for field names.

      • To see additional records in the From box, click Previous or Next.

      • To remove all mapping, click Clear Map.

      • To reset the original mapping, click Default Map.

    2. To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the plus sign (+) next to Business Address.

  22. Click Finish.

Export your contacts from Outlook to Google Gmail

Before you export contacts from Outlook, it is helpful to understand the difference between the Outlook Address Book and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists that you might store in Outlook, such as LDAP Internet directories, the global address list (GAL), or other third-party address books. Contacts is only one of the address lists included in an Address Book. Only contacts can be exported directly from Outlook to Google Gmail.

  1. Click the File tab.

  2. Click Options.

  3. Click Advanced.

    Outlook options with Advanced selected

  4. Under Export, click Export.

    Export command in the Backstage view

  5. In the Import and Export Wizard, click Export to a file, and then click Next.

  6. Click Comma Separated Value (DOS), and then click Next.

  7. In the folder list, click the contacts folder you want to export, and then click Next.

  8. Choose a location on your computer to temporarily save the file.

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

  9. Type a name for the exported file, and then click Next.

  10. To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.

    Note: The Map Custom Fields button in the Export to a File dialog box might not be available when you try to import data from another program or file. In the The following actions will be performed box, select the Export check box, and then the Map Custom Fields button is available.

    Additional help on mapping custom fields

    1. In the From box, drag the field that you want to convert onto the Outlook field that is listed in the To box.

      • To see additional records in the From box, click Previous or Next.

      • To remove all mapping, click Clear Map.

      • To reset the original mapping, click Default Map.

    2. To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the plus sign (+) next to Business Address.

  11. Click Finish.

  12. Log on to Google Contacts.

  13. At the top left, click More.

  14. Click Import.

  15. Under Import Contacts, click Browse.

  16. Select the file you exported in step 9, and then click Open.

  17. Click Import.

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×