How to convert CSV to VCF
A CSV file is a table with one contact per row. A VCF file, also called a vCard, is the format that phones and mail apps import contacts from. To convert csv to vcf, each row becomes one BEGIN:VCARD block with the name, phone numbers, emails, company, address, birthday and notes written on separate lines, and all blocks sit in one file.
This csv to vcf converter online free reads your header row and finds the columns by name, so you do not map anything by hand. Contacts are private data. The conversion runs in your browser and nothing is uploaded, as the Privacy Policy explains.
Which column headers are recognised
- Names: First Name, Given Name, Last Name, Family Name, Middle Name, Name, Full Name, Display Name, Nickname, Prefix and Suffix.
- Phones: any column with Phone, Mobile, Cell, Tel or Fax in its header. Mobile, Home, Work and Fax in the header set the type.
- Emails: any column with E-mail or Email in its header. Home and Work in the header set the type.
- Work: Company, Organization, Department and Job Title. In an Outlook export, a Title column next to Job Title is the prefix, such as Dr.
- Addresses: Street, City, State or Region, Postal Code or ZIP and Country, with an optional Home, Work or Business in front.
- Other: Birthday, Notes and Website.
Google Contacts exports use pairs such as Phone 1 - Label and Phone 1 - Value. The label becomes the phone type and the value becomes the number. Several numbers in one cell separated by a space, three colons and a space are split into separate phones.
A worked example
This CSV has a contact with a comma in the address and a semicolon in the notes:
First Name,Last Name,Mobile Phone,E-mail Address,Company,Home Street,Home City,Notes
Ana,GarcĂa,0171 234567,ana@example.com,CafĂ© Nord,"Hauptstr. 1, Apt 2",Berlin,"Likes tea; coffee"With the country code +49, it becomes this vCard 3.0 contact. The leading 0 is replaced by the country code, and the comma and the semicolon are escaped with a backslash as the format requires:
BEGIN:VCARD
VERSION:3.0
N:GarcĂa;Ana;;;
FN:Ana GarcĂa
ORG:Café Nord
TEL;TYPE=CELL:+49171 234567
EMAIL;TYPE=INTERNET:ana@example.com
ADR;TYPE=HOME:;;Hauptstr. 1\, Apt 2;Berlin;;;
NOTE:Likes tea\; coffee
END:VCARDvCard 3.0 or 4.0
Version 3.0 is the safe choice. Android, iPhone, Outlook and Google Contacts all read it. Version 4.0 is the newer standard and drops the INTERNET marker on emails, but some older apps do not accept it. Both versions are written with UTF-8 text, CRLF line ends and long lines folded at 75 bytes without cutting a character in half, so accents, Cyrillic and emoji arrive intact.
How to import the VCF on Android, iPhone and Outlook
On Android, open the downloaded .vcf file or choose Import in the Contacts app. On an iPhone, send the file to yourself by email or AirDrop, open it and tap Add All Contacts, or import it at icloud.com in the Contacts page. In Outlook, use the import option for a vCard file. Google Contacts also accepts a .vcf under Import.
Check a few contacts after the first import before you load a large file. If a contact exists already, some apps create a duplicate, so remove old entries first if you want a clean list. Need a CSV from a VCF instead? VCF to CSV does the reverse.
Excel problems this tool catches
Excel often damages phone numbers. A number like 919877000000 can turn into 9.19877E+11 once the cell is formatted as a number, and the lost digits cannot be restored. Rows with such a value are listed in Warnings and the number is left out instead of saving a wrong one. Format the phone column as text in Excel before you save the CSV.
Birthdays must be real dates in year-month-day form, such as 1990-05-17. Other formats, and impossible dates like February 30, are listed and left out because a day-month guess could be wrong. If you need to merge several exports first, Merge CSV Files combines them.
Limits
The tool does not embed photos, does not create one file per contact and does not contact Google, Apple or Microsoft. Each row yields one contact, and rows with no name, phone or email are skipped and listed. For a quick look at the CSV before converting, CSV to Markdown shows it as a table.