Skip to content
ToolPlankDEV
Text Tools
100% In-Browser Execution

Updated:

VCF to CSV Converter

Paste or open a .vcf file and get a CSV as you type. This vcf to csv converter online reads vCard 2.1, 3.0 and 4.0, decodes the accents in old Android exports, writes Google, Outlook or all-fields columns, flags duplicate contacts and never uploads your contacts.

Options:

VCF (vCard)

Input
0 chars · 0 lines

CSV

Ready
Processing in browser...
0 chars · 0 linesUpdates as you type

Contacts and notes

The first contacts, possible duplicates and anything left out appear here once there is a result.

Processed on your device. Your text is not sent to our servers.

More free tools you may need next.

Quick Guide

How to use VCF to CSV

Simple step-by-step instructions to get the exact output you need.

  1. 01

    Paste or open your VCF file

    Paste the text of the .vcf file into the left box, press Paste, or open the file. One file can hold many contacts. Example loads three contacts, and Android 2.1 export, iPhone with groups and photo and Duplicates load other cases.

  2. 02

    Check the first contacts and the notes

    The panel under the result lists the first contacts, contacts that share a phone number or an email, the vCard versions found, and anything left out such as photos or fields with no CSV column.

  3. 03

    Choose the columns, BOM and separator

    All fields keeps every phone, email and address in numbered columns. Google Contacts and Outlook use the column names those programs use. Keep the UTF-8 BOM on for Excel on Windows, and switch to a semicolon if your Excel expects one.

  4. 04

    Copy or download the CSV

    Press Download to save contacts.csv and open it in Excel or import it into Google Contacts, Outlook or a mailing list tool.

How to convert VCF to CSV

A VCF file, also called a vCard, stores contacts as text. Every contact sits between BEGIN:VCARD and END:VCARD, with one line for the name, one for each phone number, one for each email and so on. To convert vcf to csv, the tool reads every block, decodes it and writes one CSV row per contact, so the contacts open as a table in Excel.

Phone books are private. The file is read in your browser and nothing is uploaded, as the Privacy Policy explains.

VCF to CSV with correct accents (UTF-8)

Names such as Müller or José break when a CSV is opened with the wrong encoding. This tool writes UTF-8 and, by default, adds a byte order mark at the start of the file. That marker is what makes Excel on Windows open the file as UTF-8, so vcf to csv utf-8 output shows accents, Cyrillic, Arabic and Chinese correctly when you double-click it. Turn the BOM off for programs that dislike it.

One more safeguard is on by default. A contact name or note that begins with =, +, -, @ or a tab can run as a formula when the CSV is opened in Excel. Protect formulas puts a ' in front of such text, and the notes count the cells. Phone numbers that start with + are left as they are.

Old Android exports use vCard 2.1 and write non-ASCII letters as quoted-printable, such as M=C3=BCller. The tool decodes those, honours a CHARSET setting and joins the soft line breaks that split long values, so the text comes out readable. The notes tell you how many fields were decoded.

Column presets: All fields, Google Contacts and Outlook

  • All fields: Full Name, First, Middle, Last, Prefix, Suffix, Nickname, Organization, Department, Job Title, Birthday, Notes, then Phone 1, Phone 2 and so on with a Type column each, the same for emails and addresses, and Websites. Nothing is dropped, up to ten of each.
  • Google Contacts: column names such as First Name, E-mail 1 - Value and Phone 1 - Label, which is the layout of a Google Contacts CSV export.
  • Outlook: column names such as Mobile Phone, Business Phone, E-mail Address and Home Street. Phones go to the slot for their type, and only three emails and one address per kind fit.

When a preset has no room for a value, the notes say how many values did not fit, and choosing All fields keeps them. Try a few rows in the target program first, because programs change their import columns over time.

A worked example

This vCard has two phones of different types, an escaped comma and a company with a department:

Text
BEGIN:VCARD
VERSION:3.0
N:GarcĂ­a;Ana;;;
FN:Ana GarcĂ­a
ORG:Café Nord;Kitchen
TEL;TYPE=CELL:+49 171 2345678
TEL;TYPE=HOME:+49 30 5550 0101
EMAIL;TYPE=INTERNET,WORK:ana@example.com
ADR;TYPE=HOME:;;Hauptstr. 1\, Apt 2;Berlin;;10115;Germany
END:VCARD

With All fields this becomes one row. The escaped comma is plain text again, and the types become labels:

csv
Full Name,First Name,Last Name,Organization,Department,Phone 1 Type,Phone 1,Phone 2 Type,Phone 2,Email 1 Type,Email 1,Address 1 Type,Address 1 Street,Address 1 City,Address 1 Postal Code,Address 1 Country
Ana García,Ana,García,Café Nord,Kitchen,Mobile,+49 171 2345678,Home,+49 30 5550 0101,Work,ana@example.com,Home,"Hauptstr. 1, Apt 2",Berlin,10115,Germany

The real output has the empty columns too, such as Middle Name and Prefix, so every contact has the same columns.

Duplicates, photos and fields with no column

Contacts that share a phone number or an email with an earlier contact are listed under Possible duplicates. The comparison ignores spaces, dashes and a leading 00 or + on numbers, and the case of emails. Every contact stays in the CSV. The tool only points them out, because deciding which one to keep is your job.

Photos and logos cannot go into a CSV, so they are skipped and counted. Fields that have no CSV column, such as custom labels and social profiles, are named in the notes so you know what the file leaves out. A contact with only a full name is split at its last space so the first and last name columns are filled, and the notes count those.

Where to get a VCF file and what to do with the CSV

On Android, the Contacts app exports a .vcf under Export. On an iPhone, iCloud lets you export vCard from icloud.com. Outlook and Google Contacts offer the same. Once you have the CSV, edit it in Excel, import it into another service, or load it into a CRM or mailing list tool.

To go back, CSV to VCF rebuilds a vCard file from a CSV. If you have several CSV files to combine first, Merge CSV Files does that, and CSV to Markdown shows a CSV as a table for documents.

Frequently Asked Questions

Technical Q&A for VCF to CSV

Common questions about edge cases, character encoding, and privacy guarantees.

Paste the text of the .vcf file or open the file, and the CSV appears on the right. Press Download to save contacts.csv.

Convert it here, download the CSV, and double-click it. With the UTF-8 BOM option on, Excel on Windows opens it with accents shown correctly.

On Android, use Export in the Contacts app. On an iPhone, export vCard from the Contacts page on icloud.com. Both produce a .vcf file that you can paste or open here.

The CSV was opened with the wrong encoding. Keep UTF-8 BOM on so Excel reads UTF-8. Old Android files with quoted-printable text, such as M=C3=BCller, are decoded for you.

Yes. Every BEGIN:VCARD block becomes one row, and files with thousands of contacts convert in the browser.

Versions 2.1, 3.0 and 4.0 are read, including quoted-printable text, grouped properties such as item1.EMAIL, and folded long lines.

Yes. Choose the Google Contacts or Outlook preset to get column names those programs know, and try a few rows first.

They are skipped and counted in the notes, because a CSV cannot hold images.

No. The file is read in your browser and nothing is sent to a server.