How to Convert VCF to CSV for Free Online

vcf to csv

A couple of months ago I posted on how to convert a vCard file (VCF) to CSV using Microsoft Excel with the help of a VBA Script. In hindsight I realize that may have been a little bit too complicated for some people not to mention not everybody may have access to Microsoft Excel or Windows for that matter.

Fortunately, yesterday I stumbled on something while importing my Outlook contacts to Google contacts. Yes, that's actually possible. So it just happens it's not only possible to import VCFs or CSVs into Google contacts but you can also choose to export the available contacts to CSV. Even better you get the choice to export them to either Google CSV format meant for importing into Google Accounts or Outlook CSV format meant for importing into Microsoft Outlook and other applications. Here's how to go about it.



What You'll Need

Now for this to work we only need two things:
  • Your VCF file
  • A Google Account

Google Contacts like most Google apps and services is linked to your Google (Gmail) account. So if you already have a Google account you're good to go, however note that the contacts in the VCF will be available to Gmail and other Google apps (including synced to any Android device linked to that account) after importing. To avoid these you can delete the contacts after the conversion is done.

Also there are chances that if you've a Google account then it's probable that it has existing contacts and perhaps you don't want those to get mixed up with those in the VCF. Fortunately there are a couple of ways we can prevent this from happening. More on this later.

Of course if you don't want to go through the trouble of all this you can opt to just create a "disposable" Gmail account to use for this task.


STEPS

1. Head over to the Google Contacts page.

2. Sign in to your Google (Gmail) account or create a new one.

3. On the menu, click on More then Import. That should open a small window with Accounts to import contacts from. Select the last option: CSV or vCard.
import vcf
Import CSV or vCard

4. At the moment you'll have to use the Old Version of the app to import the contacts. So switch to it
then at the top click the More button and choose Import again.
import
Select Import Option

Click on the Browse button then on your computer/device select the VCF you wish to be converted. Next click on the Import button.
browse for vcf
Browse and Import VCF

If the import is successful you should be able to view the contacts contained in the VCF in Google Contact's window. Now we only need to export it to a CSV.

5. So go to menu, click the More option again but this time click Export (New Version). In the Old Version of the app, at the top click the More button and choose Export.
export
Select Export Option (Old Version)

6. An Export contacts window will open at this point. At the top where it asks which contacts you want to export select All Contacts.

TIPS:
  • Choosing All Contacts will export all the contacts that are available, including any that were existing prior to importing the VCF.
  • Google Contacts automatically creates a new label for the imported contacts (Imported *date*). You can export only the imported contacts by choosing The Group then selecting this label.
  • If you just want to export specific contacts to the CSV instead of all, go back and first select only the contacts you want before choosing the export button.
export contacts
Exporting the Imported Contacts Only

7. Below under which format to export select the CSV format you wish to use then click on the Export button. Your CSV download should then begin in a few seconds.

And just like that we're done. If you used a "disposable" account for this, you may want to delete the contacts after this or perhaps the whole Google account. I hope you found this useful.


Leave your comment below. Spammers are advised to file a missing comment report in not less than a weeks time.