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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export issue to CSV but chinese show messy code

Ting Rao_1c4m7h

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.

Accepted answers

Ollie Guan

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

QQ截图20210820104921.png

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

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

All comments

Ollie Guan

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

QQ截图20210820104921.png

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

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

Ting Rao_1c4m7h

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server