Launch a campaign from an Excel sheet
Launch a Campaign (Excel Upload), Excel upload, CSV upload, upload contacts, bulk message from Excel, Agent ChatWhen you finish, your WhatsApp campaign goes out to every phone number in your Excel sheet, right away or at the time you choose.
Use this when your numbers come from outside your store: for example, customers who scanned your QR code, numbers collected at an offline event, or numbers from your point-of-sale machines.
Describe your campaign
Section titled “Describe your campaign”-
Go to Campaigns → New Campaign.
-
Under Describe your campaign, enter a Campaign name. Only you see it, for example “Anniversary Sale”.
-
Under How should the replies be handled, choose what happens when a customer replies:
Option What happens Handle by bot Your bot’s automated responses reply to the customer. Send to agent chat The reply goes to the Support Inbox, and your support team answers. Do nothing The bot doesn’t answer the customer’s first reply. After that, the bot takes over. Handle by flows A campaign flow you built in advance runs. See Types of flows. -
Choose to upload your customer data from an Excel sheet.
Configure your message
Section titled “Configure your message”-
Under Configure your message, pick a template from the dropdown. It lists all your approved templates. The phone preview on the right shows the template content.
-
If the template has a media header (image, video or document), upload the file customers should receive.
-
For each body variable, choose Unique or Common:
- Unique: different for every customer, such as their name. You fill it in a column of your Excel sheet.
- Common: the same for everyone, such as a coupon code. Type the value here, for example
C10.
-
If the template has a website button with a dynamic link, paste the link into the button variable. Always copy the link from your website’s address bar, so customers land on the right page.

Track links and add recipients
Section titled “Track links and add recipients”-
Under Link tracking, add UTM parameters if you want to track link clicks in Google Analytics or another UTM tool.
-
Under Recipients list, click Sample to download the sample sheet. Its columns match the template you picked.

-
Fill the sheet: phone numbers in the
phonecolumn, and one column for each unique variable (see sheet rules below).
-
Save the file as an Excel Workbook (.xlsx).
-
Click Choose File, upload the sheet, then click Validate.
You see a summary of the contacts: total, valid, new and unsubscribed. If validation fails, check the sheet against the rules below.

Test and launch
Section titled “Test and launch”-
Under Test / preview campaign, add your team’s phone numbers with + Phone, then click Test Campaign.
If your template has variables, each test number gets three messages, showing how the first three customers in your sheet will see it. Without variables, you get one message. Check that the variables, media and link are right.
-
If a test number gets no message, don’t launch. Send “Hi” to your WhatsApp bot from that number and test again. If it still fails, contact support.
-
Under Launch Campaign, launch the campaign now or schedule it for a later date and time. You can’t schedule two campaigns for the same time.
Sheet rules
Section titled “Sheet rules”| Rule | Example |
|---|---|
| Keep the column names of the sample sheet exactly as they are. | |
| The phone column heading is lowercase and has no extra spaces. | phone, not Phone |
| Phone numbers start with the country code (91 for India). | 917909999999 |
| Variable columns are named after the variable, in order. | {{1}}, {{2}} |
| There is one column for each unique variable, and no more. | Two unique variables → {{1}} and {{2}} |
If the template has no variables, the sheet has only the phone column. |
|
| Save as an Excel Workbook. | .xlsx |
Media file limits
Section titled “Media file limits”| File | Format | Size |
|---|---|---|
| Image | JPEG or PNG | Under 5 MB |
| Video | MP4 | Under 15 MB (940 × 500 pixels recommended) |
Images taller than a 1.91:1 ratio are cropped, so keep the important part in the centre.
Watch the walkthrough
Section titled “Watch the walkthrough”Related
Section titled “Related”Was this page helpful?
Thanks, this helps us improve this page.
Still stuck? Email support@businessonbot.com