CSV Character Encoding Issues

2026-03-10 08:02:13 | HLSS.INFO
The downloaded file is in CSV format, and its encoding is UTF-8. If you open the CSV file using Microsoft Excel, Chinese characters will not display correctly because Excel's default file encoding is ANSI, resulting in garbled characters. If you attempt to open this dataset's CSV file using Excel, we recommend one of the following two methods: Method 1: First, open the CSV file with Notepad or another text editor, then save it as an ANSI-encoded CSV file, and then open it with Excel. Method 2: First, run Excel, create a new blank notebook, then in the top menu, select "Data" -> "Get External Data" -> "From Text File" -> "Select CSV File," select the downloaded CSV file, and in the "Import String Wizard" dialog box, select the original file format 65001:Unicode (UTF-8).
← Back to Home