Address Book to CSV

There was some discussion on Mac OS X hints in recent months on how to export your Apple Address Book as comma-separated values for importing into things like Thunderbird.

I did some tweaks to Sean’s AddressBookToCSV script, and have since tweaked it a bit more. You can grab my current version here:

Enjoyed this post? Why not sign up to receive Status-Q in your inbox?


Thanks for writing, and posting, this script. A big help!

Hi I know nothing about scripts so I wouldn’t even know how to tinker with this. it seems to work fine except when it comes time to save the new csv doc it won’t do it. it’ll only save as a word or rtf doc. i did save it as such and then change the extension afterwards but that didn’t seem to work. any other suggestions. this is driving me nuts!

Tricia – I’m going to guess this is because your TextEdit preferences are set to create new documents as ‘Rich Text’ rather than ‘Plain Text’?

You’ll either need to change that so that it creates a plain text file, or use Format>Make Plain Text before saving.


Thanks for this neat script – I wouldn’t have been able to write anything like it, being a dedicated mac user but not a developer of any kind. It was very helpful to me, and very findable on Google.
Cheers from New Zealand, Rebecca 🙂

That worked better than anything else i’ve tried, although it still seems to put email addressess under the category “home city”, but at least most of the infromation’s now there.


The link is no longer working. Do you still have this?

Many Thanks!

Sorry for the delay, Adam!

No, I’m rather embarrassed to say that I can’t find it anywhere…. Will go and do some searches through backups…

Got Something To Say:

Your email address will not be published. Required fields are marked *

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see


© Copyright Quentin Stafford-Fraser