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

Is it possible to export a Next Gen backlog to a spreadsheet?

Is it possible to export a Next Gen backlog to a spreadsheet? I'd want all individual issues to be pulled over into their own line in a sheet.

1 answer

1 accepted

3 votes
Answer accepted
Jack Community Leader Jan 22, 2021

yes. you can used the Advanced search page and build the filter that defines your backlog. for example maybe....

project = mynextgen and status = "to do"

Once you have that you can use the excel/sheets icon to export. Alternatively, once you have the filter you want you can use the Excel/Sheets extension to perform the query directly from Excel/Sheets.

@Jack - another question for you -- I'm trying to export the columns of "summary" and "epic name" but it's not showing the epics the summaries are associated with. Am I missing something?

Jack Community Leader Jan 25, 2021

What is your JQL query?

Thank you for responding, Jack. Admittedly, I don't have any experience with JQL. Is there a resource you would recommend to me so that I can learn more?

Jack Community Leader Feb 17, 2021

no problem at all! Here is a doc to start with - advanced-search-reference-jql-functions . However, I don't think you need to even use the advanced JQL for your purposes. Rather stick w/ the basic search method - perform-a-basic-search . In Basic search you will have drop down options to build your query. Advanced will be needed for, well advanced searches. ;-) But the basic is quite powerful and a better way to get introduced into the advanced. You can build the basic filter and then click switch to advanced and you will see the underlying query and learn how to construct yourself.

Now let's get back to your specific issue here. You mention "I'm trying to export the columns of "summary" and "epic name" but it's not showing the epics the summaries are associated with." So just a bit of terminology here - Epics aren't associated to "Summaries". The summary is associated to issues and Issues can be associated via a parent-child relationship. Now, I think the issue here is that as you are on Next-gen the "Epic Link" field does not exist they do in Classic projects. So when you go to export your stories they don't illustrate the relationship. AFAIK this has not yet changed but admittedly I do not use NG except as a playground at the moment.

Oh man this is awesome. Thank you so much for your help!!!

Jack Community Leader Feb 17, 2021

glad to assist in anyway I can. if you need any JQL assistance at all JLMK!

 

cheers!

Hey @Jack ! I feel like I'm so close to getting this right. I followed some of your previous documents you shared and added the Jira Cloud for Sheets add-on. Now, I'm trying to run a query to pull (at a minimum) all issues, epics, story points, and assignees associated with a specific project. 

I feel like this must be easier than what I'm making it.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

1,250 views 18 23
Read article

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