is there a way to export my backlog to excel?

I have a long backlog that I want to export to excel.  is there a way to do do that? 

3 answers

1 vote
Jack Brickey Community Champion Dec 20, 2017

Sure, just use JQL advanced method to create a filter for the project in question for all unresolved issues not in an active sprint. Then export to CSV. 

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. For more details see GreenHopper 6.2.2 release notes 

With all the respect, but to me CVS is not really Excel, but a collection of data. A comma separated DB dump. The export to Excel feature is gone missing in the latest release, and so do all the Swedish characters and selected columns in the CVS export. It actually produces unreadable results, even after excel function "text to column" has been applied. It also picks random columns to export, so neither options (all columns, selected columns) work properly. Even the previous version did that with Excel, so that bug is still there in our server installation.

 

The value I get from the CVS export right now is none.

The Excel export was not Excel either, it was XML that says "hey, I'm a spreadsheet".

In theory, I understand why Atlassian has replaced Excel with CSV - CSV was the single most demanded form of export for years, and should make a perfectly good replacement for Excel as spreadsheets can read it just as well as the XML.

However, I don't feel the current CSV export is ready to replace the Excel export yet, with some of your reasons being part of why.

There is one thing though - if you're on server, then look for (you may need to create it) jira-config.properties in the home directory, add jira.export.excel.enabled=true to the file and restart.  The old Excel export comes back.  Should work up to Jira 7.5 (I've not tried it in 7.6)

Thanks for the suggested workaround, will give it a try. :-)

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Mar 09, 2018 in Jira Service Desk

E.L. Fridge's take on education, Jira Service Desk, and creative Jira use cases

...word of mouth, so by 2016, we were working with several other entities on campus to implement Jira Service Desk . The Atlassian motto of “for every team” has really come true for us in this case. We...

1,197 views 2 14
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you