AnyFormat

00 CSV → VCF

CSV to VCF

Produces vCard 3.0, which every phone imports.

01CSV in
02VCF out
03Options 1
  • No upload The conversion runs in this tab. Your file never travels — not to us, and not to the advertising.
  • No sign-up, no email, no daily cap There is no account system to sign up to.
  • No size limit we invented Only your device's memory — about ~2 GB on a desktop browser, ~400 MB on a phone.
  • Turn your Wi-Fi off and convert anyway The conversion needs nothing but this page. Ads will not load without a connection; your file will still convert. That is the whole claim, and it takes five seconds to check.

Turns a spreadsheet of people into a vCard file your phone will import. The usual case is a list that lives in Excel — a membership roll, a team directory, a delegate list — that needs to end up in an address book.

Which columns are recognised

Names come from First Name and Last Name, or from a single Name / Full Name column. At least one is required.

Any column whose name mentions e-mail becomes an email address, and any column mentioning phone, tel, mobile or cell becomes a phone number. That means a Google Contacts export with E-mail 1 - Value through E-mail 4 - Value comes across whole, without you mapping anything.

Also recognised: Organization / Company, Job Title / Role, Street, City, Region / State, Postal Code / Zip, Country, Birthday, Website / URL, Notes.

Why version 3.0 and not 4.0

vCard 4.0 is the current standard and has been since 2011. It is also the one with patchier support: some Android versions and several older mail clients refuse it outright.

3.0 is read by everything — iPhone, Android, Outlook, Google Contacts, Thunderbird — and expresses everything a CSV can carry. Choosing the newer version would buy nothing and cost compatibility.

One file, many contacts

All the contacts go into a single .vcf, one BEGIN:VCARD block after another. Every address book handles that — iOS asks whether to add all of them, Android imports the lot, Outlook creates one contact per block.

Long values are folded at 75 octets as the specification requires, which is what stops a long note truncating in strict readers.

Phone number formatting

Numbers are written exactly as your spreadsheet has them. If you want them to work when tapped from any country, put them in international form first — +44 20 1234 5678 rather than 020 1234 5678. Watch for Excel having stripped a leading zero or turned a long number into scientific notation; format the column as Text before exporting.

Other names for this

Also searched as “csv to vcard”, “excel to contacts”, “spreadsheet to vcf”.

Questions

How do I import the file into my phone?
iPhone: email it to yourself and open the attachment, or use iCloud.com → Contacts → Import. Android: Contacts → Settings → Import → .vcf file. It usually just works from a file manager too.
Which vCard version does this produce?
Version 3.0, because it is the one every phone and mail client accepts. 4.0 is newer and less widely supported.
My phone numbers lost a leading zero.
Excel did that, not the conversion. Format the column as Text before exporting, or write numbers in international form with a leading +.
Can I include photos?
Not from a CSV — a photo would have to be Base64 in a cell, which spreadsheets handle badly and Excel truncates.
Is this safe for other people’s personal data?
Uploading an address book to a third-party service is a disclosure of other people’s personal data, and under the GDPR that needs a lawful basis you almost certainly do not have. Nothing is transmitted here, so the question does not arise. Turn your Wi-Fi off and check.