Knowledge Hub

Search

Tutorials

FAQs

WhatsApp Strategies

Knowledge Hub
📗

The Excel sheet I’m using to upload contacts has a failure

When there is a data sheet validation failure after uploading the contacts Excel sheet, it is recommended to download the sample file available in Step 4. Once downloaded, simply follow the pre-existing format of the sample sheet and copy over your contacts’ data.

image

The most common error fixes are as follows:

  1. The heading for the contact numbers is case-sensitive. The heading should always be “phone” and not “Phone.”
  2. Headings are also whitespace-sensitive.
  3. If your template has variables, the variables should be listed in consecutive columns with accurate variable headings.
Logo

BusinessOnBot Pvt. Ltd.

InstagramLinkedInYouTubeWhatsApp