Exported CSV does not display properly in Excel that contains non-English characters
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When using the export CSV option in Jira and the file contains non English characters, they are not displayed properly in Excel.
Cause
By default Excel opens the CSV file with ANSI encoding. The ability to open the CSV file with UTF-8 encoding and non English characters was introduced in Excel 2016. Please see What's new and improved in Office 2016 for Office 365 for reference.
The following bug is opened for the same issue: JRASERVER-64191 - Getting issue details... STATUS .
Workaround
- If you open the CSV file using the Mac Numbers and Libre Office, it works fine.
- If you want to open the exported CSV file using Excel, here is another workaround:
For Mac:
Use Mac Numbers and Libre Office, or try the workaround below:
- Copy paste the text in Sublime
- Save the content using File > Save with Encoding > UTF - 8 with BOM to a new CSV file.
- Now open the CSV file and the contents show up in the proper manner
For Windows:
Try Libre Office or a different editor and follow the workaround below:
- Open the CSV file using Notepad.
- Click "File > Save As".
- In the dialog window that appears - select "ANSI" from the "Encoding" field. Then click "Save".
- Open this new CSV file using Excel - your non-English characters should be displayed properly.
OR
Import the CSV file into Excel - Import or export text (.txt or .csv) files
