CSV to vCard Converter

About CSV to vCard Converter

CSV to vCard Converter turns a spreadsheet of contacts into a .vcf file that phones and address books import directly. A CSV or Excel list is the usual way contacts leave a CRM, an email service, an old phone, a company directory or a sign-up form, but iPhone, iCloud and Android do not read spreadsheets. They read vCards. The hard part of the conversion is not the file format, it is knowing which column is which. A generic converter guesses, and a wrong guess puts surnames in the first name field, home numbers under Mobile or a company name where the person should be, and you only notice after hundreds of contacts are already on your phone. This tool shows every column of your file next to two sample values and a dropdown, so you decide that First Name goes to First name, Mobile goes to Mobile phone and Comments goes to Notes. Common layouts are matched automatically, including exports from Google Contacts, Outlook, iCloud, HubSpot, Mailchimp and spreadsheets with headers in English, Serbian, German, French, Spanish and Italian. Google exports that store the phone type in a separate column are understood, so a number labelled Work stays a work number. Before anything is downloaded you see the first five contacts as cards, along with a list of problems: phone numbers that Excel turned into scientific notation such as 3.81641E+11, numbers with letters or too few digits, email addresses without a domain and birthdays that cannot be read. You can add several CSV and XLSX files at once, for example exports from two phones, and merge them into one .vcf with exact duplicates removed, or keep one .vcf per file. An optional country code converts local numbers like 064 123 4567 into the international +381 64 format, which makes calls and WhatsApp work when you travel. Everything runs in your browser, so the contact list is never uploaded anywhere. If your contacts are in JSON rather than a spreadsheet, convert them first with JSON to CSV Converter, to go the other way and turn a .vcf back into a spreadsheet use VCF to CSV & Excel Converter, and to share a single contact as a scannable code use QR Code Generator.

A few habits make a contact import go smoothly. Keep the name in separate First name and Last name columns if you can, because phones sort and search by last name; if your list has only one Name column, the split option turns "Ana Petrović" into first name Ana and last name Petrović, and "Petrović, Ana" is understood too. Store phone numbers as text in Excel, not as numbers, otherwise leading zeros disappear and long numbers lose digits; a number that arrives as 641234567 instead of 0641234567 still imports, but calls may fail. Use the international format with a plus sign whenever contacts are used in more than one country. One column can hold several values when they are separated the way Google does it, with " ::: ", and several columns can point to the same field, for example two mobile numbers or a work and a private email, which all end up on the same contact. Columns you do not need, such as internal IDs or lead scores, can simply be set to Do not import. If the preview shows strange characters like é instead of é, the file was saved in an older encoding: choose Windows-1252 for Western European text, Windows-1250 for Central European or Windows-1251 for Cyrillic in the encoding menu. On iPhone, opening a .vcf that holds many contacts offers Add All Contacts in one tap. Outlook desktop imports only the first contact of a multi-contact file, so for Outlook choose one .vcf per contact. Google Contacts and iCloud accept the combined file. To clean a list of emails or numbers before converting, Duplicate Line Remover removes repeated lines, and an Email Signature Generator is handy once your new address book is set up.

How to use CSV to vCard Converter

  1. Drop one or more CSV or Excel contact files
  2. Match each column to a contact field and check the preview and warnings
  3. Download the .vcf and import it on iPhone, iCloud, Android or Google

Frequently Asked Questions

How do I convert a CSV file to vCard?
Drop the CSV onto the tool. Each column appears with sample values and a dropdown that is already filled in where the header is recognised. Check that names, phones and emails point to the right fields, look at the five preview contacts, then click Download vCard. You get a single .vcf file with every contact in it.
How do I get contacts from Excel onto my iPhone?
Load the .xlsx file here, match the columns and download the .vcf. Email the file to yourself or AirDrop it to the iPhone, open it and tap Add All Contacts. To put the contacts in iCloud so they appear on every Apple device, open icloud.com/contacts on a computer, click the plus button, choose Import Contact and select the file.
Why are my phone numbers shown as 3.81641E+11?
Excel stores long numbers as numbers and shows them in scientific notation, and when the sheet is saved as CSV the missing digits are gone for good. The tool flags every number in that format. Go back to the spreadsheet, format the phone column as Text, fix the numbers and export again. Saving as .xlsx instead of .csv also keeps the full number.
Can I convert several CSV files at once?
Yes. Select or drop several CSV and XLSX files together, or add more later. Files with the same columns share one mapping, and files with a different layout get their own. You can download one .vcf with all contacts, with exact duplicates removed, one .vcf per input file, or one .vcf per contact in a ZIP.
Which vCard version should I choose?
Version 3.0 is the safe choice. iPhone, iCloud, macOS Contacts, Android, Google Contacts and Outlook all import it, and it is what most phones export themselves. Version 4.0 is the newer standard and works in current apps, but some older Android phones and desktop programs still read it only partly.
What does the country code option do?
Numbers saved in local format, such as 064 123 4567 or 07700 900123, only work inside that country. When you enter a code such as 381 or 44, every number that starts with a single 0 is rewritten as +381 64... or +44 7700..., and numbers that start with 00 get a plus instead. Numbers that already start with + are left alone. This also lets WhatsApp and Signal find the contacts.
Are my contacts uploaded to a server?
No. The files are read and converted inside your browser with JavaScript, and the .vcf is created on your device. ToolBox never receives your contact list, which matters for client lists, patient or member registers and personal address books.

Related Tools

Also Available As