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.
For CBH system data that can be exported as CSV files, see How Do I Back Up CBH System Data?
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.
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.