Thursday, October 17, 2013

Importing a Mac Address book into Excel/Outlook

If you have a Mac address book that you want to import into Outlook on the PC (or just into Excel), you need an additional tool to do it.  As of OS X 10.8 Mountain Lion, the only options for exporting the Mac address book are vcard or Mac Address book archive, neither of which is compatible with Outlook or Excel.

There are some paid options in the Apple Store that export the address book to a TXT or CSV file, but I found a nice, easy, free option.

Export the address book VCARDs (make sure you select all and get all of your contacts in a single CSV file).  Then go here:
http://labs.brotherli.ch/vcfconvert/index.php

This site takes your VCF file and will convert it to 'gmail CSV' which you can use for direct import into Outlook or import into Excel for massaging before importing into Outlook.

1 comment:

Unknown said...
This comment has been removed by a blog administrator.