Why Am I Seeing Garbled Characters When I Open a System Data File?

Symptom

When you export the CBH system data as a CSV file and open the file with Excel, the data in the file is displayed as garbled characters.

Possible Cause

The CSV file exported from the CBH system uses the UTF-8 encoding format. However, when the file is opened in Excel, the ANSI encoding format is used. As a result, data cannot be identified and garbled characters are displayed.

Solutions

Use a text editor, such as Notepad, to open the CSV file and save it as an ANSI file.

After the file is saved successfully, use Excel to open the file again. The file information will be displayed properly.