CSV to VCF — turn a contact table into a vCard file
Convert a CSV list of contacts to a .vcf file a phone, iCloud or Gmail can import. Works with Google and Outlook exports and with your own columns.
About this conversion
Phones import contacts from a .vcf, but lists are kept in tables. The page reads three kinds of CSV: the one Google Contacts exports, the one Outlook exports, and a list you typed yourself with columns like Name, Phone and Email — column names are recognised in English, Ukrainian, Russian, Spanish, French, German and Polish. Several numbers in one cell, separated by commas, become separate phone fields. The result is one vCard 3.0 file with every person in it.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same contacts, any way out
The file is read once and stays open, so the format is picked at the end: the same list
can leave here as XLSX, CSV for Google Contacts, CSV for Outlook or PDF. Before that you can search it, see which people are saved
twice — the same number written as (555) 201-4477 in one file and
+15552014477 in another counts as one — and fold the duplicates into a single
card without losing any phone, address or note.
Questions
- My CSV uses semicolons, not commas.
- That is how Excel saves CSV in most of Europe. The separator is detected from the first row: comma, semicolon or tab.
- How do I get the .vcf onto an iPhone?
- Mail it to yourself or put it in iCloud Drive and open it on the phone: iOS offers to add all the contacts at once.
- What if my columns are not recognised?
- The first row has to name the columns. A file that starts straight with data, or one with no name, phone or email column, is refused with an explanation rather than turned into empty cards.