Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-64191

Non-english Characters Exported via CSV not Rendered Correctly in Excel

XMLWordPrintable

      Problem

      When viewing the exported CSV file in Excel, the non-english characters aren't rendered correctly.

      Steps to Replicate

      1. Create an issue with special characters
      2. Go to Issue Navigator and click Export > Current fields
      3. Open the exported CSV in Excel

      Expected Behaviour

      The special characters are displayed properly.

      Actual Behaviour

      Special characters are not correctly rendered. As an example, "phố xưa" is displayed as "phố xÆ°a" when viewed in Excel.

      Workaround

      Open the exported CSV file with Notepad++. Under "Encoding", it should be shown File is UTF-8 without BOM. Converting the file to UTF-8 with BOM will allow the file to be displayed correctly in Excel.
      Related KB: Exported CSV does not display properly in Excel that contains non-English characters

      Note

      Viewing the CSV in text editor works fine.

              Unassigned Unassigned
              acardino Anna Cardino (Inactive)
              Votes:
              96 Vote for this issue
              Watchers:
              87 Start watching this issue

                Created:
                Updated: