Troubleshooting reports with garbled text

When the data has non-English characters (for example, Chinese or Japanese), exported files might have garbled text when opened in Excel or other software. While we are working on to fix the issue, there are some troubleshooting steps you can walk through to try to help fix the problem.

Uploading in Google Sheet

If you have a Google account, Google Sheets can generally safely open reports.

  1. Upload the exported file in Google Drive
  2. Open the file in Google Sheet and check if there is still garbled text

Changing the text encoding

Windows

  1. Open the exported file in Notepad.
  2. Go to the File menu; choose "Save As".
  3. Change the Encoding option from UTF-8 to ANSI and save your file.
  4. Open the saved file and check if there is still garbled text.

MacOS

  1. Open the exported file in TextEdit.
  2. Go to the file menu > Duplicate and Save the file.
  3. Change Text Encoding option from UTF-8 to UTF-16 or locale code.
  4. Open the saved file and check if there is still garbled text.