Convert a contacts VCF file to CSV

Turn a .vcf contacts export from a phone, Gmail or iCloud into a CSV spreadsheet, one row per contact. Names in any language survive, and nothing is uploaded.

Your contacts in a spreadsheet, without handing the list to a server

A .vcf file is how phones and email services export contacts: one vCard after another, each with a name, numbers and addresses written in a format meant for other address books rather than for people. A spreadsheet is far easier to sort, clean or merge, and this turns one into the other.

Open the file or paste its text. Every contact becomes a row with the full name, given and family names, each phone number and email address with its type, the organisation, job title, address, birthday, note and website. A contact with three numbers gets three phone columns; one with a single number leaves the others empty.

The parts most converters get wrong

The vCard format has three versions in daily use: 2.1, 3.0 (RFC 2426) and 4.0 (RFC 6350). Exports in 2.1, which many older Android phones still write, store any name with a letter outside plain English as quoted-printable, a run of codes like =E0=A4=B0, and break long values over several lines with an “=” at the end of each. A converter that skips this shows the codes instead of the name. This one decodes them, so a contact saved as रवि कुमार or محمد comes out with that name.

Other details are handled too. Long lines folded onto the next one are joined again. Group prefixes such as item1.TEL, which some address books add to labelled numbers, are read as the field they label. Escaped commas and semicolons inside a company name stay in the name rather than splitting it.

Opening it in a spreadsheet

The CSV is written in UTF-8 with a header row. If your spreadsheet program asks which encoding to use when it opens the file, choose UTF-8 so names with accents or in other scripts are read as written. A number written with its country code, such as +44 7700 900000, starts with an apostrophe in the file, so a spreadsheet keeps it as written rather than reading it as a sum; CSV to VCF takes the apostrophe off again. To go the other way, from a spreadsheet back to a file a phone can import, use CSV to VCF. To clean the list first, Remove CSV duplicates finds repeated rows.

A contacts file holds other people’s names, numbers and addresses. Nothing here is uploaded: the file is read and converted in your browser and is gone when you close the tab.

How to convert a VCF file to CSV

  1. 1

    Open the .vcf file or paste its text

  2. 2

    Let each contact become a row

  3. 3

    Download the CSV and open it in Excel or Sheets

Everything you need

Every vCard version read

Versions 2.1, 3.0 and 4.0, including folded lines, labelled numbers and quoted-printable names in any language.

One row per contact

Name, given and family name, every phone and email with its type, organisation, title, address, birthday, note and website.

Private by design

The list never leaves your device, which matters for a file full of other people's numbers and addresses.

Nothing is uploaded, and you can verify it

Processing runs on this device. Open the browser’s Network panel while the tool works and you will see no file upload request to FileGizmo. Temporary previews use local browser URLs, and closing or resetting the page releases them instead of leaving a server copy behind.

No daily limits, no watermarks

Use the tool without a daily task counter, account wall or watermark. Nothing is uploaded, so your device’s memory sets the practical size. Free limits a few repeat-work features, such as 20 images per background batch.

Works on any device, and offline after first load

Use a current browser on desktop, Android, iPhone, or iPad without installing an app. Once this tool and its required assets load, the cached workflow works without a connection. Large jobs are usually more comfortable on a desktop with additional memory.

Frequently asked questions

Why do some converters show names as =E0=A4 codes?

Many Android phones write contacts in vCard 2.1, where a name with any non-English letter is stored in quoted-printable form and split over several lines. This tool decodes that form, so a name in Hindi, Arabic or Chinese comes out as the name.

What happens to contacts with several phone numbers?

Each gets its own column, Phone 1, Phone 2 and so on, with a column beside each saying whether it is a mobile, home or work number. The file has as many phone and email columns as the busiest contact needs.

Will it open in a spreadsheet?

Yes. The CSV is UTF-8 with a header row, the form spreadsheet programs import. If a program asks which encoding the file uses, choose UTF-8 so names with accents or in other scripts read as written.

Are my contacts uploaded?

No. The file is read and converted in this browser tab. A contacts list is other people's personal data, so it never leaves your device.

Sources

Related guides

Move contacts between a phone and a spreadsheetHow contacts are stored in a .vcf file, why names turn into codes in some converters, and how to go from phone to spreadsheet and back without losing numbers.