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.