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; } } }

How to export subtasks with their Parent ID to excel spreadsheet?

Irina_g08r7w

I have a JIRA project with complicated structure.

I need to clone it with slight changes into 16 other projects.

I can export Issue Table report with Epic Link where I can get the parent of Epics and Stories, but subtasks do not have Epic Link. Where and how can I get Parent Id for subtasks?

Thank you,

Irina

Accepted answers

All comments

Tomasz Kustrzynski

You could export list of subtasks for a parent task with Advanced Export (JIRA cloud only).

This is an example of what it could look like (a column with comma separated list of subtasks):

Screen Shot 2017-07-28 at 20.25.40.png

Irina_g08r7w

I do not see Parent ID column between other "standard column names" in Advanced Reports.

Without Parent ID you cannot group subtasks by stories or risks they are associated with in Excel file.

For some reason this question is asked many times during a couple of years, but I was not able to google any solution for this particular question.

Parent Link IS NOT what I need. In most of the cases this colummn is empty for subtasks. I need Parent ID.

Tomasz Kustrzynski

I'm the author of that plugin. If having list of sub-tasks for parent tasks doesn't work for you and you're using JIRA Cloud, I could add a feature to export id of parent task for subtasks.

Would that help you?

You don't see 'parent id' among list of JIRA fields, because there's actually no such standard field. You can get list of subtasks from parent tasks, but not the other way round.

Irina_g08r7w

If I would have the parent ID or Parent Name for my subtasks (in my case these are Stories) I'd be able to export this report into Excel file, sort subtasks by their parent and finally import into a new project.

In my case without subtask Parent ID I have to re-type 16 times all of these 60+ subtasks!

By the other hand I can create a Jira Plan based on my Scrum Board, where I perfectly see the whole project with tree structure: Under Epic I see Stories, and under each story I can see the subtasks.

That is exactly what I need, but there is no way to extract this view into Excel file, or even Cut&Paste from the web browser into a file.

Aron Gombas _Midori_

Better Excel Exporter has a calculated field that will export the parent issue's key or a blank string if the issue is not a sub-task. You can use it for your use case:

See: https://www.midori-global.com/products/better-excel-exporter-for-jira/server/documentation/customization#calculated-fields

Welcome!

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

Quick Links

Find more posts tagged with

confluence

jira

hierarchy

ms-excel

report

sub-task