chinese characters appear garbled when export to CSV

[lwqhp]

Bug description

1,click the download button with the chart,
2,select "export to csv"

Screenshots/recordings

Superset version

master / latest-dev

Python version

3.10

Node version

16

Browser

Chrome

Additional context

superset version: 6.0.0rc3

i have reviewed the following related issues:
fix(csv): manually encode CSV output to support utf-8-sig #1
fix: Download to CSV shows a special Chinese characters #29506

i have applied the following setting:
in superset_config.py
CSV_EXPORT = {'encoding': 'utf-8-sig'}

however,the issue(chinese character garbling) persists. the documentation suggests a solution:downgrading Werkzeug to version 2.3.8. Is this the only available solution?"

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

Superset’s CSV export uses the encoding you set in CSV_EXPORT, so 'utf-8-sig' should work for Chinese characters. However, Excel and some spreadsheet apps sometimes misinterpret UTF-8 files, even with BOM, which leads to garbled text. Before downgrading Werkzeug, try opening the exported CSV in a text editor to check if the Chinese characters are correct—if they look fine there, the issue is with how Excel is reading the file, not Superset’s export logic. Also, make sure you’re opening the file in the Excel desktop app, not a browser or online viewer, as those often mishandle encodings¹².

If the text is garbled in the text editor too, then Superset may not be applying the encoding correctly, but the code paths show it should respect your config³⁴⁵⁶. There’s no evidence that downgrading Werkzeug is the only solution, but there’s also no confirmed alternative fix for this issue in recent Superset versions⁷. If you need a workaround, you can try importing the CSV into Excel using the “Data > From Text/CSV” wizard and manually selecting UTF-8 encoding.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

   

Footnotes

1. CSV export encoding issues and Excel interpretation ↩

2. CSV export encoding and client-side factors ↩

3. CSV_EXPORT config in Superset ↩

4. CsvResponse encoding logic ↩

5. ChartDataRestApi CSV export encoding ↩

6. CSV export command encoding ↩

7. No confirmed alternative fix for encoding issues ↩