Export of contacts from Address Book to Numbers
Dec 28, '11 07:30:00AM
Contributed by: winfred
Turns out there is a super easy way to export contact info from Address Book to a spreadsheet, if you have Numbers (from iWork).
- Use Address Book to select the individual contacts, or select a complete group.
- Drag the contacts/group to an open sheet in Numbers, a new table will be created with all your contacts.
By default only a few details are shown (last+first name, phone, e-mail address). All the other info is available as well, but hidden. Feel free to hide/unhide the columns you are interested in.
Original source: posted by user Celticfaere.
[crarko adds: Works just great. This didn't work with Excel 2011, which is not too surprising, as the underlying data model is different.]
Comments (3)
Mac OS X Hints
http://hints.macworld.com/article.php?story=20111227073514792