Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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 Team-managed projects

4 steps to get actual statuses on the Jira board.

Jira   is a powerful tool   that helps teams to plan, manage, and report on their work.   We love using Jira, especially for its ability to track issue progress. But how to monitor the...

1,210 views 10 14
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