Excel and Google Sheets

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 WhatsApp

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.

Click "Send" in Priya's row and WhatsApp opens a chat with 919876543210 and the text "Hi Priya, your fees of ₹4,500 are due on 10 December." typed in.
A: PhoneB: NameC: MessageD: Link (formula)
919876543210PriyaHi {name}, your fees of ₹4,500 are due on 10 December.Send
919812345678Rahul BhaiHi {name}, your order is ready for pickup.Send
918765432109Mehta FamilyNamaste {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.

Fixes for phone numbers: 0, +91, 10 digits and 9.19E+11

What you seeWhy the link failsFix
9876543210 (10 digits)No country code, so WhatsApp cannot find the numberUse "https://wa.me/91"&A2 in the formula, or the messy-numbers formula above
09876543210The leading 0 is a local dialling prefixThe messy-numbers formula keeps only the last 10 digits and adds 91
+91 98765 43210 or 98765-43210wa.me does not accept +, spaces or dashesThe messy-numbers formula removes them (SUBSTITUTE for " ", "-" and "+")
9.19877E+11Only the display: Excel shows a long number in short formThe 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 goneGet 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 countriesThe 91 trick only suits Indian mobilesAdd 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

Frequently asked questions

Excel me WhatsApp link kaise banaye?

Column A me number 91 ke saath (jaise 919876543210), B me naam aur C me message likhiye, jisme naam ki jagah {name} ho. Phir D2 me ye formula paste kijiye: =HYPERLINK("https://wa.me/"&A2&"?text="&ENCODEURL(SUBSTITUTE(C2,"{name}",B2)),"Send") aur neeche tak drag kar dijiye. Mac wale Excel me ENCODEURL nahi chalta (#NAME? aata hai), wahan is page ka bina ENCODEURL wala formula use kijiye. Har link alag se click karke send dabana padta hai; sabko ek saath bhejna ho to Rapid Sender use kar sakte hain.

Why does my WhatsApp link formula show #NAME?

Either the quotes are curly (“ ”) instead of straight ("), or your Excel has no ENCODEURL function. ENCODEURL is only in Excel for Windows (2013 and later); Excel for Mac returns #NAME?, and older or phone versions may too. Retype the quotes, or use the version without ENCODEURL from the table at the top.

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.

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").

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.

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.

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