Example: two cards from a trade show, one of them empty
After a regional food trade fair, a supplier's rep exported three contacts from her phone as one .vcf. The third card held only a note, with no name, email or phone, so it was counted under Empty cards skipped instead of becoming a blank row.
Grace's card used typed phone lines, so her mobile and landline went into separate columns. Sam's older 2.1 card had two email lines and no structured name, so the second address went into email_2 and the converter split his display name into first and last name itself.
BEGIN:VCARD VERSION:3.0 N:Okafor;Grace;;; FN:Grace Okafor ORG:Hollin Bakery Supplies TITLE:Buyer TEL;TYPE=CELL:07700 900456 TEL;TYPE=WORK:0161 496 0321 EMAIL;TYPE=INTERNET:[email protected] ADR;TYPE=WORK:;;3 Mill Lane;Bury;Greater Manchester;BL9 0AA;UK END:VCARD BEGIN:VCARD VERSION:2.1 FN:Sam Pike ORG:Pike & Daughter Joinery EMAIL:[email protected] EMAIL:[email protected] END:VCARD BEGIN:VCARD VERSION:3.0 NOTE:met at expo END:VCARD
Contacts: 2 With email: 2 With phone: 1 Empty cards skipped: 1 full_name,first_name,last_name,organisation,job_title,email,email_2,...,phone_mobile,phone_work,...,street,town,county,postcode,country Grace Okafor,Grace,Okafor,Hollin Bakery Supplies,Buyer,[email protected],,...,07700 900456,0161 496 0321,...,3 Mill Lane,Bury,Greater Manchester,BL9 0AA,UK Sam Pike,Sam,Pike,Pike & Daughter Joinery,,[email protected],[email protected],...
Turning a .vcf into a spreadsheet
Export the contacts
Phones, Outlook and webmail contact books can all export vCard. One file per person or one file for everyone both work.
Choose the files or paste the text
Press Choose .vcf files and select as many as you like; the page lists the files it read. Card text copied from an email can be pasted into the box instead.
Check the counts and preview
The summary shows contacts found, how many have an email or phone, and how many empty cards were skipped. The table shows name, company, email, mobile, work phone and postcode.
Download the CSV
contacts.csvhas 20 fixed columns and opens in Excel, Google Sheets or LibreOffice, or imports into a CRM.
Where each vCard property ends up
vCard stores some details as one line with parts separated by semicolons. The converter splits those parts into their own columns.
| vCard property | CSV column | What happens |
|---|---|---|
| FN | full_name | Built from the N parts, or the company, if missing |
| N | first_name, last_name | If absent, the full name is split at the last space |
| ORG | organisation | First part only; the department is dropped |
| email, email_2, email_3 | Duplicates dropped; a third and later addresses share email_3, separated by a pipe | |
| TEL | phone_mobile, phone_work, phone_home, phone_other | Sorted by the TYPE label; fax and unlabelled numbers go to phone_other |
| ADR | street, town, county, postcode, country | One address: the first, or a work address if one follows |
| TITLE, URL, BDAY, NOTE | job_title, website, birthday, note | As written; first website only |
What does not come across
Photos and logos are left out, as are custom X- properties, social profile links, categories and groups. If you rely on those, keep the original .vcf as your master copy.
Older 2.1 cards sometimes encode accented names as quoted-printable text; that is decoded, and lines the format folds over several rows are joined, so long notes arrive in one piece.
Before you import the CSV somewhere else
- Check that phone numbers kept their leading 0: import the CSV with Excel's From Text/CSV and set phone columns to Text rather than double-clicking the file.
- Look for rows where a company name sits in the name column, which happens when a card has an ORG but no person.
- A business card exchange is not permission to send marketing email, so decide your basis before adding anyone to a list.
Questions people ask
How do I convert a VCF file to Excel?
Convert it to CSV on this page, then open the CSV in Excel using Data, From Text/CSV, so you can set phone columns to Text and keep leading zeros. Excel reads the CSV as a normal worksheet, and you can then save it as .xlsx. Opening the CSV by double-clicking also works, but Excel may reformat numbers.
Can I convert several vCard files at once?
Yes. Select all the .vcf files together in the file picker and they are read one after another into a single CSV. A single file that holds many cards, which is what most phones produce when you export all contacts, works the same way. The page lists the first few file names so you know what was read.
Does it work with vCard 4.0 and Google Contacts exports?
Yes. Versions 2.1, 3.0 and 4.0 are all read. Version 4.0 often writes phone numbers as tel: links with quoted types; both are handled, so tel:+441614960321 arrives as +441614960321 in the right phone column. Google Contacts and Apple exports are ordinary vCard files and convert the same way.
Where your data goes
The .vcf files you choose and any text you paste are read with your browser's own file reader and converted on this page. No contact detail is sent over the network or stored, and the CSV is built in memory and handed straight to your downloads folder.
Checked against the tool on