Export Google Apps contacts to Outlook
Solved Email & Outlook
BA
Barry Allen
June 21, 2018
2 replies
7,650 views
Reviewed by moderators

Our small firm is moving from Google Workspace to Office 365. First job is getting everyone's contacts into Outlook.

Around 15 users, a few hundred contacts each. Per user export is fine if the process is quick.

Accepted Answer
Verified by Mariya Beckham, Forum Moderator ยท Reviewed June 2018

Per user this takes about three minutes and Google already speaks Outlook's format.

1
Have the user open contacts.google.com and sign in with the Workspace account.
2
Click Export in the left panel, select Contacts rather than a label unless they only want a subset.
3
Choose Outlook CSV as the format and download. This variant uses the exact column headers Outlook expects, do not pick Google CSV by mistake.
4
In Outlook: File, Open and Export, Import/Export, Import from another program or file, Comma Separated Values, browse to the file, target the Contacts folder and Finish. The field mapping is automatic with the Outlook CSV variant.

If a user has contacts scattered across Frequently contacted and labels, the Export dialog only grabs what is under Contacts proper. Tell them to check the Other contacts section and add anything important to Contacts first, otherwise the export silently skips those entries. Non English names survive fine, the Outlook CSV export comes out in a codepage Outlook reads correctly.

Walked three users through it as a test, three minutes each like you said. The Other contacts catch saved one user about 80 entries. Rolling out to the rest.