When sending a broadcast using an imported Excel file, ensure that the file is formatted correctly. Incorrect formatting can cause the broadcast to fail or messages to be sent to the wrong recipients. Follow the steps below to set up your file correctly.

Note: The examples used in this article are for demonstration purposes only. The variables and columns in your Excel file may vary depending on the template you have selected.

‍

1. Type the phone numbers in the WhatsApp number column, including the country code and without any special characters or spaces. For example, if the country code for the India is +91 and the phone number is 8130521562, the phone number should be formatted as: 918130521562.

Ensure that the phone number column is formatted as Number in Excel. Incorrect formatting may cause the broadcast to fail or messages to be sent to the wrong numbers.

‍

2. If your template contains a media, paste the media URL in the {{1}} column. You can add links for image, video, audio file, or PDF document. Make sure the link is publicly accessible and working correctly.

‍

3. In the variable columns, add the information required by your template. For example, if variable {{2}} is used for the customer's name, you can enter {{customer.name}} to automatically personalize the message. Similarly, if variable {{3}} is used for a button URL, enter the appropriate link in that column.

Important: Avoid adding extra spaces before or after any value in the Excel file, as this may cause the broadcast to fail.

‍

4. Return to the broadcast screen and click the Upload Excel File button to upload the completed file.

‍

5. Click on Next.

‍

6. Here, you can review the imported data. Before sending the broadcast, send a test message to ensure that all variables, media links, and other data have been uploaded correctly.

‍

Keywords: Imported file, Broadcast Imported, Broadcast Xlsx file, Failing Broadcast.

‍

‍