Skip to main content

Using PassFort

Unexpected characters in exported report

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

    CSV export_Microsoft

  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).

    Selecting unicode under File Origin in Excel

  6. Click Load.

Excel in Microsoft 365 (Mac):

  1. Open the report data CSV file in Excel.

  2. Click the Data tab.

    CSV export_Data tab

  3. Click From Text. 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. Click Finish.

In this section: