How-to guide

How to Add Contacts From Excel to a WhatsApp Group

The honest answer first: WhatsApp has no button to import an Excel sheet into a group. You can only add people who are saved in your phone's contacts. So adding contacts from Excel to a WhatsApp group takes three steps: turn the sheet into one .vcf contact file (our free Excel to VCF converter does it in the browser), import that file into your phone or Google Contacts, then add the members from Group info. Anyone whose privacy settings block being added can be sent an invite instead. If you would rather not save hundreds of numbers at all, send everyone the group invite link by name and let them join themselves; that is shown further down.

Updated · Free · No install · Works with your own WhatsApp

The three steps at a glance

Bulk adding contacts from Excel to a WhatsApp group
StepWhat you doWhere
1. Excel to VCFPick the name and phone columns, add +91 where missing, download one .vcf fileExcel to VCF converter (in your browser, nothing uploaded)
2. Import the contactsOpen the .vcf on your phone, or import it at contacts.google.com and let it syncPhone Contacts app or Google Contacts
3. Add to the groupGroup info → Add members → tick the new contacts → ✓WhatsApp on your phone

Step 1 in one minute, free and with no contact limit: Excel to VCF converter

Step 1: Turn your Excel sheet into a VCF file

A .vcf (vCard) file is the contact format every phone understands. One file can hold hundreds of contacts, so you import them all in one go instead of saving numbers one by one.

  1. 1

    Tidy the sheet

    Keep one row per person with a name column and a mobile number column. Delete the total rows, blank rows and merged header cells that many school and society sheets have.

  2. 2

    Upload it to the converter

    Open the Excel to VCF converter and choose your .xlsx, .xls or .csv file, or paste the numbers. It finds the name and number columns from the headings (Name, Mobile No, Contact, नाम). Check them and change them if needed.

  3. 3

    Keep India (+91) as the country code

    +91 is added only to numbers that don't already have a code. Numbers with a 0 in front, spaces, dashes or brackets are cleaned up. Rows with no number, or a number that is too short, are skipped, and you can download those rows to fix them.

  4. 4

    Add a tag after every name

    Add a word such as "5B Parents" or "Shaadi" after each name. Later, in WhatsApp's Add members screen, you can type that word and see only these people, which saves a lot of scrolling.

  5. 5

    Download the .vcf

    All contacts go into a single file. On a phone you can open it straight in your Contacts app.

Try it with your own list

Upload an Excel or CSV file, write your message and see exactly how it looks before anything is sent.

Step 2: Import the contacts on your phone (or Google Contacts)

WhatsApp reads your phone's address book, so the contacts have to be in it. Use whichever route fits your phone.

  1. 6

    Android (Google Contacts app)

    Open Contacts → Fix & manage → Import from file → choose your Google account → pick the .vcf from Downloads. Saving to your Google account keeps them backed up.

  2. 7

    Samsung phones

    Open Contacts → ☰ menu → Manage contacts → Import or export contacts → Import → choose where the file is (usually Internal storage) → pick the .vcf → choose where to save them (pick your Google account, not the SIM).

  3. 8

    iPhone

    Open the .vcf from Files, Mail or WhatsApp and tap Add All Contacts. Or import it at icloud.com/contacts (+ → Import Contact) and it syncs to the iPhone.

  4. 9

    From a computer (Google Contacts)

    Go to contacts.google.com, click Import, choose the .vcf (a .csv works too) and import. Google puts them under a label like "Imported on 19/11" (the date you import). Your Android phone signed into the same Google account gets them within a few minutes.

  5. 10

    Let WhatsApp see them

    Open WhatsApp and start a new chat; the new names should appear. On Android, if they don't, tap ⋮ → Refresh in the contact list. On iPhone, check Settings → WhatsApp → Contacts is turned on.

Step 3: Add the contacts to your WhatsApp group

  1. 11

    Open the group info

    Open the group and tap its name at the top. You need to be an admin, unless the admins let all members add people.

  2. 12

    Tap Add members

    Below the description, tap Add members (on some versions: Add participants).

  3. 13

    Select many people at once

    Type the tag you added in Step 1, such as "5B Parents", in the search box and tick each person. You can tick many in one go. Only contacts who use WhatsApp appear.

  4. 14

    Confirm

    Tap the green ✓ (or Add) and confirm. Everyone who allows it is added straight away.

  5. 15

    Send invites to anyone who could not be added

    If someone's privacy setting doesn't allow you to add them, WhatsApp says so and offers Invite to group. They get a private invite in their chat and can tap to join; the private invite expires after 3 days.

Some people need an invite instead (privacy settings)

Every WhatsApp user chooses who may add them to groups: Settings → Privacy → Groups → Everyone, My contacts, or My contacts except. If a parent or customer has chosen My contacts and has not saved your number, or has put you under My contacts except, you can't add them directly, even as an admin. That is a privacy choice, not a mistake in your sheet.

For these people, send the invite link. In a group of 200 parents it is normal for a part of the list to need an invite, so plan for it rather than adding the same person again and again.

Which way is right for you?

Excel → VCF → Add membersSend the group link by name
Numbers saved in your phoneYes, all of themNo
People who block group addsNeed a separate inviteJoin with the link like everyone else
Who decides to joinYou add themThey do (fewer exits and reports)
Time for 200 people15–30 minutes of importing and tickingA few minutes to set up; then about half an hour of sending in the background
CostFreeFree for 50 messages, then from ₹149 for 250
Best forSmall groups of people who already know each otherParents, customers, residents, guests – lists of strangers to each other

Contacts not showing in WhatsApp? Fixes

  • The number has no +91 or has extra digits: a number saved as 09876543210 or 98765 43210 usually works on an Indian phone, but one saved as 919876543210 without the + can show as "not on WhatsApp". Fix the whole column with the free add country code tool, then make the VCF again.

  • WhatsApp hasn't refreshed yet: on Android, open a new chat → ⋮ → Refresh. Close and reopen WhatsApp if needed.

  • WhatsApp can't read your contacts: Android Settings → Apps → WhatsApp → Permissions → Contacts → Allow. On iPhone: Settings → WhatsApp → Contacts.

  • Imported into the wrong account: if you imported into a Google account that isn't on the phone, or into the SIM, the contacts may not sync. Import again into the Google account the phone uses.

  • Google Contacts hasn't synced: on Android, open Settings → Accounts → Google → Account sync and sync Contacts. It can take a few minutes after a web import.

  • The person is not on WhatsApp, or uses WhatsApp on another number: only numbers with a WhatsApp account appear in Add members.

  • Hindi or Gujarati names look like strange characters on an old phone: make the VCF again as vCard 2.1.

  • Duplicates: if the same number is in the sheet twice, the converter keeps one. Check for people who are already in the group before adding.

Numbers missing +91 or mixed formats? Add country code to phone numbers

Group size and other limits

  • A WhatsApp group can currently have up to 1,024 members, including you. WhatsApp has raised this limit over the years, so check the app if you are close.

  • Only admins can add members, unless the admins allow everyone (Group permissions → Add other members).

  • There is one invite link per group at a time; resetting it makes the old link stop working.

  • WhatsApp does not publish a number for how many people you may add at once. Adding hundreds of people who don't know you in a short time is what tends to get groups reported and accounts restricted, so add people who expect it, or send the link.

  • For more than 1,024 people, or one-way updates, a community (several groups under one announcement group) or a channel fits better than one big group.

After adding: a good first message and clean-up

Post one short welcome in the group saying what it is for and the rules ("updates only, no forwards"). Set Send messages to admins only if it is an announcement group. Give it a clear name, such as "Class 5B Parents 2026-27"; our list of WhatsApp group names has ideas.

If you don't want hundreds of imported contacts on your phone later, delete them in Google Contacts: open the "Imported on…" label, select all and delete. Members stay in the group after you delete their contacts.

Need a name for the group? WhatsApp group names

Frequently asked questions

How do I add contacts from Excel to a WhatsApp group?

WhatsApp can't import Excel directly. Convert the sheet into a .vcf file with an Excel to VCF converter, import the file into your phone or Google Contacts, then open the group → Group info → Add members and tick the new contacts. People whose privacy settings block group adds will need an invite link.

How do I add bulk contacts from Excel to a WhatsApp group at once?

Import all the contacts in one go as a single .vcf file. Then, in Add members, search for a tag you put after every name (like "5B Parents") and tick them one after another before tapping ✓ once. WhatsApp has no one-tap "add all" from a file.

No. Add members only shows saved contacts. Without saving numbers, the way is to send the group invite link to each number, which a tool like Rapid Sender can do from your Excel sheet, with each person's name in the message.

No. WhatsApp Web and the desktop app use the contacts from your phone, and neither can import a sheet. Import the contacts on your phone or Google Contacts first; then you can add members from WhatsApp Web too.

They chose in Settings → Privacy → Groups that only their contacts (My contacts, or My contacts except…) can add them, and you are not one of those. WhatsApp then offers Invite to group, which sends them a private invite that expires after 3 days.

A group can currently hold up to 1,024 members. WhatsApp doesn't publish a limit for one batch, but adding many strangers fast can get the group reported, so add people who expect it.

Yes. At contacts.google.com click Import and choose the CSV or VCF. A VCF usually maps names and numbers more reliably; a CSV needs headings Google recognises, such as Name and Phone.

Adding people is normal, but if many of them report the group or leave right away, WhatsApp may restrict the account. Sending the invite link and letting people join themselves avoids this.

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