If you manage customer outreach, sales follow-ups, or event invites, you probably keep your contacts in a spreadsheet. With Rocket Sender, that spreadsheet becomes a direct launch pad for personalized WhatsApp messages — no API keys, no technical setup, and no tedious copy-paste.

Step 1 — Install Rocket Sender

Before anything else, you need the Rocket Sender Chrome extension installed. Head to the Chrome Web Store and click Add to Chrome. The whole process takes under a minute.

Once installed, open WhatsApp Web and scan the QR code as usual. You'll see the Rocket Sender panel appear in the upper-right corner of the page.

Rocket Sender extension on the Chrome Web Store
The Rocket Sender extension listing on the Chrome Web Store.
Rocket Sender panel visible inside WhatsApp Web
The Rocket Sender panel docked to the right inside WhatsApp Web.

Step 2 — Prepare Your Excel Spreadsheet

Open Excel (or Google Sheets) and create a new file. At minimum, you need a column for phone numbers — but the real power comes from adding extra columns like Name, Company, or any other field you want to personalize your message with.

Make sure every phone number includes its country code (e.g. +14155552671). Missing country codes are the most common cause of failed sends.

Sample spreadsheet with phone number, name, and company columns
A sample spreadsheet ready for import — phone, name, and any custom column you need.

Step 3 — Save as CSV

Rocket Sender reads CSV files. In Excel, go to File → Save As and choose CSV (Comma delimited). In Google Sheets, use File → Download → Comma-separated values (.csv).

Saving the spreadsheet as a CSV file
Save your spreadsheet as a .csv file before uploading.

Step 4 — Upload the CSV in Rocket Sender

Back in WhatsApp Web, click the Upload CSV button in the Rocket Sender panel and select the file you just saved. Your contacts will load instantly.

Clicking Upload CSV in the Rocket Sender panel
Click Upload CSV and select the file from your computer.

Next, map the phone number column to the correct field. Rocket Sender will ask you to identify which column holds your phone numbers.

Column mapping screen after importing the CSV
Map your columns so Rocket Sender knows which field is the phone number.

Step 5 — Write Your Personalized Message

In the message box, write your message. To insert a personalized value from your spreadsheet, click Insert Variable and pick the column you want — for example, Name. It gets inserted as {{Name}} and Rocket Sender replaces it with each contact's actual name before sending.

Variable placeholders inserted into the message template
Variables like {{Name}} are replaced per recipient — every message feels hand-written.

Step 6 — Send

When you're satisfied with your message, click Send WhatsApp. Rocket Sender works through your connected WhatsApp account, dispatching each message with a smart delay to protect your account from being flagged.

Sending the campaign from the Rocket Sender panel
Hit Send and watch messages go out live — delivery status updates in real time.
No Microsoft Excel? No problem. Google Sheets works identically — just download your sheet as CSV and follow the same steps above.
Google Sheets download as CSV option
In Google Sheets: File → Download → CSV to get a compatible file.

Video Walkthrough

Wrapping Up

Sending personalized WhatsApp messages from a spreadsheet used to require expensive API integrations. With Rocket Sender, the whole flow — import, personalize, send — takes a few minutes and works directly inside WhatsApp Web. Your contacts get individual messages; you send them at scale.

Ready to try it? Install Rocket Sender for free and run your first campaign today.