You can follow this documentation => https://confluence.atlassian.com/display/JIRA/Exporting+Search+Results+to+Microsoft+Excel
Execute a JQL query like this to return the issues in the project that has no sprint specified yet:
project = MYSUPERPROJECT AND Sprint IS EMPTY
...and then export this to a custom Excel spreadsheet using the Better Excel Plugin.
In the backlog screen you can use Shift + Left click on the first issue , keep Shift pressed, scroll to the last issue in your backlog and click the last issue. Than right-click and choose the option "View in Excel". If you want to export to other formats, choose "View in Issue Navigator" where you can select Export and select all other available formats including Excel.
If your backlog contains any pre-defined sprints, it only works whitin one predefined sprint-section. Selecting the issues with Shifts over all the different predefinend section-parts in your backlog at the same time isn't possible.
Easily the best answer for 2018
If you don't see "export to Excel" just click on Send to Issues Navigator, there you can download in different formats (top right corner).
Thanks Elisa, your solution worked for me.
It looks like you're new here. Sign in or register to get started.
