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 >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Aug 4, 2022 8:15 AM

Reply
Question marked as Best reply

Posted on Aug 4, 2022 8:38 AM

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.

2 replies

How to export Address book to Excel?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.