wassenderShort answer: Put one contact per row in Excel with a phone column (country code, formatted as text), open WhatsApp Web in Chrome with a bulk sender extension such as Wassender, import the file, write one message using column names as variables like [name], preview, and send with randomized delays. Message only people who expect to hear from you.
How to send it with Wassender
- Prepare the sheet: one person per row, a Phone column with the full international number, and one column per detail you want in the message (name, order, date, amount).
- Format the phone column as text so Excel keeps leading zeros and plus signs; save as .xlsx, .xls or .csv.
- Install Wassender from the Chrome Web Store and open web.whatsapp.com; link your phone with the QR code.
- Open the Wassender dock (Alt + W) → New campaign → Spreadsheet. Upload the file, choose the phone column and a default country code.
- Write the message. Each column header becomes a variable: Name → [name], Order No → [order_no]. Use [name|there] for empty cells and {Hi|Hello} to vary wording.
- Preview a few recipients, optionally add an image, video or PDF, then start with the default human pacing — or schedule it (Unlimited).
- Track delivered, failed, skipped and replied per recipient, export the report to Excel, and let Autopilot answer common replies.
Sample spreadsheet
| Phone | Name | Order No | Total |
|---|---|---|---|
| +1 415 555 0101 | Alex | 1042 | $58 |
| +44 7700 900500 | Sara | 1043 | £22 |
| +971 50 765 4321 | 1044 | AED 120 |
Hi [name|there], your order #[order_no] for [total] is confirmed. Reply here with any questions.Which methods exist?
1) A Chrome extension on WhatsApp Web (like Wassender): uses your own number, works from a spreadsheet, no API approval, sends one message at a time with human-like delays. Best for small and medium lists of customers who know you.
2) The WhatsApp Business API through a provider: official and scalable, but needs business verification, pre-approved templates and per-conversation fees. Best for very high volume and automated transactional flows.
3) Broadcast lists in the WhatsApp app: free, but recipients must have saved your number, there is no personalization from a sheet, and lists are limited in size.
Why personalization matters
Messages that include the recipient's own details (name, order, appointment) are read, answered and much less likely to be reported than identical blasts. Variables from Excel columns do that automatically.
Common mistakes
Numbers without country code or with Excel's scientific notation (9.71501E+11): format the column as text before typing or pasting numbers.
Headers with odd symbols: keep them short; Wassender turns them into lowercase variables with underscores.
Sending to bought or scraped lists: this is the fastest way to get a number restricted, whatever tool you use.
Safe-sending tips (avoid bans)
- Message only people who gave you their number and expect to hear from you: customers, patients, parents, leads who asked.
- Keep Wassender's randomized delays and rests between batches on; do not shorten them to finish faster.
- On a new or rarely used number, start with a small daily limit (for example a few dozen) and increase slowly over weeks.
- Use sending hours so messages arrive during the day in the recipient's time zone.
- Personalize with real data ([name], order or appointment details) and vary the greeting with {Hi|Hello}; identical text to hundreds of people looks like spam.
- Add one line on how to stop messages (Reply STOP). Wassender adds those numbers to an opt-out list automatically.
- Wassender skips numbers that are not on WhatsApp and pauses automatically after repeated failures — check the list before resuming.
Frequently asked questions
Can I send bulk WhatsApp messages from Excel for free?
Wassender is free to install and every new account gets 1 hour of Unlimited from its first campaign, with no card. After that, a paid plan removes limits; current prices load on the pricing page.
Do I need to save the contacts first?
No. The extension opens each chat by number from your spreadsheet; contacts do not need to be saved in your phone.
Can I send images or PDFs in bulk?
Yes. Attach an image, video or document (such as a PDF) and the personalized text becomes the caption.
Does it work with Google Sheets?
Yes: paste a public Google Sheets link, or download the sheet as .xlsx or .csv and import it.
How many messages can I send per day safely?
There is no official number. New numbers should start small (dozens per day) and grow slowly; established numbers that message real customers can send more. Keep randomized delays and stop if failures or blocks rise.
Does it work on Mac?
Yes. It runs in desktop Chrome (and Chromium browsers like Edge and Brave) on Windows, macOS and Linux. WhatsApp Web must stay open while sending.
Related pages
Last checked: