By Antonio Lore'
Open the Mac App Store to buy and download apps.
★★★ Please, before posting useless comments check the user's guide or support page on the web site. If those won't help, you're invited to contact the developer for support. ★★★
Also known as Address Book to CSV Exporter, this Mac OS X utility allows the user to export his own Address Book in one or more CSV or VCF files.
Now available on Mac App Store in version 2.0, AB2CSV has been chosen by more than 70,000 users all over the world for five years.
This simple and quick utility exports all your contacts with just one click.
- All details exportation
- Group exportation
- Both CSV and VCF are supported
- Multilanguage (Italian, English, Spanish)
Mentioned by Macworld as "Excellent Add-On" in "Mighty messenger" article.
What's New in Version 2.4.2
- Fixed a bug that crashes the app when "Dates" checkbox in CSV Preferences is on.
- Enabled Sandbox according to Mac App Store rules.
- "Save to folder" preference was removed due to sandbox rules. The user has to select where to save the file every time. The save folder must be one within the User profile.
Better than expected
This app worked perfectly, first time. It was far more customizable than I expected, and gave me a perfect CSV file of my Contacts contact list. I don't know about importing into other programs -- I know some email programs can't handle a CSV file with blank records, but if the record is blank in the contact list it will be blank in the CSV as well. I imported it into Excel, and each category I chose to import from Contacts was a column, each contact was a row. It was so fast that I thought it hadn't worked, but it was perfect.
Note for Excel use. Excel doesn't correctly recognize CSV files on the double-click. You need to open Excel, then choose Import, then CSV. Or choose Open and select the file. In the dialog box that comes up, first choose "Delimited" (rather than fixed length); on the next screen, choose "Comma" as the separator (and deselect all the others). There's an option for "Treat Repeating Delimiters as One." Be sure that is NOT checked, or blank fields will be skipped and the records will end up in the wrong columns.
The user interface is a little too sparse for my tastes but I'm sure others love it. This program did its work perfectly and I was able to use the generated CSV file to import my contacts to my flaky email provider. I wish there was more granular control over which fields are included in the export (especially for the VCF format). I'd also suggest adding separate "CSV" and "VCF" buttons to the main window to make that a bit easier than chooing different modes from the pull down.
I opened the CSV in Excel and everything looked good. A few of my contacts had a single "double quote" character in the notes field and that seems to have resulted in an inaccurate export where all remaining fields for that contact showed up in the notesfield and not being properly split my Excel. I'm going to reach out to the developer and see if they can fix that or if it's just an issue with the csv format and Excel.
I still think this is a great utility.
I mainly wanted to get my contacts into an Excel file as a basic, human-readable back-up since my Apple Address Book program has had issues syncing lately. The app works, despite some of the other comments on this page.
One issue I found is that empty cells are left as blanks in the CSV output as opposed to, say, an "NA" character. A simple find-replace is complicated by the fact that commas are present in my notes as well as being used as a delimiter. Luckily, there is an option in the Preferences to use a semi-colon or pipe (|) instead. Then, one can replace two consecutive pipes with "|NA|" in a text editor before reading it into Excel. An option to replace blanks with NA would be helpful to avoid having to take these extra steps.