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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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.

luc I'm New Here Jul 09, 2020

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

Thank you very much for this answer

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