Home › Blog › Send WhatsApp from CSV

📋 CSV Import

How to send WhatsApp messages to a list from Excel or CSV

By , founder of Wassuply · Published June 12, 2026 · Last updated October 24, 2026 · 7 min read

Export your Excel or Google Sheets list as a CSV with a phone column (country code included) plus name, custom1 and custom2 columns. Import it into a WhatsApp bulk sender such as Wassuply, write one message that uses those columns as merge fields, and send with random gaps. No contacts saved, no API, no copy-pasting.

Quick answer

The steps below use Wassuply, a Windows and Mac app for warming up and running many WhatsApp numbers for cold outreach. The spreadsheet part works the same for any bulk sender.

Step 1: Prepare your spreadsheet

One column is required: the phone number. Three more are optional and become merge fields. Use these headers in the first row:

phonenamecustom1custom2
447700900123PriyaBrightlineLeeds
+1 202 555 0143JamesAcme CorpAustin
61 491 570 156MiaHarbour DentalSydney

Step 2: Export as CSV

Wassuply's campaign import reads .csv files, so save your .xlsx as CSV first. UTF-8 keeps names with accents and non-Latin characters intact.

Step 3: Import the CSV into Wassuply

Start a new campaign and upload the file in the first step (or paste numbers instead). Wassuply drops duplicate numbers and anything too short to be a phone number, and tells you how many rows it removed. Nobody is added to your phone's contacts; if that is what you are after, see how to send WhatsApp messages without saving the number.

Step 4: Write one message that uses your columns

Merge fields use single braces: {name}, {phone}, {custom1} and {custom2}. Add spintax, alternatives in braces separated by pipes, so the wording changes from contact to contact as well:

{Hi|Hey} {name}, {Sam here|it's Sam} from Northwind. Saw {custom1} is growing in {custom2}. {Worth a quick chat|Open to a 5-minute call} this week?

For the first row above, one possible result is: "Hey Priya, it's Sam from Northwind. Saw Brightline is growing in Leeds. Open to a 5-minute call this week?"

Step 5: Choose the numbers that send

Pick one or more connected WhatsApp numbers. The list is split across them, and when one number reaches its daily cap the next one picks up. Each number runs in its own isolated session with its own browser fingerprint and optional proxy, side by side in one app.

Only send from numbers that are ready. A brand-new number should warm up for at least 15 days before its first campaign, and 30 is recommended; Health & Risk gives each number its plan, safe daily limit and first campaign size. The WhatsApp warmer page explains how warm-up works.

Step 6: Keep the safe timing

These are Wassuply's defaults. Why each one matters is covered in how to avoid a WhatsApp ban and WhatsApp sending limits.

Step 7: Launch and watch

The campaign screen lists every contact with its planned wait and estimated send time, and you can pause or stop at any point. With Smart Send on, a number slows down when its live ban-risk score reaches 60 and pauses at 80, and the panic button stops everything. No tool can honestly promise you'll never be banned; Wassuply removes what gets numbers banned.

From spreadsheet to sent, from warmed numbers.

Import your CSV, write one message, let Wassuply pace it. Free download for Windows 10/11 and macOS 12+.

Frequently asked questions

Can I import an Excel .xlsx file directly?

Save it as CSV first. Wassuply's campaign import reads .csv files, which every spreadsheet app can export: in Excel use File, Save As, CSV UTF-8.

What columns does the CSV need?

Only a phone column is required (phone, mobile or number; otherwise the first column is used). Add name, custom1 and custom2 columns to use them as the merge fields {name}, {custom1} and {custom2}.

Do the numbers need a country code?

Yes. Wassuply reads only the digits, so +44 7700 900123 and 447700900123 both work, but 07700 900123 has no country code and would go to the wrong number.

Does Wassuply upload my contact list?

No. Campaigns, contacts and message history stay on your computer. Sign-in, Warm-up Pods and the optional encrypted backup use Wassuply's cloud.

How many messages can I send from my list per day?

There is no universal safe number. Health & Risk gives each number a safe daily limit from its age and history. To send more, add more warmed numbers and split the list across them.

More: the Wassuply WhatsApp bulk sender, and how sending without the API works.

Related
← Send Without Saving Contacts
Related
WhatsApp Bulk Sender →