Saved

Press the star next to a tool's name to save it.

All my tools

VCF to CSV (open .vcf contacts)

Use this VCF to CSV converter to turn a .vcf contacts file into a CSV table with names, phones, emails and addresses, in your browser, without uploading it.

Choose a contacts file saved as .vcf, for example from a phone or from an address book. The contacts are turned into a CSV table that opens in a spreadsheet. Nothing is uploaded.

The contacts are read in your browser. Nothing is uploaded.

Your contacts

Choose a .vcf file to see your contacts.

This VCF to CSV converter turns a contacts file saved as .vcf into a CSV table with one row per contact, ready to open in Excel, Google Sheets or any spreadsheet program. Choose your .vcf file, and the contacts are read in your browser and listed in columns for the name, organization, phone numbers, email addresses, address, website, birthday and notes. Nothing is uploaded: your address book stays on your device.

What a VCF file is

Wikipedia's vCard article explains that vCard is a file format standard for electronic business cards. A vCard can contain name and address information, phone numbers, email addresses, URLs, logos, photographs and audio clips. All vCards begin with BEGIN:VCARD and end with END:VCARD, and every one has a VERSION property. A .vcf file can hold one contact or hundreds, one after another, which is how phones and address books export a whole list at once.

What a CSV file is

The Comma-separated values article describes CSV as a simple text format, defined more formally in the 2005 standard RFC 4180, in which each line is a record and the fields are separated by commas. It is not limited to a particular character encoding but is commonly used with UTF-8. A CSV file opens in every spreadsheet, which makes it a convenient way to see, sort and edit your contacts, or to move them to another service.

How to use the VCF to CSV converter

  1. Export your contacts as a .vcf file from your phone, email account or address book.
  2. Choose the file or drop it on the box.
  3. Check the preview of the first contacts.
  4. Download the CSV or copy it.

The columns in the CSV

Each contact becomes one row. The columns are the full name, first name, last name, middle name, prefix and suffix; the organization and job title; the phone numbers and email addresses, each with its type, such as cell, home or work; the street, city, region, postal code and country of the first address; any other addresses in one cell; the website; the birthday; and the notes. The number of phone and email columns follows the contact with the most, up to five of each.

Worked example

Suppose your file holds a contact with the formatted name Ann Lee, the name parts Lee, Ann and Marie, the organization Acme and the title Manager, a work phone 555-0100, an email ann@example.com and a work address at 12 Main St, Springfield, IL 62701, USA. The CSV row has Ann Lee in the full name column, Ann in first name, Lee in last name, Marie in middle name, 555-0100 in Phone 1 with the type work, and the address split into street, city, region, postal code and country.

Older and newer vCard versions

The vCard article notes that VERSION must come immediately after BEGIN in the latest standard, except in the 2.1 and 3.0 versions, which allow it anywhere in the card. The converter reads all three versions, including the older style that stores accented characters as quoted-printable text, and values that are folded over several lines. Photos and other embedded data are ignored, because they do not belong in a table.

Commas, quotes and accents

A contact's notes or address can contain commas, quotation marks or line breaks. The converter puts any such field inside double quotation marks and doubles the quotation marks inside it, so that the columns stay in line when you open the file. The file is saved in UTF-8 with a byte order mark at the start, so that spreadsheet programs read names with accents and non-Latin letters correctly.

Limits

The converter reads up to 20,000 contacts from a file of up to 25 MB. The CSV article lists the row limits of common spreadsheet programs, such as 1,048,576 rows for Microsoft Excel and 1,000,000 for Apple Numbers, so a contact list of this size fits comfortably in a spreadsheet. If your file holds more contacts, split it into parts first.

Privacy

The conversion runs in your browser, so your contacts are never sent to a server. Close the page or press Clear to remove the list from the tool. If you want to share the CSV, remember that it contains names, phone numbers and email addresses, so keep it somewhere private.

Moving contacts to another service

The CSV is a convenient middle step when you move contacts from one address book to another. Many email services and phone systems import contacts from a CSV file, but each expects its own column names, so you may need to rename the headers in a spreadsheet before you import. Check one or two contacts after the import to make sure that names, numbers and emails ended up in the right fields.

Tidying contacts in a spreadsheet

A spreadsheet makes it easy to find duplicates, sort by organization, delete old entries and correct phone numbers. After editing, you can keep the CSV as a backup of your contacts, or import it back into your address book if it supports that. Keep a copy of the original .vcf file too, since it holds details, such as photos, that the CSV leaves out.

Common mistakes

  • Choosing a CSV or Excel file. The tool reads .vcf files only.
  • Expecting photos. They are not included.
  • Importing the CSV with the wrong encoding. Choose UTF-8 if names look garbled.
  • Sharing the file carelessly. It holds personal details.

What next

Use this often? Add VCF to CSV ( to your Home screen.

Frequently asked questions

How does a VCF to CSV converter work?

It reads each vCard in the file and writes one CSV row per contact, with columns for the name, phones, emails and address.

What is a .vcf file?

A file in the vCard format for electronic business cards, which can hold many contacts.

Are photos included in the CSV?

No. Photos and other embedded data are left out.

Which vCard versions work?

Versions 2.1, 3.0 and 4.0.

Is my contacts file uploaded?

No. The conversion runs in your browser.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Developer Tools