The Mac Observer

Skip navigational links

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

Show: Subjects Only | Full Comments
Close Name:Guest
Subject: False and derogatory post

"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.

Close Name:Lavode Posts: 147 Joined: 03 Dec 2001
Subject:

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.

Close Name:Jeff Gamet -   TMO Staff Posts: 102 Joined: 15 Mar 2006
Subject: Re: False and derogatory post

Quote
Anonymous 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

Close Name:deasys Posts: 296 Joined: 08 Apr 2003
Subject:

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.

Close Name:gslusher Posts: 2088 Joined: 13 Nov 2002
Subject:

Quote
Lavode 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.

Comment on this Article


You cannot edit your comments.   You cannot delete your comments.
Log in | Register | Having Problems? Reset TMO Cookies & Try Again
Username:   Password:   Log me on automatically each visit   

You are not logged in, and this post will appear as "Guest." Log in with your username and password from the TMO forums. If you do not have a username, you can register here.
Please note that guests are limited to including a maximum of two URLs per post.


Post A Comment
  Subject


  Your Comments



Please enter the word exactly as you see it in the image above. Registered users aren't prompted for this. Having trouble reading the image get a new one.


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

Apple Stock Quote

  • AAPL: $88.93. Change Today: -3.74.
  • (Prices delayed up to 20 minutes.)
  • Discuss in our Apple Finance Board

Hot Topics

Top Deals From DealsOnTheWeb