Almost every bulk WhatsApp campaign starts life as a spreadsheet: a column of numbers, a column of names, and something somebody wants to tell all of them. The question is only what happens between the sheet and the send. Here is the version that personalises every row and keeps the number.
What “WhatsApp blaster from Excel” means
Two very different things:
- Excel as the engine: a VBA macro or add-in that opens WhatsApp Web and sends row by row from your own account. Same mechanism as every desktop blaster, same ban.
- Excel as the data source: the sheet is uploaded, or a Google Sheet is connected, and an official platform sends through Meta’s API with approved templates. The spreadsheet does what spreadsheets are good at; the sending is done where it is allowed.
Preparing the sheet
Mapping columns to the message
The template is approved once with placeholders: Hi {{1}}, your order {{2}} of ₹{{3}} ships {{4}}. On upload you point {{1}} at the name column, {{2}} at order number, and so on. Every row fills its own message. A per-customer link, say a payment link or a catalogue page, is just another column.
Sheet columns → template
Columns as segments
This is where the sheet earns its keep. Any column can be a tag, and a segment is a filter on tags. “City = Pune AND language = Marathi AND last_purchase within 90 days” is a segment, built in the dashboard, no new sheet required. Language tags also decide which approved template each contact gets, so one upload can drive a Hindi send and an English send.
Or skip the export: connect Google Sheets
If the team already lives in a shared sheet, connect it instead of uploading. New rows become new contacts, edited cells update the record, and a “send” column can even trigger a template. The full walkthrough is in sending WhatsApp from Google Sheets.
Why not a macro
- It sends from your consumer account, capped at 256-contact broadcasts and watched for automation.
- Your phone must stay online and WhatsApp Web open on that PC.
- No delivered or read data comes back; the sheet never learns what happened.
- No templates, so no buttons, no approved media headers, no verified business name on the recipient’s screen.
- The ban lands on the number, not on the macro.
What comes back to the sheet
On the official platform, every row produces events: delivered, read, replied, clicked. They show in the report per contact, export back to CSV, or post to a Google Sheet or CRM through webhooks. The next campaign’s segment can be “read but did not reply”, which is a thing a macro can never tell you.
What it costs
- Platform: ₹7,999 a year in India, $200 elsewhere, unlimited contacts and users; Excel and Google Sheets import included.
- Meta’s per-message charge: per marketing message, by country, passed through at cost. Service replies inside the 24-hour window are free today and become billable from 1 October 2026 (details).
Next step
Bring the sheet to the free trial; the first real campaign is set up from it on the call. The Bulk WhatsApp Sender Software page has the full feature list, and images and buttons in bulk templates covers what to put in the message once the data is mapped.