WhatsApp Link in Excel: the Formula, Tested (with Name in the Message)
To make a WhatsApp link in Excel, put the number (with 91 in front) in column A, the name in B and your message in C with {name} where the name goes, then paste this in D2 and drag it down: =HYPERLINK("https://wa.me/"&A2&"?text="&ENCODEURL(SUBSTITUTE(C2,"{name}",B2)),"Send"). Each row gets a "Send" link that opens WhatsApp with that person's message already typed. We ran these formulas in Excel before writing them down, which is how we found the two errors most copies miss: #NAME? where ENCODEURL is missing (Excel for Mac) and #VALUE! when the link passes 255 characters. Below are the fixes for both, the Google Sheets version, and a formula for messy numbers.
Updated · Free · No install · Works with your own WhatsAppThe WhatsApp link formula for Excel (copy it from here)
Type these with straight quotes ("). Many blogs show the formula with curly quotes (“ ”), which Excel does not accept, so the copied formula fails before it starts. If your regional settings use a semicolon as the list separator (common in Europe), replace each comma between the arguments with ;. In India the comma is right.
| Where | Formula for D2 (then drag down) |
|---|---|
| Excel on Windows (2013, 2016, 2019, 2021, Microsoft 365) and Google Sheets | =HYPERLINK("https://wa.me/"&A2&"?text="&ENCODEURL(SUBSTITUTE(C2,"{name}",B2)),"Send") |
| Any Excel, including Mac, phone apps and older versions (no ENCODEURL) | =HYPERLINK("https://wa.me/"&A2&"?text="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"{name}",B2),"%","%25"),"&","%26"),"#","%23"),"+","%2B")," ","%20"),CHAR(13),""),CHAR(10),"%0A"),"Send") |
| Same message for everyone (no name) | =HYPERLINK("https://wa.me/"&A2&"?text="&ENCODEURL(C2),"Send") |
| Just open the chat (no message) | =HYPERLINK("https://wa.me/"&A2,"Chat") |
| Messy Indian numbers (10 digits, 0, +91, spaces or dashes) | =HYPERLINK("https://wa.me/91"&RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," ",""),"-",""),"+",""),10)&"?text="&ENCODEURL(SUBSTITUTE(C2,"{name}",B2)),"Send") |
Sample sheet layout (Phone, Name, Message)
Row 1 holds the headings and every row below it is one person. The message can be the same text in every row, or different per row. Write {name} (one pair of curly brackets) wherever the name should appear; SUBSTITUTE swaps it for the name in column B.
| A: Phone | B: Name | C: Message | D: Link (formula) |
|---|---|---|---|
| 919876543210 | Priya | Hi {name}, your fees of ₹4,500 are due on 10 December. | Send |
| 919812345678 | Rahul Bhai | Hi {name}, your order is ready for pickup. | Send |
| 918765432109 | Mehta Family | Namaste {name}, you are invited to our son's wedding on 12 December. | Send |
Try it with your own list
Upload an Excel or CSV file, write your message and see exactly how it looks before anything is sent.
What each part of the formula does
https://wa.me/ is WhatsApp's public click-to-chat address. After the slash comes the full number with the country code and no +, spaces or dashes: 919876543210, not +91 98765 43210.
?text= starts the message that is typed in for you. The person still has to press send.
SUBSTITUTE(C2,"{name}",B2) puts the name from column B wherever {name} is written in the message.
ENCODEURL turns spaces, line breaks, &, # and emojis into a form a web link can carry (a space becomes %20, a new line %0A). Without it, the message stops at the first & or #.
HYPERLINK(link,"Send") makes the cell clickable and shows the word Send instead of the long link.
Excel on Mac, or #NAME? error: the version without ENCODEURL
ENCODEURL is an Excel for Windows function (Excel 2013 and later). We tested Microsoft 365 for Mac and it returns #NAME? for ENCODEURL, and Excel 2010 and older do the same. Excel for the web and the Excel phone apps may not have it either. Whenever you see #NAME? with straight quotes, use the second formula in the table above: it does the encoding itself with SUBSTITUTE and CHAR, which every Excel and Google Sheets has.
It replaces the characters that break a link: % with %25 (this must come first), & with %26, # with %23, + with %2B, spaces with %20 and line breaks with %0A. Excel gave exactly this for a two-line test message: https://wa.me/919876543210?text=Hi%20Priya,%0Afees%20%26%20dues%20%235%20due%2010%20Dec.%2050%25%20off%2Bmore.
Hindi, Gujarati or other scripts and emojis are left as they are in this version. Browsers normally convert them when the link opens, but send one test link to yourself before you go through the list.
Long messages: the 255-character #VALUE! limit in Excel
This is the error almost nobody mentions. Excel's HYPERLINK only accepts a link of up to 255 characters. We tested it: 255 works, 256 gives #VALUE!. The wa.me part and the number already use 32 characters, and every encoded space uses 3, so a message of about 25 to 30 words is the most Excel can link. A Hindi message hits the limit much sooner with ENCODEURL, because each Hindi letter becomes 9 characters (for example न becomes %E0%A4%A8).
Check a row with =LEN("https://wa.me/"&A2&"?text="&ENCODEURL(SUBSTITUTE(C2,"{name}",B2))). Under 256 is fine.
Shorten the message, or move the long details into a PDF or photo you send separately.
For a Hindi or Gujarati message, use the version without ENCODEURL: the letters stay as single characters, so the link stays short.
Or make the links in Google Sheets or in our free bulk link generator, which accept much longer links.
WhatsApp link formula in Google Sheets
Google Sheets has ENCODEURL, so the main formula works as it is: =HYPERLINK("https://wa.me/"&A2&"?text="&ENCODEURL(SUBSTITUTE(C2,"{name}",B2)),"Send"). Paste it in D2, then double-click the small square at the corner of the cell to fill it down the whole list.
For a new line inside the message cell, press Ctrl+Enter (Cmd+Enter on a Mac) in Sheets, or Alt+Enter in Excel on Windows. The formula turns it into %0A, and WhatsApp shows it as a new line. On a phone, Google Sheets opens the link straight in the WhatsApp app.
Fixes for phone numbers: 0, +91, 10 digits and 9.19E+11
| What you see | Why the link fails | Fix |
|---|---|---|
| 9876543210 (10 digits) | No country code, so WhatsApp cannot find the number | Use "https://wa.me/91"&A2 in the formula, or the messy-numbers formula above |
| 09876543210 | The leading 0 is a local dialling prefix | The messy-numbers formula keeps only the last 10 digits and adds 91 |
| +91 98765 43210 or 98765-43210 | wa.me does not accept +, spaces or dashes | The messy-numbers formula removes them (SUBSTITUTE for " ", "-" and "+") |
| 9.19877E+11 | Only the display: Excel shows a long number in short form | The formula still uses the full number. To see it, select the column, Format Cells, Number, 0 decimal places |
| 919877000000 (last digits turned to 0) | The sheet was saved as CSV while the numbers showed as E+11, so the real digits are gone | Get the numbers again from the original file. Before saving as CSV, format the column as Number with 0 decimals or as Text |
| Numbers from several countries | The 91 trick only suits Indian mobiles | Add the right code per row first, with our free add-country-code tool |
Hundreds of numbers in different formats? Add +91 or any country code to all of them at once. Add country code
How to create a WhatsApp link in Excel with name, step by step
- 1
Set up three columns
Type Phone, Name and Message in A1, B1 and C1. Put each person in their own row below.
- 2
Write the message with {name}
In C2 type the message, for example "Hi {name}, your appointment is on 5 December at 11 am." Copy it down if everyone gets the same text.
- 3
Paste the formula in D2
Use the main formula on Windows Excel or Google Sheets, and the version without ENCODEURL on a Mac. Press Enter and D2 shows Send.
- 4
Fill it down
Double-click the fill handle (the small square at the bottom-right of D2), or drag it down to the last row.
- 5
Test one link
Click Send in your own row first. WhatsApp (or WhatsApp Web) should open with the name and message filled in.
- 6
Send row by row
Click each Send link and press the send button in WhatsApp. On a computer, a "Continue to chat" page may appear before the chat opens.
The honest catch: you still click every link
A wa.me link only opens a chat with the message typed in. It does not send anything. For 300 rows you open 300 chats and press send 300 times, and on a computer each click opens a new browser tab. For 10 or 20 people that is fine. For a full customer list, fee list or wedding guest list it takes hours.
Two ways to skip the work. If you only need the links (to hand to staff, or to send from different phones), our free bulk WhatsApp link generator makes them from your Excel or CSV file without any formula, with {{name}} filled in, and downloads them as Excel. It runs in your browser, so the file is not uploaded.
If you want the messages sent, Rapid Sender reads the same sheet and sends one personal message to every row from your own WhatsApp, one by one with a pause between them. You write {{name}} (two curly brackets) in the message instead of using formulas, and you can attach a photo or PDF with each person's name printed on it. The first 50 messages are free for every WhatsApp number; after that, credit packs start at ₹149 for 250 messages.
- Fee reminder
Hi {{name}}, a quick reminder that the fees for December are due on 10 December. Please ignore this if already paid. 🙏
- Customers
Hi {{name}}, thank you for shopping with us! Your order is ready for pickup. Reply here if you have any questions.
- Invitation
Namaste {{name}} ji, we warmly invite you and your family to our son's wedding on 12 December. Your blessings mean a lot to us. 🙏
Only need the links? Make them for the whole sheet with no formulas. Bulk link generator
Frequently asked questions
Why does the formula show #VALUE!?
The link is longer than 255 characters, which is the most Excel's HYPERLINK accepts. Shorten the message, use the version without ENCODEURL for Hindi text, or make the links in Google Sheets or the bulk link generator.
How do I add a WhatsApp link to a number in Excel without a message?
Use =HYPERLINK("https://wa.me/"&A2,"Chat"), with the number in A2 written with the country code and no + (919876543210). For 10-digit Indian numbers use =HYPERLINK("https://wa.me/91"&A2,"Chat").
Does the WhatsApp link work in Google Sheets?
Yes. Google Sheets has ENCODEURL, so the main formula works without changes, and it accepts much longer links than Excel's 255 characters. On a phone, tapping the link opens the WhatsApp app.
How do I put a new line in the WhatsApp message?
Press Alt+Enter inside the message cell in Excel on Windows, or Ctrl+Enter in Google Sheets. ENCODEURL (or the SUBSTITUTE for CHAR(10) in the no-ENCODEURL version) turns it into %0A, which WhatsApp shows as a new line.
Can Excel send the WhatsApp messages automatically?
Not with a formula. A formula only builds links; you still click each one and press send. Macros that type into WhatsApp Web break easily. Rapid Sender sends one personal message to every row of your Excel or CSV file from your own WhatsApp, with no formula or macro.
Ready to send your message?
Upload your list, write your message and connect your WhatsApp. It is free and takes a few minutes.
Start sending