How to Generate WhatsApp Links in Bulk with Excel

Why generate WhatsApp links in bulk?

If you run a marketing campaign, manage a customer service team, or operate an e-commerce store, you often need to contact multiple clients individually. Creating links manually for every customer is slow and prone to errors. By generating these links in Excel or Google Sheets, you can automate the process, save hours, and ensure accurate formatting.

Step-by-step: Generating WhatsApp links in Excel

Step 1: Format your phone numbers

WhatsApp links require numbers to be in the international format, without any spaces, brackets, or plus signs (+). For example, a US number should look like 15551234567, and an Indian number should look like 919876543210.

In Excel, place your clean phone numbers in Column A, starting from cell A2.

Step 2: Enter the basic formula

In cell B2, enter the following formula to construct a simple wa.me link:

="https://wa.me/" & A2

Press enter, and drag the fill handle down to apply the formula to all your rows. This generates a direct click-to-chat link for every number instantly.

Step 3: Add pre-filled messages (Advanced)

To make the customer journey even smoother, you can include a pre-filled text message. In Excel, spaces and special characters in URLs must be URL-encoded (e.g., spaces become %20). Fortunately, Google Sheets and modern Excel versions have built-in functions to handle this.

If you are using Google Sheets, place your message text in Column B (e.g. "Hi, I am interested in your services"), and use the following formula in Column C:

="https://wa.me/" & A2 & "?text=" & ENCODEURL(B2)

In Excel, you can use the ENCODEURL function similarly to automatically replace spaces with %20, ensuring the link remains valid and scannable.

Best practices for bulk link generation

• Verify Country Codes: Double-check that every number has a valid country prefix. A link without a country code will fail to open a chat.
• Avoid Special Characters: Ensure the phone number column does not contain parentheses or dashes. Use Excel's Find & Replace (Ctrl+H) to strip them out.
• Hyperlink the Cells: To make the generated links clickable directly from Excel, wrap the formula in the HYPERLINK function: =HYPERLINK("https://wa.me/" & A2, "Chat on WhatsApp").

Testing your bulk links

Before launching a broadcast or sending links to your sales agents, copy a random sample of 5 links and paste them into your browser. If they open the correct WhatsApp chat window with the expected pre-filled text, your sheet is set up correctly.