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?
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:
Open Excel (don’t double-click the CSV file).
Go to Data tab → Get Data → From File → From Text/CSV.
Select your exported CSV file.
In the import dialog, under File Origin, select 65001: Unicode (UTF-8).
Check the data preview to ensure the text looks correct.
Click Load.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.