It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I export the entire product backlog into a CSV file?

Manolya Yeniocak Jun 09, 2015

I need to export the product backlog from JIRA into a CSV file, what do I have to do?

Appreciate your support, Thanks.

4 answers

4 votes

You can perform a search in JIRA (take the same filter as your board filter / optionally exclude completed issues or issues that are in a current sprint) and export all of the returned values to Excel. There you can convert the values into a CSV file:

https://confluence.atlassian.com/display/JIRA/Exporting+Search+Results+to+Microsoft+Excel

Also you could check this answer here:#https://answers.atlassian.com/questions/84144

Cheers

Manolya Yeniocak Jun 09, 2015

Thanks Christian, although your instructions sound very simple, could you please explain it in simple steps for someone with no experiences and background in JIRA, agile etc. whatsoever? I would really appreciate it, thanks!

Nic Brough [Adaptavist] Community Leader Jun 09, 2015

The first link Christian gave you contains the "simple steps" to get an excel file. Once you have that, open it in a spreadsheet and select "save as" to get the option to save it as CSV.

0 votes
Rob van den Belt Jun 09, 2016

You can use Shift + Left click on the first issue followed by Left click on the last issue in the backlog-screen and than right click to export to Excel or other possibillities. See GreenHopper 6.2.2 release notes for more info. In Excel you save the file as .csv

Jeremy Woska Dec 08, 2016

Rob's suggestion currently generates a 404 page. I'd like the feature to be supported though, it would be very useful.404.pngimage2016-12-8 15:53:53.png

Joanne Astley Apr 05, 2017

This works if you then click 'view in issue list'. From there you can export.

Rob van den Belt Apr 05, 2017

Thanks Jo, that's how it works and what I should heve written in the first place...

Gaurav Singhal Sep 03, 2018

That works and thanks for an easiest solution.

Samarth Narayan I'm New Here Jan 10, 2019

Thanks Jo! Your intervention really helped! :)

This is an old question, but for those that are searching for alternative solutions. If you have the JIRA Command Line Interface (CLI) you can use the getIssueList action with the jql parameter set to your query. It produces a CSV file.

0 votes
Aron Gombas [Midori] Community Leader Sep 09, 2017

With the Better Excel Plugin, you can export any sprint or the backlog (or any set of issues) to custom Excel files, which can then easily saved to CSV.

You can do from Issue Navigator or even directly from the JIRA Software views:

jira-agile-backlog-xls-export

Colm McGrath Dec 03, 2018

Hi Aron,

 

We have the Better Excel Plugin but are getting the following:

image.png

 

Have you come across this before?

 

Thanks,

Colm

Aron Gombas [Midori] Community Leader Dec 04, 2018

@Colm McGrath would you please open a ticket for this via our support desk?

Like Fritz Iversen likes this
Fritz Iversen I'm New Here Apr 01, 2019

How can something like the backlog NOT be easily printed out? Quite a thing when you have over 20 issues and want to discuss priorities etc. I even tried Copy&paste to word but you get a mess with this, too. aaarrggghhh.

Like Jillian Valino likes this

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

791 views 0 12
Read article

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