Exporting a Zira dashboard to a CSV file

[김힘찬]

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?

[Nagabharana S]

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 Data → From File → From 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.