"CSV files must use UTF-8 encoding." This error message means that the file you're trying to upload contains illegal characters, or characters that aren't allowed. While UTF-8 encoding allows for the majority of characters, some aren't compatible with Magento BI.
To fix the problem, you'll need to change the encoding of the file. Re-saving the file with the proper encoding typically resolves the issue, but be aware that you may lose some information (for example, the illegal characters may be dropped) when doing this.
We recommend using Sublime Text to save and encode the file.
- Open your file in Microsoft Excel, Google Docs, Apple Numbers, or your program of choice.
- Click File > Save as and choose the Comma separated values (.csv) format to save the file.
- Open the CSV file in Sublime Text.
- In Sublime Text, navigate to File > Save with Encoding > UTF-8*. This will save the CSV file with UTF-8 encoding.
- Upload the data to a new table in Magento BI.