Resolving UTF-8 errors for CSV file uploads
This article provides a fix for when you receive the error message 鈥淐SV files must use UTF-8 encoding.鈥 This error message means that the file you鈥檙e trying to upload contains illegal characters, or characters that aren鈥檛 allowed. While UTF-8 encoding allows for , some aren鈥檛 compatible with Magento BI.
To fix the problem, you鈥檒l 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 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 > 鲍罢贵-8*鈥 . This will save the CSV file with UTF-8 encoding.
- Upload the data (in our user guide) to a new table in Magento BI.
recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a