Here are a few check points to go through when you get the message "The file could not be imported. Please check the file format and try again."
- Delete the first rows of headings and explanation in the example file. The first rows should be the data. see screenshot below as an example:
- Make sure no cell is empty (except for agent ID)
- Make sure that no message starts with a quotation mark, "
- Ensure that there are no errors, such as # NAME! or otherwise
-
Check your date format is correctly formatted following the ISO 8601 standard
-
An easy way to do this is to edit the file in Google Sheets:
-
Select the entire column of sendTime
-
Go to Format > Numbers > More Formats > Custom number formats, and enter
-
-