Help Center> Cloud Eye> FAQs> General Consulting> What Should I Do If I See Garbled Chinese Characters in an Exported CSV File?
Updated on 2024-01-11 GMT+08:00

What Should I Do If I See Garbled Chinese Characters in an Exported CSV File?

You can export the Cloud Eye monitoring data to a CSV file, but when you open this file with Excel, there may be garbled Chinese characters. This happens when the exported CSV file is encoded in UTF-8, but the Excel is opened in ANSI format. To solve this problem, use either of the following solutions:

  • Use a text editor such as Notepad or use WPS to open the CSV file you exported.
  • Open the CSV file with Excel, but in the following manner:
    1. Create an EXCEL file.
    2. Choose Data > From Text.
    3. Select the exported CSV file and click Import.

      The Text Import Wizard dialog box is displayed.

    4. Select Delimited and click Next.
    5. Deselect Tab, select Comma, and click Next.
    6. Click Finish.
    7. In the Import Data dialog box, click OK.

General Consulting FAQs

more