Skip to content
Back to blog

How to Send Bulk WhatsApp Messages From Excel With Wassender

A step-by-step guide to sending personalised WhatsApp messages to a list in Excel using the Wassender Chrome extension, with a sample sheet and message.

How to Send Bulk WhatsApp Messages From Excel With Wassender

This guide shows how to send a personalised WhatsApp message to everyone in an Excel sheet using Wassender, a Chrome extension from our team that works inside WhatsApp Web. You need a computer with Chrome, your phone with WhatsApp, and a list of people who agreed to hear from you.

Before you start

  • Permission. Send only to customers and contacts who expect your messages.
  • A warm number. Use a WhatsApp number that already has normal conversations. A brand-new number sending to strangers is the fastest way to get restricted.
  • A clean list. Remove duplicates and anyone who asked you to stop.

Step 1: Prepare the Excel sheet

Put one person on each row. The first row holds the column names, and every column becomes a variable you can use inside the message. You need a phone column; the others are optional.

phonenameorderday
966501234567Sara#4821Thursday
971501234567Omar#4822Friday
201001234567Mona#4823Saturday

Write numbers in international format with the country code and no spaces. If some numbers are written without a country code, Wassender can add a default one for you. Save the file as .xlsx, .xls or .csv.

Step 2: Install Wassender and open WhatsApp Web

  1. Install the extension from the Wassender website.
  2. Open web.whatsapp.com in Chrome and link your phone if it is not linked already.
  3. The Wassender dock appears at the side of WhatsApp Web. Create a free account when asked; the trial of the Unlimited plan needs no card.

Step 3: Add your recipients

Open New campaign. Under Who gets it choose Spreadsheet and upload your file, then confirm which column is the phone column.

For a short list you can choose Paste instead and type one person per line, for example 966501234567, Sara.

Step 4: Write the message

Type the message once and put column names in square brackets where the personal details go. You can also tap a column name to insert it.

Hi [name], your order [order] is ready and will be delivered on [day]. Reply here if you would like to change the time.

Sara receives her name, order number and day; Omar receives his. Two more options help a long list read naturally:

  • Rotating words. {Hi|Hello|Good morning} picks one option for each person.
  • A fallback for missing data. [name|there] writes "there" when the name cell is empty.

You can also attach an image or a PDF, such as an invoice or a menu.

Step 5: Test, then send

  1. Use Test on my number and read the message on your phone.
  2. Check the preview to see how the message looks with real data.
  3. Press Send. Wassender sends one message at a time and pauses between messages, so keep Chrome open until it finishes.

If you prefer, schedule the campaign for a time when customers usually read messages.

Step 6: Read the report and follow up

When the campaign ends, the report shows who received the message, who replied and which numbers failed, for example numbers that are not on WhatsApp. A few days later you can send a short follow-up to the people who did not reply.

How many messages should you send?

There is no official safe number. A sensible approach is to start with a few dozen messages a day on a number that is new to campaigns and increase gradually over a couple of weeks. Slow down if people stop replying or start blocking you. Wassender's safe sending guide gives pacing suggestions.

Common problems

  • The sheet has no rows. Put the column names in row 1 and your customers below them.
  • Numbers come back as not on WhatsApp. Check the country code and the phone column. Excel may also have turned long numbers into scientific notation; format the column as text and re-enter them.
  • A variable has no data. The text in brackets must match the column name, or add a fallback such as [name|friend].
  • Sending stopped. Check that the computer did not sleep and that WhatsApp Web is still connected to your phone.

When to use the official API instead

Excel plus an extension works well for hundreds of personal messages. If you need thousands of messages, automatic sending from your store or CRM, or several agents on one number, use the official WhatsApp Business API. Our comparison of a WhatsApp Web extension and the official API helps you decide.

Frequently asked questions

Do I need to save the numbers in my phone first?

No. Wassender sends to numbers straight from the sheet.

Can I send a different image to each person?

Yes. Add a column with an image link or file name for each person; Wassender's guide on sending a different image to each contact shows how.

Does it work with Google Sheets?

Download the sheet as .xlsx or .csv and upload that file.

Will recipients see that it was sent to many people?

No. Each person receives a normal one-to-one chat from your number.

Next step

Prepare a sheet with ten customers who know you, run the steps above and read the report. To see everything the extension includes and what it costs, read our Wassender review.