How to create Whatsapp link in Excel Sheet

Post By Sagar

To create a link in an Excel spreadsheet that allows users to open WhatsApp and send a pre-written message, you can use the "HYPERLINK" function combined with a WhatsApp URL scheme. Here's how you can do it:

1. Format the WhatsApp URL: The basic format for a WhatsApp URL to send a message is:

   vbnet
   
   https://wa.me/<phone_number>?text=<message>
   

   • <phone_number> should be in international format without any spaces, brackets, or dashes. For example, a US number would be 15551234567.
   • <message> should be URL-encoded. Spaces become %20, and other special characters need encoding too.

2. Create the HYPERLINK formula in Excel: Use the HYPERLINK function to create the clickable link.

Example

Assume you have the phone number in cell A1 and the message in cell B1.

1. In Cell A1: Enter the phone number, e.g., 15551234567.

2. In Cell B1: Enter the message, e.g., Hello, this is a test message.

3. In Cell C1: Use the following formula to create the WhatsApp link:

   excel
   
   =HYPERLINK("https://wa.me/" & A1 & "?text=" & ENCODEURL(B1), "Send WhatsApp Message")
   

   • ENCODEURL is an Excel function that URL-encodes the message text.

Steps:

1. Open Excel.
2. Enter the phone number in cell A1.
3. Enter the