Unexpected characters in exported report

If you open exported report data in Excel and you see unexpected characters (e.g. å, é, æ) in some of the columns, it could be because you're not using UTF-8 encoding.

To open the file with UTF-8 encoding, follow the steps below for your version of Excel.

Excel in Microsoft 365 (Windows):

  1. Open the file or a new workbook in Excel.
  2. Click the Data tab.
  3. Under Get & Transform Data, click From Text/CSV.
  4. Click File > Import and select the report data CSV file. A dialog with a preview of the file is displayed.
  5. Under File Origin, select 65001: Unicode (UTF-8).
  6. Click Load.

Excel in Microsoft 365 (Mac):

  1. Open the report data CSV file in Excel.
  2. Click the Data tab.
  3. Click From Text. The Text Import Wizard dialog is displayed.
  4. For File Origin, select 65001: Unicode (UTF-8).
  5. Click Finish.


How did we do?


Powered by HelpDocs (opens in a new tab)