I can only export my Jira issues to Word and XML. How I export them to Excel?

[Anna Limarenko]

I have a Jira project, and I need to export (edit and import them back) my issues to Excel. When I hit "Export" button it only gives my a choice between Print, Word and XML. How do I add option of export to Excel (and import it back)?

Thanks!

[Aron Gombas _Midori_]

Exporting to CSV has several short-comings. As an alternative, you can create native Excel files (XLSX format) with the Better Excel Plugin.

[Mesut Yilmazyildirim]

1-Go to the issues >> Search for Issues

2-Write your JQL such as;

project = <project_name> AND status = backlog

3-On the top right of your screen, click on the "Export" drop down.

You can export via CSV

[Anna Limarenko]

Got it! Managed to find CSV option - thank you!

[Christopher Jaksch]

Hi @Anna Limarenko,

Excel Export is gone since JIRA 7.2 but you can re-enable it.

Please follow the knowledge base here: https://confluence.atlassian.com/jirakb/jira-excel-export-of-issues-no-longer-opens-correctly-838403242.html?_ga=2.180922020.2021722648.1533547195-599540014.1512122069

As a better alternative you could export to CSV and open the CSV with Excel.

Hope that helps.

Best wishes
Chris
STAGIL

[Anna Limarenko]

How do I export to CSV?

[Anna Limarenko]

Oh found it! Thank you

[Christopher Jaksch]

Great job @Anna Limarenko!

:)