You have a spreadsheet with hundreds or thousands of phone numbers, and you want to message all of them on WhatsApp, without copy-pasting each number and typing each message individually. The workflow is straightforward: export your Excel sheet as CSV, import it into a bulk WhatsApp sender, map your columns, add personalization, and launch. Here's the exact step-by-step process using Wassuply, which supports 50,000+ rows per CSV.
Your Excel or Google Sheets file needs at minimum one column: phone numbers with full international country codes. Here are the formatting rules:
Optional but recommended columns to include:
Example of a properly formatted spreadsheet:
| phone | first_name | company |
|---|---|---|
| 447911123456 | James | Acme Corp |
| 12125551234 | Sarah | TechStart |
| 919876543210 | Priya | WebServices Ltd |
Wassuply imports CSV files. Here's how to export from common spreadsheet tools:
The CSV format is plain text, each row is a line, and commas separate the columns. This is universal and works across every spreadsheet tool.
Open Wassuply and click Import CSV. Select your file. Wassuply reads the header row (first row) to identify columns and shows a preview of the data so you can verify it looks correct before proceeding.
Wassuply supports CSVs with 50,000+ rows, the software itself has no row limit. Practical limits are determined by your sending capacity (accounts × daily cap per account).
After import, Wassuply asks you to map columns, tell the tool which CSV column is the phone number, which is the first name, and so on.
For example, if your CSV has columns: phone, first_name, company, you map:
Any column you map becomes available as a {{variable_name}} in your message templates. Column names become variable names. This is the mechanism for personalization at scale.
In the message composer, write your template using {{variable_name}} anywhere you want CSV data inserted:
Hi {{first_name}}, I noticed {{company}} is growing fast in the ecommerce space. Would a 5-minute call about WhatsApp marketing make sense?
For each recipient, Wassuply replaces {{first_name}} with that row's first_name value and {{company}} with their company name. Every recipient gets a personalized message using their actual data from your spreadsheet.
Best practices for CSV-based personalization:
Before launching, set your campaign parameters:
Click launch. Wassuply begins sending messages through your connected WhatsApp accounts with the specified delays and caps. The dashboard shows:
The entire process, from opening your spreadsheet to the first message sending, takes under 5 minutes for a pre-cleaned CSV. The tool handles everything automated: column mapping, variable insertion, delay management, and multi-account distribution.
50,000+ row support. Personalization variables. Auto-distribution across unlimited accounts. $397 lifetime.
Get Wassuply, $397 LifetimeWassuply will attempt to send to every number. If a number isn't registered on WhatsApp, the message will fail to deliver, Wassuply flags these in the campaign report so you can clean your list. This is why pre-verifying numbers (e.g., checking if they're WhatsApp-active) improves delivery rates.
Yes. Filter your data in Excel or Google Sheets before exporting to CSV. For example, export only rows where "industry = ecommerce" or "country = UK." Wassuply sends to whatever is in the CSV, segmentation happens at the spreadsheet level before export.
Your CSV is processed locally on your computer. Wassuply does not upload your contact data to any cloud server. The file stays on your machine and is used only for the sending session.
Yes. Import a new CSV with additional numbers, and Wassuply adds them to the campaign queue. Existing recipients won't receive duplicate messages, the tool tracks who has already been messaged in the session.