How to open CSV reports in languages other than English

Contact Us

Contact Us

[contact-form-7 404 "Not Found"]

How to Open CSV Reports in Languages Other Than English

If your CSV report headers are encoded in a non-English utf-8 character set, their display may be distorted. The following workaround solution uses Power Query, a tool bundled with Office 2016 (or later). For Excel versions 2010 or 2013, install the add-in from here.

Instructions:

3. Select the csv file.
4. Data preview will be indecipherable:

5. Change the encoding to UTF8

The data display will become legible:

6. Click Load  to render all grid headers legible:

The resulting spreadsheet is now fully legible:

Skip to content