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 }
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
Agreed! THANK YOU!
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.
Life saver tip… trying to get addresses onto web service for holiday cards and was struggling… I can now sleep peacefully