Skip to content

Convert

CSV to VCF

CSV to VCF

Beta

Turn a contacts spreadsheet into one .vcf file that iPhone, Android and Google Contacts import. Columns are matched by name and you can fix the mapping. vCard 3.0 or 4.0, and nothing is uploaded.

Use via API
  • Free, no sign-up
  • REST + MCP
  • Updated
  • Reviewed by Olgun Ozoktas

3.0 imports into iPhone, Android and Google Contacts. Choose 4.0 only when the destination asks for it.

CSV Input
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
vCard Output

One card per contact will appear here..

Why Use Our CSV to VCF Converter?

A spreadsheet is the easiest place to build or clean a contact list, and a phone will not import one. iPhone Contacts, the Android contacts app and iCloud all expect vCard, so a list tidied in Google Sheets or Excel still has to become contact cards before it is useful. Typing each row into the Contacts app is slow, and one typo is a number that never rings. CSV to VCF reads the spreadsheet, matches its columns to vCard fields, and writes one .vcf file that holds every contact. The conversion runs in your browser, so the contact list never leaves the tab.

vCard is the contact format behind every address book. RFC 2426 defines vCard 3.0 and RFC 6350 defines vCard 4.0, and a .vcf file can hold any number of cards one after another, which is what lets one file carry a whole list. CSV to VCF writes one BEGIN:VCARD to END:VCARD block per spreadsheet row, with the structured name (N), the display name (FN), company, job title, emails, phones, a home address, website, note, birthday and UID whenever the sheet has those columns.

Columns are matched by name after ignoring case, spaces and punctuation, so Full Name, full_name and FullName are one column. The name table covers common spreadsheet headers, the headers Google Contacts and Outlook exports use, and the headers FindUtils VCF to CSV writes, which is why a round trip through both pages brings names, emails, phones and addresses back to where they started. Anything the matcher gets wrong can be corrected in the column map.

Values are escaped as the standard requires, so a comma or a semicolon inside a company name does not split the field, and long lines are folded at 75 octets with the continuation indented by one space. A multi-line note keeps its line breaks. vCard 3.0 is the default because phones and Google Contacts import it most reliably; vCard 4.0 writes phone numbers as tel: URIs.

How it compares

Many CSV-to-vCard converters ask you to upload the contact list, which is a lot to hand over for a file of names, numbers and addresses. This page converts in the browser, recognises the column names Google Contacts, Outlook and FindUtils VCF to CSV use without any setup, and lists every row it skipped and why.

CSV to VCF Tips

  • Every card needs a name, an email or a phone. A row with none of them is skipped and listed by row number, so a stray totals row does not become an empty contact.
  • Separate First Name and Last Name columns are better than one Name column. They fill the structured N property that phones sort by, and the display name is built from them.
  • Phone, Mobile and Cell columns are written as a mobile number, Work Phone as work and Home Phone as home. Numbers are kept exactly as typed, so use international format such as +44 20 7946 0000 for contacts you call from abroad.
  • The file is written as UTF-8, so accented and non-Latin names come through. If Excel already mangled them, re-save the sheet as CSV UTF-8 before converting.
  • Photos are not written. A CSV has no reliable way to carry an image, and a card without a photo imports everywhere.

Frequently Asked Questions

How do I import a .vcf file into my iPhone?

Send the .vcf to yourself by email or message, tap the attachment on the iPhone, and follow the prompt to add the contacts. Every card in the file becomes its own contact, so one CSV to VCF download adds the whole list. You can also import the file on iCloud.com in Contacts, and the contacts then appear on the Apple devices signed in to that account.

How do I import the file into Google Contacts or Android?

In Google Contacts on the web, choose Import, select the .vcf and confirm. An Android phone that syncs contacts with the same Google account then shows the new contacts too. In the Google Contacts app on Android, tap Organize, then Import from file, and choose the .vcf.

Which columns does CSV to VCF recognise?

CSV to VCF recognises full name or first and last name, email, mobile or phone, work phone, home phone, company, job title, website, notes, street, city, region or state, postal code or ZIP, country, birthday and UID. It also reads the emails and phones columns that VCF to CSV writes, and common Google Contacts and Outlook export headers such as E-mail Address, Mobile Phone and Business Phone.

What if my columns have different names?

Open Adjust columns and pick the header for each contact field. The column map appears on its own when no name, email or phone column can be found, and the page lists which header it used for every field so a wrong match is easy to spot.

Why was one of my rows skipped?

A row is skipped when it has no name, no email and no phone number, because a contact card with none of those is empty on a phone. Skipped rows are listed by row number under the output. Completely blank rows are counted separately and never create a card.

Should I choose vCard 3.0 or 4.0?

Choose vCard 3.0 unless the destination asks for 4.0. Version 3.0 is the one iPhone Contacts, Android and Google Contacts import most reliably. Version 4.0 is newer and writes phone numbers as tel: URIs, which some older importers do not read.

Does it keep accented and non-Latin names?

Yes. The .vcf is written as UTF-8, so names like Ayşe Yılmaz or 山田太郎 come through unchanged. The usual problem happens earlier, in Excel: save the sheet as CSV UTF-8 rather than plain CSV, or the characters are already broken before the file reaches this page.

Can one contact have several phone numbers or emails?

Yes. Separate Mobile, Work Phone and Home Phone columns each become their own TEL line with the matching type. A phones or emails column holding several values separated by semicolons, as VCF to CSV writes it, adds the rest. A number that appears twice is written once.

Is my contact list uploaded?

No. The CSV is read and the .vcf is written in your browser, and no request carries the file. A contact list holds the numbers and addresses of everyone on it, which is why this tool never sends it anywhere. Open the browser's network panel while converting and nothing leaves.

Can I turn a .vcf back into a spreadsheet?

Yes, with FindUtils VCF to CSV, the reverse of this page. It writes one row per contact with the same column names CSV to VCF reads, so a contact list can go from .vcf to CSV for cleaning and back to .vcf without losing names, emails, phones or addresses.

Rate This Tool

0/1000

Get Weekly Tools

Suggest a Tool