Report CSV Not Displaying Text Correctly

book

Article ID: 100050696

calendar_today

Updated On:

Description

Error Message

N/A

Cause

The application used (Excel) to view the CSV file is not correctly translating the text.

Data Insight CSV files are generated in Unicode UTF-8

Resolution

Workaround to view Report CSV with correct encoding in Excel:

  1. Open Excel to a blank Workbook
  2. Data - Get & Transform Data - From Text/CSV
  3. Browse and select the report output csv file and then click Import
  4. In the top left of the Transform/Load window, select the drop-down for File Origin and select 65001: Unicode (UTF-8) then click the Load button

Excel will now display the characters in the report correctly

Issue/Introduction

When viewing the report output CSV file, the text is not displayed correctly for some ASCII characters (e.g. umlaut's - ö)
Powered by Wolken Software