If a file downloaded from a custom SQL query contains garbled characters, re-import the file into Excel with UTF-8 encoding to resolve the issue.
1 Problem description
After you click Download in a custom SQL query, the downloaded file displays garbled characters as follows:
2 Causes
The downloaded file is a .csv file exported directly by ClickHouse without an encoding declaration. When you open the file, Chinese characters appear garbled because the default encoding does not match the file content. To fix this, manually import the file with UTF-8 encoding.
3 Problem solving
-
Create a new blank Excel file
-
Click on "Data-Get External Data-Get From File-Select Downloaded File"
-
Select the UTF-8 encoding format
as follows
load
-
Save New File
该文章对您有帮助吗？