Still running macOS 10.15 Catalina or an earlier version? Try Exporter for Contacts 1
Exporter for Contacts 2

Exporter for Contacts 2

The premier Mac app to export your Address Book contacts to CSV, Excel and Outlook.

GET     macOS 11 Big Sur+ ·   4.7

Exporter for Contacts 2 Help

By its very nature, there can be no one-size-fits-all help for the many different use cases. Thus, solution examples for the most common use cases are given here to help you develop your own solution for your export. Based on user feedback, this page will be updated regularly.

How to create an export setup for email marketing

This example shows how to create a setup for a CSV file with five columns (first name, last name, email address, phone number, birthday) and how to give the columns their own title.

Click here for step-by-step instructions

The upgrade from version 1 does not work!

The upgrade requires an iCloud account. Furthermore, both apps must be able to access “iCloud Drive”. So make sure that “iCloud Drive” is enabled in the System Preferences > Apple ID. Also check if access is allowed under “Options” for both apps.

How can I exclude contacts without email addresses from export?

It's simple: Create a Smart Group in Apple Contacts that contains only contacts with the desired criteria. Then drag the members of the Smart Group to the contact list of Exporter for Contacts.

When I open the generated CSV file in Excel, all columns are screwed up!

Of all things, Excel fails to recognize a CSV structure - Apple Numbers is much smarter. The trick in Excel is not to simply open the file, but to import it via the menu command File > Import. Then follow the instructions. Exporter for Contacts also supports the native Excel format. So just use that and you won't have to deal with such problems.

My Excel file has hundreds of columns and is totally cluttered!

This is quite normal if you have many contacts, use many different labels and have set the export of multi-value fields so that they are packed per label in a separate column. Just exclude unimportant fields from the export and let the multi-value fields export in list form. Or create a custom format in the Custom Export Layout Editor.

Can Exporter for Contacts stand-alone vCard files and handle .abbu files?

Exporter for Contacts is designed to work directly with Apple Contacts and uses its database through a special interface provided by Apple. This is the best way to ensure data integrity and privacy when handling your contacts. You need to import tand-alone vCard files into Apple Contacts first, so that Exporter for Contacts can access these contacts.

A Contacts Archive (.abbu) is a proprietary format that Apple Contacts can create to backup all your contacts and Contacts accounts. It is not intended and made to be read by third party apps.

To be continued...