How to Convert a Mac Address Book to CSV
Address Book is the default program on Mac computers to manage contact information, including names, phone numbers, company information and email addresses. Apple Mail uses the information in Address Book to track names and email addresses. While you can export individual contacts as Vcards, Address Book does not give you an option to export contacts in any other format. To export your contact information in a CSV, or Comma Separated Values, to use as a spreadsheet or import into another type of contact software, you need to install a third-party conversion utility program.
Select a utility to convert Address Book contacts to CSV format. Free utilities include AB2CSV, Export Address Book and Address Book Exporter. Download and install the utility as directed (see Resources).
Open "Address Book" in the Applications folder in the Finder.
Drag your contacts into the conversion utility program. To select multiple contacts, hold down the "Command" key while clicking on the contacts. To select all contacts, press "Ctrl" and "A" on your keyboard.
Select which fields in your Contacts will appear in the CSV columns. Options include "First," "Middle" and "Last" names, as well as "Company," "Phone," "Email" and others.
Export your contact information into a CSV file. You can then open this file using a spreadsheet program like Microsoft Excel, or import it into another contact management program.
Tips & Warnings
- Open the CSV file with any CSV-compatible spreadsheet program to modify it as needed. Remember to save the spreadsheet in CSV format if you plan to use it for importing into a contact management software.