Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,109
Community Members
 
Community Events
165
Community Groups

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

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

Help appreciated. 

Thank you. 

 

 

3 answers

1 accepted

5 votes
Answer accepted

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.

Screenshot 2020-07-04 at 12.12.52 PM.png

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

Like Richard Tovell likes this

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.

 

Epic Hierarchy - CSV Export.png

Like Blake Reeves likes this

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.

jira-issues-selected-fields.pngjira-insight-report.png

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

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.

Thank You :-)

I just tried it. I got an error

image.png

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you