You have your customers in an Excel sheet and want to send them all a WhatsApp message. The official way isn’t a macro or a browser extension: you import the sheet into a WhatsApp Business API platform and send a Meta-approved template as a campaign, only to the people who agreed to hear from you.
This guide takes you from spreadsheet to sent campaign in five steps, using Wabot as the example, with the file rules, what it costs, and why the shortcuts get numbers banned.
Why not send straight from Excel?
Search for this and you’ll find three shortcuts: Excel macros that open a WhatsApp link for each row and press send, browser extensions or “bulk sender” software that drive WhatsApp Web, and modified WhatsApp apps. All three automate a normal WhatsApp account.
WhatsApp’s Terms of Service name bulk messaging and auto-messaging as impermissible, and WhatsApp detects automated sending from normal accounts quickly. Even if a tool works for a few days, the usual result is a banned number (how to send bulk messages without getting banned).
| Excel macro or extension | API campaign | |
|---|---|---|
| Allowed by WhatsApp | No | Yes, with approved templates |
| Risk to your number | High | Low, if contacts opted in |
| Customers must have saved your number | Depends on the tool | No |
| Delivery report per contact | No | Yes |
On the API, Meta’s Business Messaging Policy sets the condition: every recipient must have given you their number and agreed to hear from you. Excel stays your source list; the platform does the sending.
Step 1: Prepare your Excel sheet
One contact per row, column names in the first row, and only the first sheet in the file is read. These columns cover most campaigns:
| Column | Example | What it’s for |
|---|---|---|
| Phone (required) | +447700900123 | With the country code, starting with + or 00 |
| Name | Priya Shah | Shows in your contact list and inbox |
| Tags | VIP, Mumbai | Labels to pick the audience later; separate several with commas |
| Groups | Newsletter | Lists you send campaigns to |
| Opt-in (for you) | Yes, website form, 3 Oct 2026 | Your record of consent. It isn’t imported: use it to filter the sheet |
- Format the phone column as Text before you type or paste numbers. Excel treats +447700900123 as a number, drops the + and can show it as 4.47701E+11. Wabot reads each cell as Excel displays it, so a number shown that way fails as invalid.
- No country codes? That’s fine if every number is from one country: you pick it as the Default country during import. Numbers starting with + or 00 are always read as international.
- Use headers Wabot recognises, such as Phone, Mobile or WhatsApp, Name, Email, Tags and Groups, and they’re matched automatically. You can map any other header by hand.
- Delete the rows of people who haven’t opted in. Never import a bought or scraped list. Marketing messages need opt-in: how to collect WhatsApp opt-in.
- Save as .xlsx (.xls and .csv work too), smaller than 10 MB, with at most 50,000 contacts per file. Split bigger lists.
Not sure about the layout? The import window has Download sample file: a ready-made CSV with Name, Phone, Email, Date of birth, Gender, Tags and Groups columns.
Step 2: Import the sheet into Wabot
Go to Contact → Contacts and click Import. The import has five steps:
- Upload. Drop your file in, or click to browse: Excel (.xlsx, .xls), CSV or vCard (.vcf), up to 50,000 contacts and 10 MB.
- Map columns. Match each Wabot field to a column in your file. Only Phone number is required; the others are Name, Email, Date of birth, Gender, Instagram, Facebook and LinkedIn URLs, Tags and Groups. Set unneeded columns to Don’t import. Choose a Default country for numbers without a code, or Numbers already have a country code. Wabot remembers your mapping for next time in the same browser.
- Tags & groups. Optionally add tags or groups to every contact in this import, on top of any Tags or Groups columns. A group named after the campaign, such as Winter sale 2026, makes the next step easy.
- Review. See New contacts, Already in Wabot, Repeated in file (rows with the same number are merged into one contact) and Invalid rows, with Download rows to fix for the reasons. For existing contacts, choose Skip them or Update them; empty cells never erase existing data. Then tick I confirm these contacts have agreed to receive WhatsApp messages from my business.
- Import. It runs in the background, so you can close the window. You’re notified when it’s done, with counts of contacts added, updated, skipped and failed.
Every screen is described in the contacts guide, and organising contacts with groups and tags shows how to keep the list tidy.
Step 3: Pick an approved template
The first message to a list must be a template Meta has approved. Choose the category honestly: marketing for offers and news, utility only for something the customer asked for, such as an order or booking (how Meta decides). Add a way to opt out, such as “Reply STOP”: a customer who can’t find it presses Block, and blocks hurt your quality rating. Wording to copy: 30+ WhatsApp template examples.
Our winter sale starts Friday: {{1}} off all jackets until 30 November. Use code {{2}} online or show this message in store. Reply STOP to stop offers.
Variables: in the campaign you type a value for each one, here 20% and WINTER20. Plan your template around details that are the same for the whole list: the import keeps the phone number, name, email, date of birth, gender, social links, tags and groups, so other columns in your sheet, such as an order number, don’t come across.
Step 4: Launch the campaign
- Open Campaigns and choose Quick Campaign (the fastest way) or Add Campaign (full control).
- Pick your approved template and fill in its variables.
- Choose the audience: the group or tag you set during import. Blocked contacts are excluded automatically, and nobody gets the message twice.
- Under Launch Options, choose Send Now or Schedule for Later with a date and time (more on scheduling). In a full campaign you can also set Maximum messages per second and send a Test Campaign to your own number first.
Mind the messaging limit
Meta’s messaging limit caps how many unique people your business can message with templates in a rolling 24 hours: 250 for a new business portfolio, then 2,000, 10,000, 100,000 and unlimited as you send with good quality. Replies to customers who messaged you don’t count. If your sheet is bigger than your limit, split it by tag and send over several days (how to increase your limit).
Step 5: Check the results
- Per-contact report. Campaign analytics show sent, delivered, read and failed for each contact, with the reason in plain words, for example “Contact stopped marketing messages” when someone opted out at Meta’s end.
- Replies land in the shared team inbox, so your team can answer the questions a good campaign brings in.
- Act on the results. Select recipients to send a follow-up or add them to groups, or export the list as a CSV.
- Clean your Excel sheet before the next send: remove failed numbers and anyone who asked to stop.
What it costs
Two costs: Meta’s charge per delivered message, set by the template category and the customer’s country, and your platform’s plan. An illustration with 2,000 opted-in contacts, every message delivered, at Meta’s list rates effective 1 October 2026, before tax:
| Customers in | Marketing, per message | 2,000 marketing messages | 2,000 utility messages |
|---|---|---|---|
| United States | $0.025 | $50.00 | $6.80 |
| United Kingdom | $0.0635 | $127.00 | $44.00 |
| India | $0.0118 (₹0.8631) | $23.60 (₹1,726.20) | $2.80 (₹230.00) |
| Brazil | $0.0625 | $125.00 | $13.60 |
| Mexico | $0.0397 | $79.40 | $17.00 |
| Germany | $0.1365 | $273.00 | $110.00 |
| United Arab Emirates | $0.0576 | $115.20 | $31.40 |
| Indonesia | $0.0411 | $82.20 | $50.00 |
The United States is charged Meta’s North America rate. Utility is cheaper, but only for genuinely transactional messages. More on what a WhatsApp marketing message costs and rates in every country; for India, WhatsApp Business API pricing in India.
How Wabot handles this
- Excel in, campaign out. Import .xlsx, .xls, .csv or .vcf files of up to 50,000 contacts, with column mapping, duplicate merging, a list of rows to fix and an opt-in confirmation.
- Campaigns to the groups or tags you pick: Send Now or Schedule for Later, with a per-contact report (how to send a WhatsApp broadcast).
- Plans: campaigns need a paid plan, from Starter at $9 a month (India: ₹840/month + 18% GST). The Free plan lets you sign up and connect your number.
- No markup on messages. Meta bills you directly, with no markup from us.
Compare plans on our pricing page, or ask us on WhatsApp before you import.
Turn your Excel list into a WhatsApp campaign
Create your free Wabot account and connect your WhatsApp number. No card needed. Import your sheet and send an approved template the official way.
Frequently asked questions
Can I send bulk WhatsApp messages directly from Excel?
Not safely. Macros, extensions and “bulk sender” tools that send from a normal WhatsApp account break WhatsApp’s terms and often end in a banned number. Import the sheet into a WhatsApp Business API platform and send an approved template as a campaign instead.
How many contacts can I import from Excel into Wabot?
Up to 50,000 contacts per import, from an .xlsx, .xls, .csv or .vcf file smaller than 10 MB. Split bigger lists into several files.
Do customers need to save my number to get the message?
No. Unlike a broadcast list in the app, an API campaign reaches opted-in contacts whether or not they saved your number.
What format should phone numbers be in?
International format with the country code, starting with + or 00, for example +44 7700 900123. Format the column as Text in Excel so the + isn’t dropped. If every number is from one country and has no code, pick that country as the Default country when you import.
How much does it cost to send 1,000 WhatsApp messages?
Meta charges per delivered message by category and country. For 1,000 marketing messages that’s $25.00 to the US or ₹863.10 in India at Meta’s list rates effective 1 October 2026, before tax, plus your platform’s plan.
The short version
Don’t send bulk WhatsApp messages from Excel with macros or extensions. Clean the sheet, import it into an API platform, pick an approved template and launch a campaign to the people who opted in.
Start with your most recent, engaged customers, read the per-contact report, and keep your Excel sheet in step with who unsubscribed or failed.
