How to Export a Mac Address Book to Excel

by David Weedmark

Address Book is used for managing contact information on Mac OS X computers. The Address Book export feature can only be used for exporting VCards or Address Book archive files for backup purposes. It cannot export into a format used by other Microsoft Excel. You can install a small conversion program that will let you export your Address Book contacts into a CSV file. This is a simple format that arranges data as comma separated values, which can be opened with Excel.

1

Download a program to convert Address Book contacts to CSV format. Free or trial versions are available online, including AB2CSV, Address Book Exporter and Export Address Book. Install and launch the program.

2

Launch Address Book on your Mac. Select "All Contacts." Click on one contact in the "Name" column. Then press "Command" and "A" on your keyboard to highlight all the contacts.

3

Drag the contacts into the conversion program with your mouse.

4

Decide which fields you want to include in your CSV file, including "First Name," "Last name." Select those fields. Each field will be arranged in a column when you open the CSV in Excel.

5

Launch Microsoft Excel on your Mac. Click on the "File" menu. Then select "Open." Navigate to your new CSV file and click on it. Then click "OK."

Tip

  • check The CSV file you created can also be opened with Microsoft Excel on any Microsoft Windows computer.

About the Author

A published author and professional speaker, David Weedmark has advised businesses and governments on technology, media and marketing for more than 20 years. He has taught computer science at Algonquin College, has started three successful businesses, and has written hundreds of articles for newspapers and magazines throughout Canada and the United States.