Convert VCF to XLSX

Turn VCF files into XLSX. One sheet named after the file with a row per contact under a header of every property in first-seen order, keyed by property name with its parameters, such as TEL;TYPE=CELL, so each kind of phone or address gets its own column; a property a contact repeats is written into its cell as JSON text.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop VCF files on the dialor turn it to pick what to do

Contacts in rows and columns.Each contact becomes one row in an Excel sheet, with a column for every property.

  1. What you get

    One XLSX file with a single sheet, named after the file. Each contact gets a row under a header row.

    The header lists every property in the order it first appears. Columns are keyed by property name with its parameters, such as TEL;TYPE=CELL, so each kind of phone or address gets its own column.

  2. How values are written

    Escapes in the vCard text are resolved. Names, organizations and addresses keep their semicolon-separated parts in the cell.

    If a contact repeats a property, the repeated values are written into one cell as JSON text.

    The header row stays text. Phone numbers with a leading zero or a + stay text too, so the zero and the plus sign are not lost.

  3. Going the other way

    To turn a sheet back into contacts, use XLSX to VCF. For other conversions from this format, see every VCF conversion.

VCF and XLSX.What each format is.

The formats

From · VCF

vCard

vCard contacts.

Extensions
.vcf .vcard
MIME type
text/vcard
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same VCF to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.vcf report.xlsx
$ cv convert report.vcf report.xlsx

Questions.What people ask about VCF to XLSX.

01OF 04

Yes. Every contact is one row, under a header row that lists the properties.

Columns are keyed by property name with its parameters. A cell phone, such as TEL;TYPE=CELL, gets a different column from other kinds of phone.

The repeated values are written into one cell as JSON text.

Yes. Phone numbers with a leading zero or a + stay text, so they are not turned into plain numbers.

More conversions.Other ways in and out of VCF and XLSX.