Featured Article: Podcast - Apple Weekly Report #135: Apple Lawsuits, Banned iPhone Ad, Green MacBook Ad
TMO Quick Tip - Address Book: Export to CSV
by , 7:30 AM EDT, June 23rd, 2008
Apple's Address Book application is great at storing information about the people in you life, but it's not so great at sharing that information with most other apps because it doesn't let you export information to CSV, or comma separated value, files. Antonio Lore's Address Book to CSV Exporter handles that job with ease, and even lets you select which groups to export.
Address Book to CSV Exporter sports an easy to use interface with a Standard option that exports your contacts with a single mouse click. The Advanced option lets you export a specific Address Book group.
![]() Address Book to CSV Exporter does just what the name says. |
|---|
The exported CSV file can be imported into Web-based email and contact managers, like Google's Gmail, imported into spreadsheet applications like Numbers or Microsoft Excel, or imported into any other application that recognizes the standard CSV format.
While I haven't had a need to export my Address Book contacts to a CSV file, TMO forum member ERNesbitt does, and this little app should handle the trick nicely.
Address Book to CSV Exporter is free and available for download at Antonio Lore's Web site.
Jeff Gamet is TMO's Morning Editor and Reviews Editor. He lectures, teaches and speaks on Mac OS X and design-related topics, and is the author of The Designer's Guide to Mac OS X from Peachpit Press.
if you have tips or tricks to share, or Mac-related questions you want answered.
Observer Comments
"Apple's Address Book application is ... not [good] at sharing ... information with most other app[lications] ..."
That seems an unnecessarily derogatory comment. It is also incorrect. Address Book currently sychronizes with .Mac, Exchange, Google, and Yahoo. (Take a look at the Preferences window.)
It also exports to vCards which are *the* standard from the Internet Mail Consortium for personal data exchange. This is *the* standard for this purpose:
http://www.imc.org/pdi/
If someone has an application that doesn't support the interchange standards, then that's the problem of that application, not Address Book which *does*.
Frankly, the real answer would be to use better software on the other operating system you're moving the data to.
I think you're missing the part where Address Book DOESN'T export to CSV. Anyone who has tried to export their entire book and import it into another application knows how strange it is that Apple didn't include this basic function. It's a major pain to create vCards for every entry in a book and then import them one at a time. This is a great step forward, and it only highlights that which is strangely lacking. Thus, it is not false, and it is appropriately derogatory, though I think "derogatory" is an overreaction.
Mon Jun 23, 2008 9:36 am Subject: Re: False and derogatory post
QuoteAnonymous wrote:
"Apple's Address Book application is ... not [good] at sharing ... information with most other app[lications] ..."
That seems an unnecessarily derogatory comment. It is also incorrect. Address Book currently sychronizes with .Mac, Exchange, Google, and Yahoo. (Take a look at the Preferences window.)
It also exports to vCards which are *the* standard from the Internet Mail Consortium for personal data exchange. This is *the* standard for this purpose:
http://www.imc.org/pdi/
If someone has an application that doesn't support the interchange standards, then that's the problem of that application, not Address Book which *does*.
Frankly, the real answer would be to use better software on the other operating system you're moving the data to.
Address Book does export to a handful of applications, and yes, it does support the vCard standard. That doesn't, however, mean its export options play well with a wide range of applications. For that you still need CSV export, and that's where Address Book clearly falls short -- especially since not everyone is in a position to dictate which applications they use for specific tasks.
For example, moving Address Book data into a spreadsheet or custom database is much easer if you can first create a CSV file.
That shortcoming isn't enough to make me want to switch to a different contact manager since Address Book is meeting most of my needs, but it is still a shortcoming, and I think it's great that developers like Antonio Lore have stepped up to the plate and addressed that issue.
Jeff
Although the freeware utility mentioned is a fine solution for CSV export, I agree with the first post--this would not be necessary if other applications supported modern standards, in this case, the vCard format.
BTW, in addition to the things the first post mentioned, you should be aware that Address Book's data is maintained in a database accessible system-wide by any application that wishes to do so. Sharing is thus "live" in real time.
It's time for other applications to catch up.
QuoteLavode wrote:
I think you're missing the part where Address Book DOESN'T export to CSV. Anyone who has tried to export their entire book and import it into another application knows how strange it is that Apple didn't include this basic function. It's a major pain to create vCards for every entry in a book and then import them one at a time. This is a great step forward, and it only highlights that which is strangely lacking. Thus, it is not false, and it is appropriately derogatory, though I think "derogatory" is an overreaction.
You can export an entire group of contacts--or all of them--to one vCard. Just highlight them and choose export. Try it.
Recent Headlines - Updated Saturday, November 29th, 2008
- Sat., 9:00 PM
- Podcast - Apple Weekly Report #135: Apple Lawsuits, Banned iPhone Ad, Green MacBook Ad
- Fri., 12:45 PM
- Podcast - Mac Geek Gab #178: Batch Permission Changes, Encrypting Follow-up, Re-Enabling AirPort, and GigE speeds
- Thu., 1:30 PM
- iPO Review - Scosche kickBACK iPhone case
- 7:00 AM
- Happy Thanksgiving from TMO!
- Wed., 6:00 PM
- TMO Appearances - Nancy Gravley Joins MacJury Gift Guide
- 5:15 PM
- TMO Visits The Bay, a Premium Apple Reseller in New Zealand
- 3:25 PM
- iPO Oh the Games You'll Play - iPhone: The Wii of Handheld Gaming Devices?
- 2:15 PM
- Sonnet Releases Simply Fast FireWire 800 to 400 Adapter
- 1:10 PM
- Mac Gaming News - Disney Plans 1st Annual PotC Online Thanksgiving Event
- 12:05 PM
- iPodObserver - UK Shuts Down iPhone 3G Ad
- 11:15 AM
- TMO Appearances - Jeff Gamet on MacJury Gift Guide
- 10:30 AM
- TMO Contest - TMO Announces Macworld Expo Pass Winners
- 9:50 AM
- PhotoCopy 1.1 Adds iPhoto Event Support
- 9:15 AM
- Acclivity Buys MYOB US
- 8:30 AM
- Review - Bento 2 Holiday Pack
- 7:50 AM
- Microsoft Offers Black Friday Office Discount
- 7:30 AM
- iPO Quick Tip - iPhone: Google Street View
The Mac Observer Reader Specials
- Download Typestyler, still the Ultimate Styling Tool for Internet, Print and Video Graphics. Works great in Classic with a Native OS X Version on the way. Free Tryout: www.typestyler.com
New iMac 800Mhz Memory 4GB $54. New MacBook & MacBook Pro DDR3 PC8500 4GB Kit $116. MacBook/MacBook Pro / MacMini / iMac Intel Core2 DUO DDR2 667Mhz 4GB Kit $58, 3GB Kit $44, 2GB Kit $30. Click to Maximize your Macs...
Mac observers can now play Party Poker for Mac as well as Mac casino games by going to MacPokerOnline.com.
RamJet Memory: Mac Pro FB-DIMMs: 2Gig kit $95, 4Gig Kit $179, 8Gig Kit $355! MacBook 2Gig Kit $78, 4Gig Kit $149! Click hereFor the latest Apple products use Ciao a comparison website to find laptops like MacBook Air. Then find the best prices on MP3 players and use our comparison tool to evaluate cell phones.
Laptop Hardware Provided by TechRestore - Overnight Mac & iPod Repairs.


