Sometimes, when you save a CSV file in Microsoft Excel it will save with the encoding of ANSI. However the data import will only accept files with encoding of UTF-8.

To get around this you can open the CSV file in Notepad, and then when you do a Save As... you can change the Encoding of the file to UTF-8.

Click to view a larger version of this gif.

Take a look here on how to avoid getting this error in future.

Did this answer your question?