Convert a .vcf contacts file to Excel or CSV

A .vcf file (a vCard) is what a phone or an address book gives you when you export contacts. It is readable text, but it is one block per person, so a file with four hundred contacts is unusable as a list. This page turns it into a table: one row per person, one column per field.

The conversion happens in your browser. There is no server to send the file to, no account, and no analytics on this page. If you open your browser's network tab while converting, you will see nothing leave.

iPhone

Open Contacts, tap a contact, then Share Contact for one person. For the whole address book it is easier on a computer: sign in at iCloud Contacts, select all, then Export vCard from the settings menu at the bottom left.

Android and Google Contacts

At contacts.google.com, choose Export and pick vCard. On the phone itself, the Contacts app has Settings → Export, which writes a .vcf to your storage.

Outlook and other address books

Most of them export vCard as well; anything that ends in .vcf works here, including the older 2.1 files that older phones and some CRMs still produce.

• One column per value. Three phone numbers means three columns, each with its own label column, instead of three numbers crammed into one cell.
• Addresses split into street, city, state, ZIP and country, so a mail merge works.
• Custom labels kept as they were written, including the ones an iPhone stores separately from the number itself.
• Every cell written as text, so a phone number starting with 0 or + is not turned into a number by the spreadsheet.
• Both a real .xlsx (opens in Excel, Numbers, Google Sheets) and a .csv saved as UTF-8 with the byte-order mark Excel wants.

Contact photos are ignored, because a spreadsheet has nowhere to put them.

Is my contacts file uploaded anywhere?

No. The page has no server side. Your file is read with the browser's own file reader, converted by the script linked above, and handed back to you as a download. You can put the machine in airplane mode before dropping the file and everything still works.

Will Excel mangle my phone numbers?

No. Every cell is written as text, which is the whole reason a converter like this exists: the common failure is a spreadsheet reading +1 555 0142 as arithmetic or stripping the leading zero from a ZIP code.

Can I import the result into Gmail or Outlook?

You can, but those two want their own column names. This page produces a readable spreadsheet, which is what most people are after. If you need a file that Google Contacts or Outlook imports without touching the headers, the iPhone app below writes their exact column names.

How many contacts can it handle?

Thousands. It is your own machine doing the work, so the limit is your browser's memory, not somebody's upload cap.

Which vCard versions work?

2.1, 3.0 and 4.0, including quoted-printable text from older phones and lines folded across several rows. If a file does not parse, it is worth telling us. The format has more dialects than it should.