nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export Jira Backlog to Excel

Krisna Leo Parista

Hello,

I am a newbie as a scrum master. I exported all my active sprint into excel via filter JQL,

but then I do not know how to export Backlog Jira into excel, can't find in filter JQL.

Could somebody please help me? Thank you so much!

convert backlog to jira.jpg

Cheers,
Krisna

Accepted answers

Jack Brickey

You can create a JQL filter in the Advanced Search that equates to your backlog and export from there. Assuming your backlog consists of a status of “To Do” then it would look like this

project = abc and status = “To Do” and sprint not in opensprints()

All comments

Jack Brickey

You can create a JQL filter in the Advanced Search that equates to your backlog and export from there. Assuming your backlog consists of a status of “To Do” then it would look like this

project = abc and status = “To Do” and sprint not in opensprints()

Krisna Leo Parista

Yup, this is working.. thank you so much Jack

Cheers,
Krisna

Susan Parker_aitv2t

I have the same issue, but I'm not very good with JQL, and this isn't working for me (after I replace 'abc' with my project name, and status = "Open").

With this...

project = "project name" AND status = "Open" AND sprint not in opensprints()

... my results are 19 issues that ARE in sprints (status = open) and not in the backlog (227 issues).

PS:

Also, how would I construct this query if items in the backlog have some statuses other than open, like "pending information" - just use "OR" between status ='s?

Michael P_8weaev

Hi @Susan Parker. The above didn't work for me either. You might try the following, tweaking as necessary:

project = projectName AND status = "To Do" AND resolution = Unresolved AND Sprint is EMPTY and type != Epic

project = projectName AND resolution = Unresolved AND (Sprint not in openSprints() OR Sprint is EMPTY) AND type != Epic ORDER BY Rank ASC

Note the "ORDER BY Rank ASC" which, for me at least, puts the items in the order they are displayed in the backlog. "Sprint = EMPTY" instead of "is" worked for me, but not others. As Jack says below, this query may not fit your unique situation, but it should be a place to start.

Aron Gombas _Midori_

You can use the Better Excel Exporter app to export issue directly from the backlog screen to custom Excel spreadsheets. That way you can save manually crafting JQL queries, although that's also supported because you can export from Issue Navigator as well.

(Disclaimer: I am developer working on this app. It has been available for Server and Data Center for many-many years, and we released the Cloud version literally yesterday!)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

atl-gruland