Apple Contacts (Mac OS 10.9) - Exporting Address Book(s) / Contacts

Best Effort Support Only

This document contains instructions on using a non-Microsoft email client, such as Apple Mail or Thunderbird. Microsoft does not recommend these clients for use with Office 365, and there are often significant limitations in client functionality as a result.

Because of this, the DoIT Help Desk is only able to offer best effort support for these clients, and certain issues may require the use of a Microsoft client in order to be resolved. For more information on Office 365 client support, please see: Office 365 - Which clients/protocols will be supported?.

This document will provide step-by-step guidance on how to export contact lists from Apple Contacts. Note: versions prior to 10.8 used address books instead of contacts.

Important: If you are interested in exporting the auto-fill/auto-complete history from your Apple Mail program, please make sure to complete that step prior to exporting your contacts. The reason for this is Apple Mail cannot export auto-fill/auto-complete information, the export is completed by creating a new contact entry for previously email recipients/senders.

Important: For those who use contact groups, please be aware that the individual contacts of your address book will be included in the export but your contact groups will not. If you use contact groups, please make a note of them prior to migrating so that you can more easily re-create them in Office 365.

Manually Exporting your Apple Contacts

  1. Open the Applications menu.

    Mac Applications Menu

  2. Select Contacts.

    Contacts Icon

  3. Select the contact list you would like to export (e.g., All Contacts).

    Contact List

  4. From the Contacts menu, select File, Export, then Export vCard... .

    Export File

  5. Give your file a descriptive name, then select the location where you would like to save it.

    Save Contacts

  6. To convert the contacts' vCard to a Comma Separated Values (.csv) file, you will need to use a third-party converter.

  7. Using the converter, select the vCard file you saved in the previous step.

    Convert vCard to .CSV File

  8. For each of the two "Format:" drop down menus, select CSV and Comma, then check the Add header line box. 

    Contacts Format Type

  9. Next to the "Filter:" field, uncheck the box labelled vCards with e-mail only. To finish the process, select convert to save the .csv file.

    • Note: Your .csv file will be saved in the Downloads folder.

    Contacts Filter Type

You are now ready to import your exported Apple Contacts into your Office 365 account after you have transitioned to Office 365.




Keywords:microsoft office365 o365 apple contacts export exporting vcard csv mac macintosh comma separated values .csv converter convert LDIF file format download manual steps manually migration transition prepare preparatory 10.9 10.8 o365   Doc ID:38443
Owner:Leah S.Group:DoIT Help Desk
Created:2014-03-14 17:28 CDTUpdated:2015-09-11 12:40 CDT
Sites:DoIT Help Desk, DoIT Tech Store, Office 365, WiscCal, WiscMail
Feedback:  64   37