Export issue to CSV but chinese show messy code

[Ting Rao]

When I use below JIRA software to export issue to CSV.

• Atlassian Jira Project Management Software (v8.16.0#816000-sha1:a455b91) 

Can't export chinese data correctly, showing messy code. Wondering how to deal with it.

[Ollie Guan · Accepted solution]

Hi @Ting Rao ,

You need to transcode the file, please refer to the following steps

1. Open CSV with Notepad

2. Save as a new attachment, change UTF-8 to ANSI 

3. Open the new attachment with Excel

BTW, you're one step closer to meeting fellow Atlassian users at your local event in China!

https://ace.atlassian.com/shanghai/

[Ting Rao]

thanks for your reply~

[frank_ho]

@Ollie GuanStill not work according to this approach, I'm in Atlassian Jira Project Management Software (v8.13.6#813006-sha1:c80b532)

[小明哥]

Change “UTF-8” to “UTF-8 with BOM”.

[Gopikashree S]

Hi @Ting Rao ,

This is a known bug, as referenced in Jira ticket JRASERVER-64191.

Please refer to this KB article for a detailed workaround: Exported CSV does not display properly in Excel that contains non-English characters | Jira | Atlassian Documentation