Free tool

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. 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. 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. 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. 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. 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

  1. 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.

  2. 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.

  3. 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

  1. 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.

  2. 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

  1. 11

    Open contacts.google.com

    Sign in with the Google account your phone uses.

  2. 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.

  3. 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

Other columns (city, amount, class) are not put in the contact file. Keep them in your sheet for personalised messages.
In your sheetIn the .vcf (vCard)What the phone shows
Name (or First name)FN and NThe 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 / ContactTEL;TYPE=CELLMobile number with +91 (or your chosen code)
Two numbers in one cell (“98765 43210 / 91234 56780”)Two TEL linesOne contact with both numbers
Email (optional)EMAILEmail address on the contact
No nameFN = your prefix + numberCustomer 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 withAndroid, iPhone, iCloud, Google Contacts, OutlookOld Android phones, keypad and feature phones, old car kits
Hindi / Gujarati namesPlain UTF-8Quoted-printable UTF-8, which old phones need
When to choose itAlmost alwaysOnly 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

My numbers show as 9.19877E+11 in Excel. Will the VCF be right?

If you upload the original .xlsx or .xls, yes – Excel keeps the full number and only shows it short, and the tool reads every digit. If the sheet was saved as CSV, or the numbers were typed in as text after Excel showed them as 9.19877E+11, the last digits are already gone and cannot be recovered; those rows are marked “Excel rounded”. To stop it happening, select the column, choose Format Cells → Text (or Number with 0 decimals) and type the numbers again.

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.

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.

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.

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.

One .vcf with every contact in it. Android, iPhone, iCloud and Google Contacts all import a multi-contact file in one go.

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.

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.

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.

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