How to Convert VCF to CSV using Google Contacts

Converting a VCF to a CSV can be done in a couple of different ways. For instance we can use Mircrosoft Excel and the help of a VBA script to do the conversion. It’s not the most straightforward way but it works.

The simplest way however is just using online converters. Many sites of this nature exits, however I wasn’t aware Google Contacts supported this conversion only after I used it to import my Outlook.com contacts into it.

Google Contacts supports both importing and exportings your accounts contacts to VCFs or CSVs. The contacts can be exported to either Google CSV format meant for importing into Google Accounts or Outlook CSV format meant for importing into Microsoft Outlook and other applications.

Now for this to work we only need two things:

  • Your VCF file
  • A Google Account

Step 1: Select Google Account to Use

Like most other Google services, Contacts is linked
to ones 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 this, 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.

Step 2: Import the VCF

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.

Step 3: Export the Contacts to a CSV

1. 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)

2. 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

3. 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 a Reply

Feel free to share your comments or questions with me. I may not be able to respond immediately so please check later once I've approved your comment.

Your email address will not be published. Required fields are marked *