Export to csv with cyrillic data causes unicode issue

[AbuSM]

Duplicates

• I have searched the existing issues

Latest version

• I have tested the latest version

Current behavior 😯

When I export to csv my datatable which contains cyrillic data it don't show it correctly

Expected behavior 🤔

Should show all columns with all rows correctly

Steps to reproduce 🕹

Link to live example:

Steps:
1.
2.
3.
4.

Context 🔦

No response

Your environment 🌎

npx @mui/envinfo

  Don't forget to mention which browser you used.
  Output from `npx @mui/envinfo` goes here.

Order ID 💳 (optional)

No response

[cherniavskii]

Hey @AbuSM
I cannot reproduce the issue using this demo: https://codesandbox.io/s/silent-worker-3tezok?file=/demo.tsx
I tried both Apple Numbers and Google Sheets to open the exported csv file, but it seems to work just fine.
Can you reproduce it?

[AbuSM]

Hi @cherniavskii, I've also tried with Google Sheets and its worked, but doesn't in Microsoft Excel. Is there a way how to fix it for this MS Excel?

[cherniavskii]

@AbuSM Can you try setting utf8WithBom option to true?
You can find more info here https://mui.com/x/react-data-grid/export/#file-encoding

[AbuSM]

Thank you for your reply! Yes, I tried with utf8WithBom option but unfortunately it didn't help(

[cherniavskii]

Hey @AbuSM
I can reproduce the issue with Microsoft 365 Excel for web:

But utf8WithBom option seems to fix the issue:

Can you double check with this demo: https://codesandbox.io/s/reverent-goldstine-mvg8qx?file=/demo.tsx:427-438

Thanks!

[cherniavskii]

I started to think about setting this flag to true by default in v6, but then found this #1695 (comment)

[github-actions]

Since the issue is missing key information and has been inactive for 7 days, it has been automatically closed. If you wish to see the issue reopened, please provide the missing information.