You have four hundred contacts in a spreadsheet and no way to get them into a phone. Typing them in is a weekend you will not get back, and most converters want you to upload the file first. This CSV to VCF converter builds the contact file in your browser instead, so the list never leaves your device.
Turning excel contacts to vcard format in four steps
Save your spreadsheet as CSV first. Both Excel and Google Sheets do it from the export menu, and it is the only format that travels reliably.
- Load the file. The first row has to name your columns, or nothing can be matched.
- Check the mapping. We guess from your headers. Fix what is wrong and skip what you do not want.
- Read the preview. Names and emails in the wrong places means a column is mapped wrong.
- Download. One
.vcfholding every contact.
We would rather you check the preview than trust the guess. Header matching works well on tidy exports and less well on a sheet where somebody labelled a column “Contact 2”.
Matching spreadsheet columns to vcard fields
Each column becomes one field on the card. Mapping two columns to Mobile and Phone gives a contact with two numbers.
The one that catches people is a single “Full Name” column. Map it to First name and everything imports, but address books that sort by surname will sort every contact under the first letter of their first name. Splitting the column in the spreadsheet first is worth the two minutes.
Contacts with no name at all cannot become a card. We list those row numbers rather than dropping them quietly, so you can decide whether to go back and fill them in.
Why your phone numbers arrive broken, and how to fix it
Check a number in your spreadsheet before converting. If +44 20 7946 0958 now reads 442079460958, Excel treated it as a number and threw away the plus.
That plus is what makes a number dialable from another country. Losing it turns a working contact into one that fails the moment somebody travels.
The fix belongs in the spreadsheet. Format the column as text before typing or pasting, then re-export. We write the number exactly as it arrives and never reformat it, because guessing at country codes is how the plus gets lost twice.
Bulk create vcards from a spreadsheet without uploading it
Everything happens in this browser tab. The spreadsheet is parsed here and the contact file is assembled here.
This is the part worth caring about. A contact list is not your data alone — it holds names, numbers and addresses for hundreds of other people, none of whom agreed to it being uploaded anywhere.
Confirm it in the network panel of developer tools. We serve the JavaScript, so a compromised page could behave differently, which is true of every in-browser tool including ours. Checking is the only thing that turns a claim into a fact.
Getting the finished file to import a contact list to a phone
Email the .vcf to yourself and open the attachment on the device. That works on both iPhone and Android and needs nothing installed.
Expect the import to be all or nothing. Address books rarely offer to pick which contacts to take, so check the file first with the vcf viewer — it counts the cards and flags anything that will not survive.
Duplicates are the usual complaint afterwards. The steps for importing a vcf file to iPhone cover the merge tools on both platforms, because tidying up after an import is the part nobody warns you about.
Start with a clean spreadsheet
Every problem this CSV to VCF converter can hit starts in the source file: numbers stored as numbers, names in one column, blank rows in the middle. Ten minutes of tidying beats fixing four hundred contacts on a phone.
If your list started as an API export rather than a spreadsheet, the JSON to CSV converter gets you to a mappable sheet first. Need one card rather than a list? The vcard generator builds a single contact properly. Pulling contacts back out to a sheet is the job of the vcf to csv converter, and it is worth understanding which vCard version to choose before you commit a few thousand records to one.
