How do I export all issues to excel or CSV with Jira project?

[gina]

I searched here for the answer.. and it is not appearing. 

Help appreciated. 

Thank you. 

[Deepanshu Natani · Accepted solution]

Hi @gina 

In order to export Jira issues in form of a CSV/ Excel file, just search for the relevant issues using filters/ JQL and then use the "Export" button to get access to all the export options.

Next select the option "Export Excel CSV" to export the issues.

Check below screenshot for more details.

[Xenia Chilkowich]

This approach is very cumbersome because it doesn't organize issues by Epic or Story :(

[Madhu_RVS_Support]

Hi @Xenia Chilkowich 

If you would be interested in a third party app to get this data, you can try out our plugin

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

You can export the Epics to CSV along with complete hierarchy of the Epic, and roll up time & story points progress at each level.

[Levente Szabo _Midori_]

One other, more professional approach for exporting Jira Cloud issues to Excel is Better Excel Exporter for Jira Cloud!

You not only can export all your Jira Cloud issues but use pre-built templates to create insightful Excel reports with pivot tables and charts. Read more on how to export Jira Cloud backlog to Excel in this blog.

You can also browse more export samples here.

(Please note that Better Excel Exporter Cloud is a paid and supported app and I'm part of the team developing it.)

[Elijah Stownton]

In case you need to automate this process, I'd like to advise you Skyvia. This cloud-based app allows us to schedule export Jira data to CSV: https://skyvia.com/data-integration/jira-csv-file-import-and-export

Btw, free version is available, so feel free to try it.

[Mia Grandin]

Thank You :-)

[Chuyen HUYNH]

I just tried it. I got an error

[Carlos Vidal]

Error in site

[Dennis Williams]

My experience is this only works a fraction of the time when exporting to Excel. And when it does work it is very slow. Exporting to Google Sheets works much better.