Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting a Zira dashboard to a CSV file

김힘찬
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 15, 2025

When I export to a CSV file from the Zira dashboard and download the file, all the letters come out broken in EXCEL. How can I get a proper CVS file?

1 answer

0 votes
Nagabharana S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 16, 2025

Hello @김힘찬 ,

The issue you’re experiencing with broken letters in Excel after exporting a CSV from Jira is usually related to character encoding. Most likely, the CSV file is saved with UTF-8 encoding, but Excel is not detecting it properly, so special characters appear garbled.

Here’s how you can fix it:

Method 1: Import CSV into Excel with UTF-8 encoding

  1. Open Excel (don’t double-click the CSV file).

  2. Go to Data tab → Get DataFrom FileFrom Text/CSV.

  3. Select your exported CSV file.

  4. In the import dialog, under File Origin, select 65001: Unicode (UTF-8).

  5. Check the data preview to ensure the text looks correct.

  6. Click Load.

Method 2: Save the CSV file with BOM (Byte Order Mark)

If you can, open the CSV in a text editor like Notepad++ and save it with encoding UTF-8 with BOM:

  • Open CSV in Notepad++.

  • Go to Encoding menu → select Encode in UTF-8-BOM.

  • Save the file.

  • Then open it in Excel.

Method 3: Change regional settings in Excel (Windows)

  • Sometimes changing the default CSV encoding in Windows regional settings helps.

  • Go to Control Panel → Region → Administrative → Change system locale → Choose a locale that uses UTF-8.

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events