Map Extract
Free tool

Convert vCard contacts to a CSV file

Drop in one or more .vcf files exported from a phone, Outlook or a contacts app, or paste the card text. You get a CSV with one row per person and separate columns for name parts, company, job title, up to three emails, four kinds of phone number and a postal address.

Runs in your browser. Nothing you enter is uploaded.

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.

Input
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
Result
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

  1. Export the contacts

    Phones, Outlook and webmail contact books can all export vCard. One file per person or one file for everyone both work.

  2. 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.

  3. 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.

  4. Download the CSV

    contacts.csv has 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 propertyCSV columnWhat happens
FNfull_nameBuilt from the N parts, or the company, if missing
Nfirst_name, last_nameIf absent, the full name is split at the last space
ORGorganisationFirst part only; the department is dropped
EMAILemail, email_2, email_3Duplicates dropped; a third and later addresses share email_3, separated by a pipe
TELphone_mobile, phone_work, phone_home, phone_otherSorted by the TYPE label; fax and unlabelled numbers go to phone_other
ADRstreet, town, county, postcode, countryOne address: the first, or a work address if one follows
TITLE, URL, BDAY, NOTEjob_title, website, birthday, noteAs 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

Top