IT Knowledgebase
< All Topics
Print

Export Google Gmail contacts to a .csv file

PostedNovember 24, 2023
Bytechie

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

  1. Log on to your Google Gmail account.
  2. Choose Gmail >Contacts.
  3. To import Gmail Contacts to Office 365, in Gmail, select Gmail then Contacts
  4. At the top of the contacts section, select More >Export. To import contacts from Gmail to Office 365, in Gmail choose Contacts, More, Export
  5. 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
  6. Under Which export format, select Outlook CSV (for importing into Outlook or another application), and then choose Export.
  7. When prompted to download the export file, choose Save As. google gmail export contacts save as
  8. Choose Browse and choose a location on your computer to temporarily save the file. The default file name is contacts.csv.
  9. Save the contacts.csv file to a location on your computer.
  10. 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:
  11. A sample csv file exported from Google.
  12. Note:  You can delete this file after your contacts are imported into Outlook.
  13. Now that your contacts are copied to a .csv file, you can import them to Outlook.

Credit : https://support.office.com/en-US/article/Export-contacts-from-Outlook-10f09abd-643c-4495-bb80-543714eca73f

Updated