Tip: Export Address Book Data With Apple iWork Numbers ’08

by Michael on August 25, 2007

Here is a great tip I found on the Apple discussion boards courtesy of Neil Barman.

You can use Numbers to export your address book entries to a comma separated values (csv) file.

Here’s how you do it:

Open Address book, then select the entries you wish to export. Drag them into numbers, on a blank area of the canvas, and a table will automatically be created. By default, the following fields are displayed: Last Name, First Name, Phone and Email. The other address book fields are present, but hidden. To have all fields display, choose the Unhide All Columns from the Table menu.

You can then select Export from the File menu, and choose a csv format that will be suitable for import into another application.

{ 4 comments… read them below or add one }

R Carbaugh April 23, 2009 at 6:18 pm

Oh, that is HUGE!! I have been waiting forever to find out how to export the Address Book entries and filter them. I just need a paper phonebook sometimes, but I have 800 entries in my Address Book, and I cannot filter them. Many don’t have phone numbers, so printing a list from Address Book is useless.

Thanks a lot for the tip!!
R Carbaugh

Ken Kemp November 10, 2009 at 6:32 pm

Agreed! THANK YOU!

Adam Bowles May 26, 2010 at 10:44 am

It’s almost perfect. But how do I export custom label cell phones? I’m doing a church list and under certain entries I put the wife’s cell and the husband’s cell.

Gardea December 17, 2010 at 2:23 am

Life saver tip… trying to get addresses onto web service for holiday cards and was struggling… I can now sleep peacefully :-)

Leave a Comment

Previous post:

Next post: