VCF to CSV converter

Open a .vcf contacts export and the tool gives you a CSV with one row per contact, ready for Excel or Google Sheets. It also works the other way, turning a CSV back into a .vcf you can import on iPhone, Android or Mac.

Everything runs in your browser. Your text and files stay on your device and are never uploaded.

How to use it

  1. Export your contacts as a .vcf file. On iPhone, open Contacts, tap Lists, touch and hold All Contacts and tap Export. On a Mac, select contacts in Contacts and choose File, Export, Export vCard. On iCloud.com, select contacts and choose Export vCard from the Actions menu.
  2. Pick VCF to CSV, then open the file or paste its text. Press Load example to see how it works first.
  3. Check the preview. Contacts with several phones or emails get extra columns, each with its label such as cell or work.
  4. Download the .csv and open it in Excel, Numbers or Google Sheets. Accented names and emoji stay intact.
  5. To go back, switch to CSV to VCF, open your edited sheet and import the downloaded .vcf into Contacts.

Questions

How do I convert a VCF file to CSV for Excel?

Open the .vcf file in the tool, check the preview, and press Download. The CSV opens in Excel with names, phones, emails, addresses, birthdays and notes in separate columns.

Why are there several Phone and Email columns?

A contact can hold many numbers and addresses. The tool adds Phone 1, Phone 2 and so on, as many as your largest contact needs, and puts the label (cell, home, work) in the matching Type column.

Does it handle a .vcf file with thousands of contacts?

Yes. One .vcf file normally holds every contact, and files up to 30 MB convert in your browser. Folded lines, quoted-printable text, Apple's custom labels and vCard versions 2.1, 3.0 and 4.0 are read.

Can I turn a CSV back into a VCF?

Yes. Use a header row with names like First Name, Last Name, Company, Phone 1 and Email 1. CSV exports from Google Contacts and Outlook are recognized too, including their phone labels and split address columns. Import the .vcf by opening it on your phone or Mac.

What happens to contact photos?

Photos are not copied, because a CSV cannot hold an image. Everything else a spreadsheet can show is kept: names, organization, job title, phones, emails, addresses, website, birthday and notes.

Is my address book uploaded anywhere?

No. The file is read and converted in your browser and nothing is sent to a server, so your contacts never leave your device.

Sources

More free tools

All free tools