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.
The most common error fixes are as follows:
- The heading for the contact numbers is case-sensitive. The heading should always be “phone” and not “Phone.”
- Headings are also whitespace-sensitive.
- If your template has variables, the variables should be listed in consecutive columns with accurate variable headings.