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.

[Deleted user]

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

[Madhu_RVS]

Hi @[deleted] 

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.

[Angela Frey]

This seems limited to 1000 issues... how do I actually export "all"?

[MobilityStream]

Hi @Angela Frey ,

There are limitations with the native Jira export. If you are open for a marketplace app, you can try Excel Online Integration for Microsoft Office 365. It works for Office 365 as well as for the Excel Desktop version. You simply select your issues and fields/columns to export directly in Jira. Also there is a real-time and a scheduled sync option. There is no limitation on the number of Jira issues that can be exported.

Kind regards,

The Mobility Team

[Madhu_RVS]

Hi @Angela Frey 

Apologies for getting back late on this.

The app allows to fetch upto 5000 issues now.

Thanks

[Angela Frey]

Awesome, thank you!

[Erika De Lara]

Hello,
I got a little issue. When extracting the information, the columns: Original estimate and Time Spent show random numbers such as 28954 instead of 8h. Is this normal?

[Madhu_RVS]

Hi @Erika De Lara 

Welcome to the community !!

Are you using the app, Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

for exporting ?

Thanks

[Ya Ding]

hi @Madhu_RVS , i got this issue when i export appear all  in one line  do you know why ?

thanks 

[Madhu_RVS]

Hi @Ya Ding 

Can you pls drop an email to support@rvsoftwares.in 

We will get back to you to have a look at the issue

Thanks

[Levente Szabo _Midori_ · Accepted solution]

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.

[l.kustrzynski]

I recommend Advanced Export application! This tool enables users to seamlessly export their data to Excel, CSV, and JSON formats with ease. Additionally You can use flexible export scheduler to receive reports by email.

A trial version is available. Try it.