+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Any method for creating a CSV file out of an Address Book contact? (/showthread.php?tid=55796)
Any method for creating a CSV file out of an Address Book contact? - tuqqer - 05-30-2008
Aside from a custom AppleScript, anyone know of a way to get selected Contacts in the Address Book into a CSV format (Comma Separated)?
Re: Any method for creating a CSV file out of an Address Book contact? - deckeda - 05-30-2008
Yeah but it might not be pretty. One way is, you can export the contacts as vCards and force Excel to open them up (Get External Data/from Text file ... change choices to "all files" so that it recognizes the vCard) and go through the "wizard"
After that you can Save as Comma separated file. But like I said, it might all be lucky.
Excel will NOT open an exported Address Book database file.
Re: Any method for creating a CSV file out of an Address Book contact? - deckeda - 05-30-2008
Sorry, this is probably more help: http://www.google.com/search?client=safari&rls=en&q=convert+vCard+to+comma+separated&ie=UTF-8&oe=UTF-8
Re: Any method for creating a CSV file out of an Address Book contact? - tuqqer - 05-30-2008
Thanks deckada, I'm checking it out now...
Re: Any method for creating a CSV file out of an Address Book contact? - raz - 05-30-2008
IIRC correctly, when I loaded Thunderbird on my work machine, they had some link to a web app that did the conversion for you.
found it. will convert t ldif or csv
http://labs.brotherli.ch/vcfconvert/
Re: Any method for creating a CSV file out of an Address Book contact? - Article Accelerator - 05-31-2008
Take your pick:
http://www.versiontracker.com/dyn/moreinfo/macosx/30136
http://www.versiontracker.com/dyn/moreinfo/macosx/29681
http://www.versiontracker.com/dyn/moreinfo/macosx/23718