How to export Address book to Excel?
Anybody know how to export contacts from my Address book to an Excel file? We'd like to make an old-fashioned printed phone book.
iMac 21.5″, 10.15
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Anybody know how to export contacts from my Address book to an Excel file? We'd like to make an old-fashioned printed phone book.
iMac 21.5″, 10.15
I don't know of a way to export directly to Excel, but the following works. Open a blank Numbers spreadsheet and open the Contacts app on your Mac. Select all contacts and drag them to the Numbers spreadsheet. Then use the Numbers File menu > Export To to export them in Excel format.
I don't know of a way to export directly to Excel, but the following works. Open a blank Numbers spreadsheet and open the Contacts app on your Mac. Select all contacts and drag them to the Numbers spreadsheet. Then use the Numbers File menu > Export To to export them in Excel format.
Many thanks! That worked easily. Now I just have to fiddle with the format to get it to print as a normal phone book, but this is a huge help. I hadn't occurred to me to do that.
How to export Address book to Excel?