Custom fields that couldn't be matched to any of the standard fields were added to Notes section. This way all contacts were imported without any errors or lost data.

CSV files to Office 365 account via Outlook ( File > Open & Export > Import/Export > Import from another program or file > Comma Separated Values.)

Export all contacts (or individual groups if you want to preserve those) from Gmail to Outlook CSV format (make sure you choose Outlook CSV, not Google CSV format).

VCF file to Gmail Contacts (via web browser). I exported each group individually, but this is probably not required - it seems that group membership is preserved when you import. VFC format on a Mac via built-in Contacts (select all contacts > File > Export > Export vCard) Importing via dragging contact groups looked like it was working, but soon I discovered that it was skipping all data in custom contact fields that were not supported by Office 365 / Exchange.Īfter bunch of trial and error I eventually found a reliable way to import all contacts without loosing any data in custom fields: Unfortunately, neither of the buttons was responding and the only option left was to kill the Contacts app. Also, it would often show a message about a duplicate contact and prompt to skip, ignore, or cancel import. Contacts app was freezing, showing nonsensical error messages, crashing, etc. The VCF contacts are seen as shown in the. Importing large number of individual contacts this way simply didn't work reliably enough. Select Import option and choose vCard file and click on Import. I initially tried to import on a Mac via built-in contacts app by simply dragging and dropping individual contacts or contact groups. If you’re importing a text file, review the field labels.

Importing contacts proved to be a bit more complicated. Whether you need to run Windows programs that dont have Mac versions, or you are making the switch from PC to Mac and need to transfer your data, Parallels. In the Contacts app on your Mac, choose File > Import, select the file, change the encoding if necessary, then click Open.

Import csv contacts to outlook 365 mac