This article provides a fix for when you receive the error message “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.