The CSV files you are exporting from Retently are compliant with the UTF-8 standard.
However, Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain non-English characters.
For example, you may have exported your customer non-English text feedback, and the text is not properly displayed when you've opened the CSV file in Excel.
Follow the steps below in order to resolve this problem:
For Windows computers
Solution 1
Open the CSV in Notepad.
Click “File” and “Save As”.
In the new popup that displays, select “ANSI” from the “Encoding” field.
Click “Save”.
Now, you should be able to open the file in Excel and display the characters correctly.
Solution 2
Open Excel
Click “File” and “New”
Click on the “Data” tab
Click “From Text” and select the CSV file
Select “Delimited”
For “File origin”, select “65001 : Unicode (UTF-8)”
Click “Next”
Select “Comma”
Click “Finish”
Excel will display your CSV file - including non-English characters - properly.
For macOS computers
Use the built-in Numbers app to open the CSV file as it's proven to display the data correctly.