Skip to main content

CSV files not displayed correctly in Microsoft Excel

Alex Bitca avatar
Written by Alex Bitca
Updated over 4 years ago

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.

Did this answer your question?