How-to guide
Bulk WhatsApp sender from Excel: prepare, import, test and send
NLCaller imports your Excel sheet, fills {name} and {city} per row, tests on one number first, then sends from your phone or the API.
Auto WhatsApp rules
- After missed call
- After outgoing call
- On status: Quote sent
- Quiet hours 21:00–09:00
History: sent 10:43 · delivered · read 10:51
How do you send a bulk WhatsApp message from an Excel sheet?
Sending bulk WhatsApp from Excel comes down to a tidy sheet, one column per detail you want to personalise, and a sender that reads those columns. NLCaller, a call management app with a built-in sales CRM, imports Excel, CSV or JSON files directly, drops duplicate numbers, handles country codes, and turns every file into its own list that you can filter or remove later. The message then uses variables such as {name}, {city}, {company} and {interest}, and each is replaced with the value from that person's row. Before the real run, a test send goes to a single number so you see exactly how the text arrives. After that you pick a route: your own phone sends the messages in turn without any API, or the NLCaller server sends them via your WhatsApp Business API provider, who charges for that traffic. Bulk sending belongs to the full NLCaller app, at ₹162 a user each month when paid yearly; prices checked October 2026, GST added on top.
Once the sheet is in, its rows are ordinary leads, so the same people can be called, tagged and followed up in the lead management app. The features behind the send itself are listed on the bulk WhatsApp sender page.
Which steps take you from sheet to sent, and how long?
From a raw spreadsheet to a finished campaign report.
| Step | Where | Time |
|---|---|---|
| Clean the sheet: one row per person, mobile numbers in one column | Excel | 15 to 30 minutes |
| Add columns for name, city, company and interest | Excel | About 10 minutes |
| Save the file and share it to NLCaller from WhatsApp, mail or the browser | Your phone | About 2 minutes |
| Import it and read any skipped rows with their reasons | NLCaller import screen | About 5 minutes |
| Write the message with {name}, {city} and other variables | NLCaller bulk WhatsApp | About 10 minutes |
| Test send to your own number | NLCaller bulk WhatsApp | About a minute |
| Send one by one from your phone, or start a server campaign | NLCaller bulk WhatsApp | Depends on the list |
| Read the report and call those who replied | NLCaller campaign report | About 5 minutes |
Times are rough estimates for a list of a few hundred rows, not measured averages.
How should the Excel sheet be laid out?
A clean sheet saves more time than any setting in the app.
- Mobile number: one number per cell, no spaces or extra text. NLCaller handles country codes and drops repeated numbers during import.
- Name: the way the customer would like to be addressed, because it fills {name} at the start of the message.
- City, company and interest: optional columns that feed {city}, {company} and {interest}. Leave a cell blank rather than typing a dash.
- Email: only if you plan to use {email} in the text.
- Delete rows for anyone who asked not to be messaged before you import, then add them to the never-again list in the app.
- No merged cells, no totals row and no second header halfway down the sheet.
How do you send safely once the list is in?
The import is the easy part. Sending well takes a little patience.
- Test on yourself. Send the draft to your own number and read it on the phone. A missing value shows up immediately.
- Choose the route. For a short list of people who know you, send one by one from your phone. For a longer opted-in list, run a server campaign through your API provider, who bills per message.
- Work in batches. NLCaller sorts contacts into groups of 240, so a long sheet can go out over several days.
- Respect stop requests. Anyone who replies asking you to stop goes on the never-again list and is skipped in every later send.
- Turn replies into calls. Open the report, see who replied, and ring them. To work through many leads in a row, the auto dialer app calls a filtered list one number at a time.
Can NLCaller add Excel contacts to a WhatsApp group?
No. When NLCaller talks about groups of 240, it means the batches it splits your list into for sending, not WhatsApp group chats. Each person receives the message in a one-to-one chat with your number, which is also what most customers prefer.
Questions people ask
How to send a WhatsApp message directly from Excel?
A spreadsheet only holds the list; something has to read it and send. With NLCaller, you share the Excel file into the app, import it as a list, write the message with variables and send it either from the handset or through your API provider.
How can I send 10,000 messages on WhatsApp?
For a list that size, use a server campaign through a WhatsApp Business API provider, in batches, and only to people who opted in. The provider bills per message, and WhatsApp's own policies decide what your number may send.
How to add bulk contacts in WhatsApp group from Excel?
NLCaller does not add people to WhatsApp groups. It sends each person a one-to-one message, and the 240-contact groups you see in the app only pace a send.
Is there a free WhatsApp bulk sender?
NLCaller's bulk sending is in the paid app, with a 3-day free trial of every feature. The free Basic Dialer stops at calling, an automatic WhatsApp after calls and call analytics.
What is the best bulk WhatsApp sender from Excel for a small sales team?
The best choice for a team that also rings everyone on its sheet is NLCaller, because the imported rows become leads you can message, call and follow up from one phone app.
Can I use Google Sheets instead of Excel?
Yes. NLCaller is a lead and calling app that can read a Google Sheet as a lead source on a schedule, and bulk WhatsApp can go straight to a Google Sheet source.
When should you not send from Excel with NLCaller?
The method suits lists of people who know your business. Skip it if:
- Your sheet is a purchased or scraped list. WhatsApp can restrict numbers that message strangers, and NLCaller cannot prevent that.
- You want everything to go out with no phone in hand and no API account. Phone sending needs you on the phone; background campaigns need an API provider, who bills the messages.
- You need the contacts added to a WhatsApp group chat. NLCaller sends one-to-one messages only.
Sample notes from teams sending to lists kept in Excel
“Our dealer list always lived in Excel. Importing it as its own list meant we could remove it cleanly after the campaign.”
Sales coordinator, paint distributor, Surat
“Adding a city column was the small change that made our message sound personal.”
Marketing lead, tour operator, Udaipur
“The skipped rows showed us which numbers were typed wrong in the sheet before anything was sent.”
Admin executive, coaching centre, Ranchi
Related pages
How this page was made: drafted with AI assistance from NLCaller's documented features, Google search research and dated public sources.
Import your sheet and send a test
Ask for the app on WhatsApp, bring your Excel list and run a test campaign; the 3-day trial needs no payment.
Get the app on WhatsApp