NewAds Insights — see what each Facebook ad costs and the WhatsApp leads it brings. Free on every plan. See Ads Insights →
Lead Pattern

How to · Broadcasts

How to send bulk WhatsApp messages from Excel

Have your customer list in Excel? Upload it and send every person their own message — their name, invoice number or amount — from your official WhatsApp Business number.

✨ Ask AI about this page:ChatGPTClaudePerplexity

Short answer

Make an .xlsx file with one row per customer (phone number in full international format, plus a column for each value you want to fill in), pick an approved WhatsApp template, upload the file in Lead Pattern Broadcasts, match each column to a template variable, then send now or schedule. One upload takes up to 10,000 rows.

Broadcast from a file (Help Center)

Step by step

How to do it in Lead Pattern

1

Prepare the Excel file

One row per customer. Put the phone number in its own column with the country code (e.g. 919812345678), and add a column for every value — name, invoice number, amount, due date.

2

Choose an approved template

Pick the template you'll send. Its {{variables}} decide which columns you need. No template yet? Copy one from our free template library.

3

Upload and match columns

In Broadcasts, upload the file and match each template variable to the column that fills it — every row becomes its own message.

4

Send or schedule

Send now or pick a date and time. Then watch sent, delivered, read and failed counts in the broadcast report.

Tips for a clean file

  • Phone numbers: full international format, one per cell, no spaces or dashes. Rows with a missing or broken number can't be messaged.
  • Blank cells leave that variable empty for that customer — fill every cell the template needs.
  • More than 10,000 people? Split the list across several files.
  • Want to keep the list? Import the same file into Customers instead and tag it, then broadcast to a saved segment any time.
  • Big lists on a new number: WhatsApp limits how many different people a number can message first in 24 hours (it starts around 250 and grows with good quality). Messaging limits explained →

Questions people ask

Can I send different values to each customer from Excel?+

Yes. Each row fills the template's variables with its own values — for example each dealer's invoice number and outstanding amount.

How many numbers can I upload at once?+

Up to 10,000 recipients per file upload. For a larger audience, split it across files.

Which file format is needed?+

An .xlsx spreadsheet with a header row and one customer per row.

Will customers see the other numbers?+

No. Every customer receives a separate one-to-one message from your business number.

Try it on your own number — free for 14 days.

14-day free trial · No credit card · Free WhatsApp API setup

Ask AI about this page

Get a quick summary of this page from your favourite AI assistant — based only on leadpattern.com. Be one of the first to try it.