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

[Erika De Lara]

 Hello @Madhu_RVS
This are the tools I've tried:

and this is how the info is exported:

[Steve Sauser]

@Erika De Lara The Estimates and time spent are in seconds.  The UI simply converts the value from seconds into broader timeframes.  Using seconds in the DB cares for the various methods time can be entered in the UI.  

In your original comment "28954 instead of 8h" if you divide 28951/60 you get 482.52 minutes, then divide 482.52/60 you get 8.042 hours.  Rounding in the UI will account for the .042.  

[Erika De Lara]

@Steve Sauser 
TNX for the very valuable answer! 

[satyanarayana kasyap karri]

I am able to export only 1000 issues. how do i export if i have more than 1000 issues?

[Steve Sauser]

@satyanarayana kasyap karri The base design of Jira is the power to have real-time data VS stale data from exports that are typically no longer accurate moments after the export is performed.  

There are various Marketplace Apps which extend the data interactions from within the UI that provide a lot of additional power to interact with the data real-time.  

If you access the Marketplace (Atlassian Marketplace ), select your Product (Jira) and Hosting Type (Cloud or Data Center) with a search term of "BI" you will find many options and information regarding functionality, ratings, count of installs, pricing and more.  

A couple of examples are listed below based upon the "BestSeller" classification and are cloud fortified. 

Power BI Connector for Jira 

Power BI Jira Connector 

Please note, these are examples based upon search terms and data collected by Atlassian.  I don't want to recommend any specific applications developed by our Marketplace partners and only seek to provide information and examples.  

[theCode4_company]

Dear @satyanarayana kasyap karri ,

If you are open to use Marketplace Apps and willing to overcome standard Jira 1000-row limitation we can offer our free solution - Exporter for Jira. Currently, it allows exporting up to 20K issues and is available for everyone, not just up to 10 users. If you need to export more data, you can try the PRO version.

All the best!

theCode4 Team

[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.)

[Yohannes Shenkute]

is there a reason why Atlassian is limiting export to an arbitrary 1000 records?

why do I have to use external tools to export?

This extremely important feature if one is to do trend analysis over the years.   

[Steve Sauser]

@Yohannes Shenkute 

The base design of Jira is the power to have real-time data VS stale data from exports that are typically no longer accurate moments after the export is performed.  

There are various Marketplace Apps which extend the data interactions from within the UI that provide a lot of additional power to interact with the data real-time.  

In efforts to help reduce pricing sprawl by adding features that not all customers desire and which would increase pricing we offer the Atlassian Marketplace for more customized needs.  This allows base pricing to be low while allowing the various customers options to extend functionality.  

If you access the Marketplace (Atlassian Marketplace ), select your Product (Jira) and Hosting Type (Cloud or Data Center) with a search term of "BI" you will find many options and information regarding functionality, ratings, count of installs, pricing and more.  

A couple of examples are listed below based upon the "BestSeller" classification and are cloud fortified. 

Power BI Connector for Jira 

Power BI Jira Connector 

Please note, these are examples based upon search terms and data collected by Atlassian.  I don't want to recommend any specific applications developed by our Marketplace partners and only seek to provide information and examples.  

[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.

[Rajnish Gupta]

A not so simple way is use the query: "Epic Link" = "devops-10296" OR parent in (devops-10300, devops-10469, devops-10460)

[Edoardo Cavallini]

Hi,

do you know why in my menu I do not have the option to export the issue in a CSV?

[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.