Send bulk WhatsApp from Excel with personalised variables

You can send bulk WhatsApp messages from an Excel or CSV file in Fast2SMS and give every customer their own name, order number or amount. Upload the file on the CSV File tab of Bulk WhatsApp, choose the column with mobile numbers, then match each template variable to a column. This guide covers how to prepare the Excel sheet, upload it, fill the variables and fix the common upload errors.

Before you start

  • A connected WhatsApp number and an APPROVED template. Note how many variables it has, for example {{1}} for the name and {{2}} for the order number.
  • An Excel (.xlsx or .xls) or CSV file of 20 MB or less.
  • Wallet balance for the whole list.
  • Customers who opted in to get WhatsApp messages from you.

How to prepare your Excel sheet

Put one customer per row and one piece of information per column. The first row should hold the column names.

mobile name order_no amount
9999999999 Neha DT-1036 3,480
8888888888 Ritesh DT-1045 1,299
7777777777 Meera DT-1050 2,150

Rules that save you trouble:

  • Mobile numbers: 10-digit Indian mobile numbers starting with 6, 7, 8 or 9. Leave out +91, 0, spaces and dashes.
  • The first data row must be a valid number. The panel checks it, and if it is wrong you get “Invalid Mobile Number in <column>”.
  • Format the mobile column as Text in Excel so long numbers do not turn into 9.99E+09.
  • No empty cells in the columns you use for variables. A message with an empty variable can fail or look broken to the customer.
  • To start, click Sample CSV on the upload screen and fill that file.

Steps to send bulk WhatsApp from Excel

  1. Open Bulk WhatsApp and choose the sender

    Click Bulk WhatsApp in the WhatsApp sidebar and pick your number in Select Sender Number. Only Connected numbers are listed.

  2. Click CSV File and upload

    Under Send To, click CSV File, then Click to upload. You can upload .xlsx, .xls or .csv files up to 20 MB (“File size is not more 20MB”).

    Bulk WhatsApp with Send To set to CSV File, a Sample CSV link and an upload box saying File size is not more 20MB
    The CSV File tab with the Sample CSV link and upload box.
  3. Choose the mobile number column

    After the upload, select your mobile column under “Select Column Name which has Mobile Numbers”. If you skip this, you see “Select Column Name which has Mobile Numbers.” as an error.

  4. Select the template

    Leave Message Mode on Template Message, click “Select WhatsApp Template” and pick your approved template. The form shows the template name, its “Template Type” and a phone preview.

  5. Match each variable to a column

    For each variable, such as Variable 1 ({{1}}), choose the column that holds its value: name for {{1}}, order_no for {{2}}, and so on. Every customer then gets their own values. If you leave one out, you see “Please select column for <name> ({{n}}).”

    Bulk WhatsApp form with a marketing template selected, Header (Image) file chooser, Variable 1 and Variable 2 fields and a live phone preview
    Each variable gets a value. With a file, you choose a column for each one.
  6. Add the header file if the template has one

    A template with a media header shows a file box such as Header (Image). This file is the same for everyone in the campaign: JPG or PNG up to 5 MB, MP4 up to 16 MB, or PDF up to 100 MB. A PDF also needs a Document Filename.

  7. Send or schedule, then check the preview

    Click Send, or Schedule for later. The Message Preview & Confirmation window shows Total Numbers, Duplicate Numbers, Valid Numbers, Invalid Number and the total cost. Check that Valid Numbers matches your sheet, then click Confirm & Send.

    Message Preview and Confirmation with total, duplicate, valid and invalid number counts and the total cost
    Compare Valid Numbers with the rows in your file.

What happens to duplicates and wrong numbers

  • A number that appears twice is sent once and charged once. The preview shows it under Duplicate Numbers.
  • Numbers that are not valid 10-digit Indian mobiles are dropped and not charged. They show under Invalid Number.
  • Numbers that are valid but not on WhatsApp will fail after sending and are refunded to your wallet automatically.

List, Address Book or Excel: which one to use?

Option Best for
List A few numbers that all get the same message. Paste them one per line or separated by commas.
Address Book Saved contacts and groups you message again and again.
CSV File (Excel) Large lists, and any campaign where each customer needs their own name, amount or order number.

Common upload errors and fixes

Error Fix
Please upload CSV file. You clicked Send before uploading. Upload the file first.
Maximum File Upload Size 20MB Exceed. Split the sheet into smaller files, or delete unused columns.
Invalid Mobile Number in <column>. The first data row is not a valid 10-digit mobile, or you picked the wrong column. Remove +91, spaces and header text from that row.
Select Column Name which has Mobile Numbers. Pick the mobile column after uploading.
Please select column for <name> ({{n}}). Match every template variable to a column.
No uploaded sheet found. Please upload a sheet first. The upload did not finish. Upload the file again.
Valid Numbers much lower than your rows Numbers stored with +91, 0 or as 9.99E+09. Fix the mobile column format and upload again.

Frequently asked questions

Can I upload an Excel file for bulk WhatsApp?

Yes. Fast2SMS accepts .xlsx, .xls and .csv files up to 20 MB on the CSV File tab of Bulk WhatsApp.

How do I add the customer’s name to each WhatsApp message?

Use a template with a variable such as {{1}} for the name, put names in a column of your sheet, and match Variable 1 to that column after uploading.

Should I include +91 in the numbers?

No. Use plain 10-digit mobile numbers starting with 6, 7, 8 or 9.

Can each customer get a different image or PDF?

Not in Bulk WhatsApp. The header file is one per campaign. To send each customer their own invoice PDF, use the WhatsApp API with a different media URL per number.

How many numbers can I upload at once?

The limit is the 20 MB file size. Your WhatsApp messaging limit decides how many different customers you can reach in 24 hours, so split very large lists across days.

Can I use a Google Sheet?

Download it as .xlsx or .csv from Google Sheets (File > Download) and upload that file.