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.
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.
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.
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
vCard
vCard contacts.
- Extensions
- .vcf .vcard
- MIME type
- text
/vcard - Kind
- Text and data
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.
$ cv convert report.vcf report.xlsx$ cv convert report.vcf report.xlsxQuestions.What people ask about VCF to XLSX.
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.