Export Mac Mail Address Book Contacts to CSV File

Picture of a CSV file icon
Wikimedia Commons/Own work

Exporting an Apple contact list to the CSV format lets you easily import the contacts into other email clients or view them in a spreadsheet program like Microsoft Excel.

However, by default, the Contacts or Address Book program on a Mac will export entries to the vCard file format with the VCF file extension. CSV is much more common and works with lots of different email clients.

There are two ways to get your contacts into the CSV file format. You can either use a dedicated tool that does it from the start or you can get the contacts into the VCF format first and then convert the VCF file to CSV.

Export the Contacts Directly to CSV

Screenshots of the AB2CSV program on a Mac
AB2CSV.

This method involves using a program called AB2CSV, which lets you save the contacts to the CSV file without having to create the VCF file first. Take note, however, that it is not free. Skip down to the next section below if you'd rather have a free option.

  1. Download and open AB2CSV.

  2. Select Mode > CSV from the menu.

  3. To configure which fields will be exported, go to AB2CSV > Preferences and then click the CSV tab.

  4. Choose the File > Export menu item.

  5. Pick a folder for where the CSV file should be saved.

Convert the VCF File to CSV

Screenshot showing how to export Mac contacts to a VCF file
Making the VCF File.

If you'd rather not install any programs or pay money to make this CSV file, you can instead convert the VCF file to CSV using an online utility. To do that, you have to first create the vCard file.

  1. Open the Applications menu in Finder.

  2. Choose Contacts.

  3. Pick the list you want to export, such as All Contacts.

  4. From the Contacts menu, use the File > Export > Expert vCard menu item.

  5. Name and save the exported list of contacts.

Now that the contacts are in the VCF format, you can use a VCF to CSV converter like vCard to LDIF/CSV Converter to make the CSV file.

Screenshot showing how to convert VCF to CSV on a Mac
Converting VCF to CSV.

Upload the VCF file to that website and pick CSV as the output format. You can change any other settings you want, too. Just hit the convert button when you're done to make the CSV file.