Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • 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

how to import subtask in Jira Software(Cloud)

Terry Han I'm New Here Dec 15, 2020

I just use Excel fille which input some field(about some Assignee, Sprint, ), but during the importing period, system mentioned Assigness who can't import it. So plesase help me solve and give me solution ASAP.

and at the same time, cold you teach me how to input subtask into system? Can you give me example file for excel format which include some fields(Sprint, Summary, ParentID, Subtask format)

Thanks in advance.



4 answers

0 votes

If it can't import assignee, the most likely explanation is that the mappings you have done do not match users correctly.

Subtasks are imported the same way as standard issues, but you have to give them an extra field that defines the parent issue for them, and map that to the parent field during import. I'm assuming you are importing sub-tasks after you've got their parent issues in.  You can actually do task + sub-task in one sheet, but that's a bit complex and I don't think you've asked for the essay on it.



Thanks man in advance, could you give me example for Excel format file which include story or task, and their sub-task field example? That I could understand whole format when I input them into system.


Thanks again.



0 votes

A very simple example that does actually work:

summary, type, parent id
item 1, item, 111
item 2, item, 222
item 3 (part of item 1), subtask, 111
item 4 (part of item 2), subtask, 222
item 5, item, 333
item 6 (part of item 1), subtask, 111

This will import 3 issues (item 1, 2 and 5), and 3 subtasks (2 parts of item 1 and 1 part of item 2).  Note that the "parent id" is totally independent of Jira data, and although it will be imported into the "external id" field, it's not real data, it is just there to indicate subtask ownership.

thanks guy, I have tried to use your way to import, the subtask has been imported, but these tasks haven't been imported according to my assigned story or task below. Could you tell me where I can find Story or Task's id in the Jira system? Please review below pic and help me fix it. Thanks again.



I want to import subtask under Story or Task below by Excel file directly, is it possible at the same time?



To import subtasks against existing parent issues, give the key of the parent as the map-able parent ID

I know this, but could you tell me where is the key of the parent ID according to up picture(error.jpg)? can u give me screen shot for eg. ?

The picture is too small to see, but the issue key is on the right hand side of each backlog item line.

please review attached. if my format is right? (SSB2-42 is Jira system' story ID, in the excel file, below Parent ID this column, I write 'SSB2-42' here? It means Parent ID?)pic ID for story.png

i try to use picture example, but failure. System always prompt, please match column in the excel for Parent ID. So please help me. Thanks.

Suggest an answer

Log in or Sign up to answer
Site Admin
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...

637 views 10 16
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