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 all epics for a given project with child issues nested beneath each epic

I have Project XYZ, which is composed of Epic A, Epic B, Epic C. Within each epic there are tasks.

I would like to export all epics within the project with each task nested below each epic to a CSV. The ultimate goal is to get a view of the status of the tasks within each epic in spreadsheet form. (I am able to export all epics and stories/tasks, each having a separate line item, but there is nothing connecting a task with a given epic in the spreadsheet and they are not nested.)

2 answers

0 votes
Jack Community Leader Jul 14, 2021

Is this associated with CMP projects? If so you can use the epic link to associate the epic children to the epic. So you may need to use Excel‘s sorting capabilities to build it out the way you want but you should be able to do so.

if this is TMP you can use Parent in a similar manner.

Hi @Danielle Barringer 

f you would be interested in a third party add-on, you can try out Agile Tools. We have csv export option which exports epic hierarchy and progress based on story points and time estimates, as screen shot attached.

Agile Tools - Epic Tree and Time in Status 

The add-on allows you to manage and visualize your Epics hierarchy with option to view all your custom fields on a single screen.

Key features of Epic Hierarchy:

  • Epic Sum up - Roll up for Time estimates and Story Points
  • Excel like editing for key fields
  • Excel export of hierarchy data. Progress % on "remaining estimate" or "original estimates"
  • Support for custom names for Epic & Story fields
  • Epic Tree on Issue Screen
  • Custom field roll up

Along with Epic Sum, you also get 2 other important functionalities within the same plugin, Links Hierarchy and Multiple Time in Status reports (to track your issues)

 

Epic Hierarchy-Excel.PNG

Epic Hierarchy.PNG

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

938 views 2 22
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