Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

export backlog into excel

 

3 answers

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

Like # people like this

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

Like # people like this

Thanks Elisa, your solution worked for me.

worked a treat!

Like Rob van den Belt likes this

Doesn't work for me. The left click with shift doesn't highlight anything

Like # people like this

Hi Rob,

Once clicked for export excel..its going to webpage with message "oops, you've found dead link"

Dear Nitin, "oops, you've found dead link" is usually an Atlassian link that is out of order. I think somewhere you did something else than I described. Please read my edited solution one more time and try again. Good luck!

@ Joe Fitzpatrick; 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.

@NITIN NEGI Hi, Nitin, the same oops with me, have you solved it?

Thank you very much for this answer

As usual, this feature is NOT available in the SaaS version.  Wake up Atlassian!

It's weird guys I can't see any of the options listed in your answers on my Jira account (share, export, import, filter are all not visible ! I've recently created a free account and backlog of stories now I've to migrate to another account my company subscribed to. 

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.

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