In the second step, you need to specify how the data will be split, i.e. After choosing the encoding in which Polish characters will be displayed, click 'Next'. If not, use the File Source field and select a different encoding format.ĭepending on the source of the file, you may need to select a different encoding. V preview you can see if the Polish characters in the imported document will be read correctly. Selecting a file will launch the Text Import Wizard. This way you will be able to decide what the encoding of the imported data is before you import the file. To do this, go to the Data tab and select From Text.

Upload the data (in our user guide) to a new table in Magento BI.Select the first cell on the sheet.

This will save the CSV file with UTF-8 encoding.

In Sublime Text, navigate to File > Save with Encoding > UTF-8*.

Click File > Save as and choose the Comma separated values (.csv) format to save the file.

Open your file in Microsoft Excel, Google Docs, Apple Numbers, or your program of choice.

We recommend using Sublime Text to save and encode 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.

To fix the problem, you'll need to change the encoding of the file.

While UTF-8 encoding allows for the majority of characters, some aren't compatible with Magento BI. 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. Resolving UTF-8 errors for CSV file uploads

How to change encoding in excel