Skip to main content

Fix unexpected characters in an exported report (v1)

If you open exported report data in Excel and you see unexpected characters, such as å, é, or æ, 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 for your version of Excel.

Excel in Microsoft 365 (Windows):

  1. Open the file or a new workbook in Excel.

  2. Open the Data tab.

  3. In the Get & Transform Data section, select From Text/CSV.

    Excel From Text/CSV menu option

  4. Select File > Import and select the report data CSV file. A dialog with a preview of the file is displayed.

  5. For File Origin, select 65001: Unicode (UTF-8).

    Selecting unicode under File Origin in Excel

  6. Select Load.

Excel in Microsoft 365 (Mac):

  1. Open the report data CSV file in Excel.

  2. Open the Data tab.

  3. Select Get Data and choose From Text (legacy).

    The Text Import Wizard dialog is displayed.

    Microsoft Excel's Text wizard import for Macbooks

  4. For File Origin, select 65001: Unicode (UTF-8).

  5. Select Finish.

Additional information

In this section: