Excel to VCF converter – free, with names
Turn an Excel sheet, a CSV file or a pasted list of numbers into one .vcf contact file, free and with no contact limit. Pick the name and number columns, +91 is added where it is missing, and rows without a name get a name you choose, such as “Customer 001”. Your file is read on your device and never uploaded.
e.g. Contact 001
Helps you find them later
vCard
How to convert Excel to VCF
- 1
Upload your sheet or paste numbers
Choose an .xlsx, .xls, .csv or .txt file, or open “Paste numbers” and paste one person per line (a name beside the number is optional). Long sheets with many tabs work too – pick the tab.
- 2
Check the name and number columns
The tool finds them by their heading and by what is in them (“Mobile No”, “Contact”, “नाम”…). Change them if needed. A separate surname column and an email column can be added to each contact.
- 3
Choose the country code and names
India (+91) is chosen. It is added only to numbers without a code; numbers that start with + or 00 keep their own. Rows without a name are saved as your prefix and a number – Customer 001, Customer 002 – and you can add a word after every name, such as “Shaadi” or “Batch A”, to find them later.
- 4
Pick vCard 3.0 or 2.1
Keep 3.0 for Android, iPhone, iCloud and Google Contacts. Choose 2.1 only for an old Android or a keypad phone that shows Hindi or Gujarati names as strange characters.
- 5
Download one .vcf file
Every contact goes into a single file. Duplicates and rows without a full number are skipped, and you can download the skipped rows to fix them. On a phone, “Open in Contacts” hands the file straight to your Contacts app.
Import the VCF file on Android
- 6
Google Contacts app (most Android phones)
Open Contacts → Fix & manage → Import from file → choose your Google account → pick the .vcf from Downloads. Saving to your Google account keeps the contacts if you change phones.
- 7
Samsung Contacts
Open Contacts → ☰ menu → Manage contacts → Import contacts (on older phones: Import or export contacts → Import) → choose Internal storage → pick the file → choose where to save them.
- 8
Or just open the file
Tap the downloaded .vcf in Files or in your browser’s downloads. Android asks which app should open it – choose Contacts and confirm the import.
Import the VCF file on iPhone and iCloud
- 9
On the iPhone itself
Download the .vcf in Safari and tap it in Downloads, or open it from the Files app or a mail you sent yourself. The iPhone lists the contacts – tap “Add All Contacts” at the bottom.
- 10
On iCloud.com
On a computer, sign in at iCloud.com → Contacts → the + button → Import Contact → choose the .vcf. The contacts appear on every iPhone and Mac signed in to that Apple Account.
Import the VCF file into Google Contacts
- 11
Open contacts.google.com
Sign in with the Google account your phone uses.
- 12
Import
Click Import in the left menu → Select file → choose the .vcf → Import. Google puts them under a label called “Imported on” and the date, so you can find or remove them all at once.
- 13
Wait a minute for the phone
Your Android phone syncs them on its own. On an iPhone, add the same Google account in Settings (under Contacts → Accounts) and switch Contacts on.
How your sheet becomes contacts
| In your sheet | In the .vcf (vCard) | What the phone shows |
|---|---|---|
| Name (or First name) | FN and N | The contact’s name, exactly as written – Hindi, Gujarati and other scripts included |
| Surname / Last name (optional) | N (family name) | Added after the name; phones that sort by surname use it |
| Phone / Mobile / Contact | TEL;TYPE=CELL | Mobile number with +91 (or your chosen code) |
| Two numbers in one cell (“98765 43210 / 91234 56780”) | Two TEL lines | One contact with both numbers |
| Email (optional) | Email address on the contact | |
| No name | FN = your prefix + number | Customer 001, Customer 002… |
CSV to VCF and TXT (number list) to VCF
A CSV file converts the same way as Excel: upload it and choose the columns. Names in Hindi, Marathi, Gujarati or Tamil come through correctly when the CSV is saved as “CSV UTF-8” – in Excel that is File → Save As → CSV UTF-8 (Comma delimited). Google Sheets downloads are UTF-8 already.
For a plain list of numbers – copied from a WhatsApp group, an SMS, a notepad or a .txt file – use “Paste numbers” or upload the .txt. Each line becomes a contact. A line like “Ravi Kumar 98765 43210” or “Priya, +91 99887 76655” keeps the name; a line with only a number gets a name like Contact 001. Several numbers on one line with no name become separate contacts.
98765 43210, 09876543210 and +91 98765 43210 are all saved as +919876543210.
A number with 9 or 11 digits and no country code is skipped, because it is not a whole Indian mobile number – fix it in the skipped-rows file.
Untick “Add +91” to keep every number exactly as written (only for lists that are not Indian, or already have their code).
Contact VCF file kaise banaye (Hindi)
Excel ya CSV se VCF file banane ke liye upar apni file chuniye, ya “Paste numbers” mein ek line mein ek number paste kijiye. Naam aur number wala column apne aap chun liya jata hai. +91 jahan nahi hai wahan jud jata hai, aur bina naam wale number “Customer 001” jaise naam se save hote hain. “Download .vcf” dabaiye – sab contacts ek hi file mein.
फ़ोन में डालने के लिए: Contacts ऐप खोलें → Fix & manage (Samsung में Manage contacts) → Import from file → डाउनलोड की हुई .vcf फ़ाइल चुनें। सारे नंबर नाम के साथ एक बार में सेव हो जाएंगे। फ़ाइल कहीं अपलोड नहीं होती, आपके फ़ोन में ही बनती है।
vCard 3.0 or 2.1?
| vCard 3.0 (default) | vCard 2.1 | |
|---|---|---|
| Works with | Android, iPhone, iCloud, Google Contacts, Outlook | Old Android phones, keypad and feature phones, old car kits |
| Hindi / Gujarati names | Plain UTF-8 | Quoted-printable UTF-8, which old phones need |
| When to choose it | Almost always | Only if names look broken after a 3.0 import |
Message the whole list by name – without saving any contact
Many people make a VCF only so they can send everyone a WhatsApp message: a wedding invitation, a fee reminder, a Diwali or New Year wish, a shop offer. You do not need to save 500 numbers for that. Rapid Sender reads the same Excel sheet and sends one personal message to each number from your own WhatsApp, with each person’s name in the text (“Namaste {{name}} ji…”) and even printed on the card or PDF.
Saved contacts also do not help a broadcast list much: WhatsApp delivers a broadcast only to people who have saved your number. Sending from your sheet reaches everyone on it. The first 50 messages are free, with no sign-up. Press “Message them by name – no saving” above to open this list in the sender.
Have the list in Excel already? Send WhatsApp messages from Excel
Frequently asked questions
Is this Excel to VCF converter really free? Is there a limit?
Yes, free, with no sign-up and no 5- or 25-contact trial limit. Sheets of several thousand rows convert in a second; very large ones (50,000+) can be slow on an older phone, so split them if that happens.
Is my contact list uploaded?
No. The file is read and the .vcf is written in your browser, on your device, and nothing is sent to our server. The list only goes further if you choose “Message them by name – no saving” and then send messages from the sender.
Can I convert numbers without names to VCF?
Yes. Paste the numbers or upload a sheet with only a number column. Each one is saved with your prefix and a running number – Customer 001, Guest 002 – so they are easy to find and rename later.
How do I convert Excel to VCF on an Android phone?
Open this page in Chrome on the phone, tap “Choose Excel, CSV or TXT file” and pick the sheet from Files, Drive or WhatsApp downloads. Tap Download .vcf (or Open in Contacts), then import it from Contacts → Fix & manage → Import from file.
Does it make one VCF file or many?
One .vcf with every contact in it. Android, iPhone, iCloud and Google Contacts all import a multi-contact file in one go.
Will the imported contacts show in WhatsApp?
Yes, once they are in your phone’s Contacts. Open WhatsApp → New chat → ⋮ → Refresh if they do not appear straight away. They will see your number only if they have saved it too.
How do I undo an import if something went wrong?
In Google Contacts, open the “Imported on…” label, select all and delete – or use Settings → Undo changes to go back up to 30 days. On iPhone, delete them from iCloud.com, where you can select many at once.
How many contacts can I import at once?
A Google account holds up to 25,000 contacts and iCloud up to 50,000. A single import of a few thousand is fine on both.
Can I turn a VCF file back into Excel?
Yes – use the VCF to Excel converter, which lists every contact from a .vcf with its name and number in a sheet.
Ready to send your message?
Upload your list, write your message and connect your WhatsApp. It is free and takes a few minutes.
Start sending