Convert Your Contacts To A Excel File

Have you ever wanted to build a Word or Excel file of some or all of the people in your Mac address book? A free tool named VCF-Convert let’s you do this easily. VCF-Convert is also useful if you want to import your contacts into Google Contacts.

Here are instructions for creating an Excel file of all of the people in your Contacts applications. (Note: On older versions of OS X, the Contacts application was named Address Book. These instructions work the same if your Mac has the Address Book application.)
  1. Open the Contacts application on your Mac
  2. Click on one contact to select it, then go to the Edit menu and choose Select All. (If you only want some contacts in your Excel file then only select a subset of your contacts.)
  3. Click on the File menu and choose Export and then Export vCard.
  4. Save the vCard file on the Desktop or some other convenient location.
  5. Go to the following web site to convert your vCard file to a CSV file: http://labs.brotherli.ch/vcfconvert/
  6. CSV stands for Comma Separated Values
  7. Use the image below as a guide as you follow the next steps
  8. Click the Choose File button to select your vCard file.
  9. Set Format to CSV and choose Tab (CSV stands for comma separated values, for what it’s worth even though we are using Tab characters, not commas to separate data in our CSV file.)
  10. Click the Convert button. The web site will create a CSV file which’ll automatically be downloaded to your Mac.
  11. Open Excel, click on the File menu, select Import and choose the CSV file that was just downloaded to your Mac. You’ll be shown a preview of the data. Look it over. If it looks good, then click the Finish button.
Voilà you have an Excel file full of all contact data.
vCard to CSV conversion

Leave a Reply