Contact imports usually fail quietly. The file loads, the phone says it added 400 contacts, and then you find names full of strange symbols or numbers turned into 4.477E+11.
Almost every case traces back to one of seven causes. Here they are, with the fix for each.
Cause: a character encoding mismatch. Excel's plain CSV option saves in a local encoding, and the phone reads it as UTF-8, or the other way round.
Fix: save the spreadsheet as CSV UTF-8 (Comma delimited) in Excel, then convert to vCard 3.0 or 4.0. vCard 4.0 is UTF-8 by default. CSV to VCF Converter keeps UTF-8 characters through the conversion.
Cause: Excel treats long numbers as numbers. It drops leading zeros, removes the +, and shows scientific notation like 4.477E+11. Once saved, the digits are gone.
Fix: select the phone columns, choose Format Cells > Text, then re-paste the numbers from the original source. Store them in international format (+44 7700 900123) so they dial correctly from any country.
Cause: nothing is wrong. Many previewers, including the Windows Contacts preview and some email apps, show only the first card in a multi-contact VCF.
Fix: import the file into the phone, iCloud or Google Contacts and all contacts appear. To check the count first, open the VCF in Notepad and search for BEGIN:VCARD.
Cause: the CSV headers didn't match what the converter or Google expected, so columns were mapped wrongly or dropped.
Fix: rename headers to standard ones (First Name, Last Name, Mobile Phone, E-mail Address), or map custom columns by hand in the converter's mapping screen before exporting.
Cause: rows with no name, an unclosed quote mark, or a line break inside a cell (common in address fields) break the CSV structure.
Fix: sort by name in Excel and fill or delete blank rows. Use Find and Replace to remove line breaks inside cells (search for Ctrl+J). Then save and convert again.
Cause: the file was imported twice, or into two accounts that both sync to the phone.
Fix: on iPhone, tap Duplicates Found in Contacts to merge. In Google Contacts, use Merge & fix. Before re-importing, delete the earlier import.
Cause: older devices often only read vCard 2.1, and some need one contact per file.
Fix: convert again with vCard 2.1, and choose separate VCF files if the device asks for them.
| Version | Works with |
|---|---|
| 2.1 | Older phones, car kits, some desk phone systems |
| 3.0 | iPhone, iCloud, Android, Google, Outlook |
| 4.0 | Modern systems, best for international characters |
Save as CSV UTF-8, keep phone numbers as text, use standard headers, and pick vCard 3.0 unless a device needs something else. That prevents nearly every import problem. Starting from scratch? Read how to convert CSV to VCF.
The CSV wasn't saved as UTF-8. Save it as CSV UTF-8 in Excel and convert again.
Format the phone columns as Text before entering or pasting numbers.
No. Previewers often show only the first card. Import the file and all contacts appear.
vCard 3.0 works with iPhone, Android, Google and Outlook.
Yes, as long as you delete the earlier import from the phone or account before importing the new file.
