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
Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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?