vCard to CSV

Phones and mail apps export contacts as vCard files (.vcf): a plain-text format that stacks one BEGIN:VCARD … END:VCARD block per person. Spreadsheets and most contact importers want flat CSV rows instead. Paste one card or hundreds below and this converter pulls each contact’s name, email and phone into three tidy CSV columns you can copy straight into Excel, Google Sheets or a contacts importer.

How to convert vCard to CSV

  1. 1

    Paste your vCard text

    Copy the contents of your `.vcf` file and paste it in the box. One `BEGIN:VCARD … END:VCARD` block or hundreds, it all works.

  2. 2

    Convert to CSV

    Press Convert. Each vCard block becomes one CSV row with the full name, email and phone.

  3. 3

    Check the columns

    The output always uses the same three headers: `name`, `email`, `phone`. Values containing a comma or quote are quoted automatically so the CSV stays valid.

  4. 4

    Copy and import

    Copy the result into a `.csv` file, then open it in Excel or Google Sheets, or feed it to any importer that accepts name, email and phone columns.

What ends up in the CSV

Every contact becomes one row with exactly three columns:

CSV column vCard source Notes
name FN The formatted full-name line, e.g. FN:Ada Lovelace.
email EMAIL The first email line on the card.
phone TEL The first phone line on the card.

Type parameters such as EMAIL;TYPE=WORK or TEL;TYPE=CELL are recognised, so the value is read correctly however the label is written.

One contact per vCard block

The converter scans the whole text for every BEGIN:VCARD … END:VCARD pair, so a single export holding dozens or hundreds of contacts turns into the same number of CSV rows in one pass. The header row (name,email,phone) is written once at the top.

Good to know

  • First value wins. If a contact lists several phones or emails, the converter keeps the first TEL and the first EMAIL line. Reorder the lines in the vCard if a different one should come out.
  • Three columns only. Fields such as organisation (ORG), postal address (ADR), job title (TITLE) or birthday (BDAY) are not exported, keeping the sheet focused on the essentials of a mailing or phone list.
  • Automatic quoting. A name like Doe, Jr. is wrapped in quotes so the comma does not split it into two columns; any quote inside a value is doubled, following the standard CSV rules.
  • Plain text in, plain text out. Paste the raw card text (open a .vcf in any text editor to see it); the CSV comes back in the box ready to copy.

Frequently Asked Questions

Yes. Paste as many BEGIN:VCARD … END:VCARD blocks as you like; each one becomes its own row in the CSV, with a single header line at the top.

Three: the full name (FN), the first email (EMAIL) and the first phone number (TEL). Other vCard fields such as address, organisation or birthday are left out.

The first TEL line on the card. If you need a specific number, move that line above the others in the vCard before converting.

Copy the output, paste it into a plain-text file and save it with a .csv extension, or paste it straight into a new spreadsheet. The three columns line up with the name, email and phone fields most contact importers expect.

Related Tools

Tool available in other languages