How to Open a VCF File and Convert Contacts to Excel

What is a VCF file?

A .vcf file is a vCard: a plain-text format for storing contact information. One file can hold a single contact or thousands. Phones, email clients, and address books all use it to share contacts because nearly every device understands it. If someone sent you a .vcf, or you exported one from your phone, this guide shows how to open it and turn it into a spreadsheet.

How to open and read a VCF file

Because a vCard is plain text, you can open it in any text editor (Notepad, TextEdit, VS Code) to read it. You will see blocks that start with BEGIN:VCARD and end with END:VCARD, with lines like FN (full name), TEL (phone), and EMAIL. That is readable, but not convenient if you have many contacts.

To use the contacts, you usually want them either back in an address book, or in a spreadsheet you can sort and filter.

Import into an address book:: double-clicking a .vcf on most systems offers to add the contacts to your default contacts app.

Open as a spreadsheet:: convert the .vcf to Excel or CSV, which is the better choice if you want to clean, dedupe, or analyze the list.

Converting a VCF to a spreadsheet

SheetBeam's vCard to Excel converter reads the .vcf in your browser and produces a table with columns for Full Name, First Name, Last Name, Organization, Title, Email, Phone, Address, URL, and Note.

A few things worth knowing about how it handles real contact files:

Multiple phones and emails are kept.: When a contact has several numbers or addresses, they are combined into one cell separated by semicolons, so nothing is dropped.

Older encodings are decoded.: vCard 2.1 files often store accented names with quoted-printable encoding; the converter decodes them correctly, so "Jose" with an accent stays correct rather than turning into garbled characters.

All vCard versions work.: Files from version 2.1, 3.0, and 4.0 all use the same core fields, which is what the converter reads.

Where VCF files come from

Google Contacts (export and convert)

iPhone and iCloud (export and convert)

Android phones (export and convert)

Privacy

Contact lists are sensitive. SheetBeam converts the .vcf entirely in your browser, so your contacts are never uploaded to any server. You can confirm this by disconnecting from the internet: the converter still works.

Tips for the resulting spreadsheet

Use your spreadsheet's "Remove Duplicates" feature to clean the list.

Sort by Organization to group colleagues.

If a cell holds several phone numbers, use Text to Columns to split them when you need each in its own column.