Export to CSV file from address book

Question

Level 1

11 points

Export to CSV file from address book

I've seen a few programs that make this possible, but none of them seem to be able to export the groups I've created under my exchange server folder. I don't use the local folder, only the exchange folder.

Am I missing something? Can anyone give a tip to help me out?

Mac Book Unibody- 2.4 Ghz, 4 GB RAM, Mac OS X (10.5.6)

Posted on Dec 4, 2009 8:58 AM

Reply

Answer 1

V.K.

Level 9

56,174 points

Dec 4, 2009 9:03 AM in response to PDXREALTOR

I don't have any exchange accounts so I can't speak of the differences but you should always be able to just select all contacts in a group in address book and drag them to the desktop. that should create a vcard for all those contacts on the desktop which can then be converted to csv. you can use this converter for example
http://labs.brotherli.ch/vcfconvert/

Reply

Answer 2

Dec 4, 2009 5:24 PM in response to PDXREALTOR

CSV stands for Comma Separated Values, sometimes also called Comma Delimited. A CSV file is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma.

For Microsoft Entourage, you export your Entourage contacts as a tab delimited file. Excel can import a tab delimited file. In Excel, you Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)". more info

I checked in Apple Address Book and it doesn't appear that you can export as a text file. You can try this script that is supposed to work with the Address Book to create a .csv file.

Export Contacts to Yahoo CSV 1.2

Reply