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 WhatsAppThe three steps at a glance
| Step | What you do | Where |
|---|---|---|
| 1. Excel to VCF | Pick the name and phone columns, add +91 where missing, download one .vcf file | Excel to VCF converter (in your browser, nothing uploaded) |
| 2. Import the contacts | Open the .vcf on your phone, or import it at contacts.google.com and let it sync | Phone Contacts app or Google Contacts |
| 3. Add to the group | Group 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
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
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
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
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
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.
- 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.
- 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).
- 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.
- 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.
- 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
- 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.
- 12
Tap Add members
Below the description, tap Add members (on some versions: Add participants).
- 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.
- 14
Confirm
Tap the green ✓ (or Add) and confirm. Everyone who allows it is added straight away.
- 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.
The easier way: send everyone the group link by name (no saving numbers)
Bulk adding people who did not ask to join is also what gets groups reported. When many members report a group or exit it soon after being added, WhatsApp may restrict the admin's account. Asking people to join is slower by a day, but they join because they want to, and you don't fill your phone with 300 contacts you will never call.
Rapid Sender is a free-to-try browser tool for WhatsApp that sends one private message to each number in your Excel sheet, from your own WhatsApp, without saving the numbers. Copy the group link (Group info → Invite via link → Copy link), paste it into one of the messages below, and {{name}} becomes each person's name, so the invite reads like you wrote it to them. They tap the link and join, or request to join if you turned on Approve new members.
- School parents
Dear {{name}}, we have made a WhatsApp group for Class 5B parents for the 2026-27 session: homework, PTM and holiday updates in one place. Please join here: https://chat.whatsapp.com/XXXXXXXX – Class Teacher
- Society
Hello {{name}}, this is the official group for Green Park Society residents (maintenance, water and meeting notices). Join with this link: https://chat.whatsapp.com/XXXXXXXX Please use the number that is with the society office.
- Wedding guests
Hi {{name}}! 🎉 We have made a group for guests of Rohan & Priya's wedding, for venue, timing and travel updates. Please join: https://chat.whatsapp.com/XXXXXXXX
- Customers
Hi {{name}}, thank you for shopping with Sharma Electronics. Join our customer group for new arrivals and service-camp dates (no daily spam, promise): https://chat.whatsapp.com/XXXXXXXX
- Coaching batch
{{name}}, welcome to the JEE 2027 morning batch! Timetable, test dates and notes will be shared in this group: https://chat.whatsapp.com/XXXXXXXX
- Team / event
Hi {{name}}, for the Sunday cricket tournament we will share fixtures and ground details in this group. Join here: https://chat.whatsapp.com/XXXXXXXX
- Hindi
नमस्ते {{name}} जी, कक्षा 5B के अभिभावकों के लिए WhatsApp ग्रुप बनाया गया है। होमवर्क, PTM और छुट्टियों की सूचना यहीं मिलेगी। कृपया इस लिंक से जुड़ें: https://chat.whatsapp.com/XXXXXXXX
- Gujarati
નમસ્તે {{name}}, અમારી સોસાયટીના સભ્યો માટે WhatsApp ગ્રુપ બનાવ્યું છે. મેન્ટેનન્સ અને મીટિંગની જાણકારી અહીં મળશે. આ લિંકથી જોડાઓ: https://chat.whatsapp.com/XXXXXXXX
- Marathi
नमस्कार {{name}}, आपल्या सोसायटीच्या सदस्यांसाठी WhatsApp ग्रुप तयार केला आहे. मेंटेनन्स व मीटिंगच्या सूचना येथे मिळतील. या लिंकवरून सामील व्हा: https://chat.whatsapp.com/XXXXXXXX
Sending the group link to your whole Excel list with Rapid Sender
Every WhatsApp number gets 50 free messages to try it. After that, one-time credit packs start at ₹149 for 250 messages.
Signed in, you can choose Send later and the invites go out at the time you pick.
Send only to people who know you or expect the group. An invite from a stranger is still spam.
- 16
Copy the group link
Open the group → tap the name → Invite via link → Copy link. Turn on Approve new members in Group permissions if the link could be forwarded beyond your list.
- 17
Link your WhatsApp
Open rapid-sender.com on a computer or phone and link your WhatsApp with the QR code or the pairing code, the same way WhatsApp Web works.
- 18
Upload the same Excel sheet
Choose your .xlsx or .csv (up to 5,000 rows) or paste the numbers. Pick the name and phone columns; +91 is added where it is missing.
- 19
Paste the invite message
Use a message from above, put your real link in place of the XXXXXXXX one, and keep {{name}} so each person is greeted by name.
- 20
Test, then send
Send a test to your own number and tap the link to check it opens the group. Then send. Messages go one by one with a short random pause (7 to 10 seconds by default), and the report fills in as each one is sent.
Which way is right for you?
| Excel → VCF → Add members | Send the group link by name | |
|---|---|---|
| Numbers saved in your phone | Yes, all of them | No |
| People who block group adds | Need a separate invite | Join with the link like everyone else |
| Who decides to join | You add them | They do (fewer exits and reports) |
| Time for 200 people | 15–30 minutes of importing and ticking | A few minutes to set up; then about half an hour of sending in the background |
| Cost | Free | Free for 50 messages, then from ₹149 for 250 |
| Best for | Small groups of people who already know each other | Parents, 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
Can I add numbers to a WhatsApp group without saving them?
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.
Can I import an Excel file into a WhatsApp group on WhatsApp Web?
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.
Why can't I add some people to my group?
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.
How many contacts can I add to a WhatsApp group?
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.
Can I import a CSV file directly into Google Contacts?
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.
Will adding many contacts to a group get my WhatsApp banned?
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