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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Requirements Traceability Matrix

We have just setup a new Jira Next-Gen Project.  The requirements for this project have recorded in a Requirements Traceability Matrix (a fairly large Excel Sheet).  How do I import import this RTM into Jira and ultimately, make this my Backlog?  We have also bought Confluence.


2 answers

1 accepted

0 votes
Answer accepted

Hi Nisha,

In order for your import to be successful, you need to carefully view the hierarchy of the RTM and make sure to specified the correct issue type in the first column. If there are parents and children involved, then you need to include parent id column in your RTM. The other part would be make sure that all your fields exist in Jira.

Tony Pham

Thanks Tony.  Do you know if there is a user guide to help with this step by step?  I seem to get so far but don't get the results I want.  

Thank for your support.


Hi Tony,


Thank you for your help with this.  I have now managed to get all of my requirements recorded as issue types in Jira! :-)

Thanks again


Nisha, just to add my thoughts, I've been down this road literally several times, and while I have been able to do pretty much as Tony had suggested, the problem encountered is usually that there are not enough levels of hierarchy available to do an exhaustive trace.  I'm struggling with that again now, where I need

Stakeholder->Need (Epic?)->Feature (Issue?)->Requirement (task?)->Code->Test->deploy

I end up sacrificing something inevitably because I can only go three levels of hierarchy deep (its a bug tracking tool after all, and we've just overloaded it to do things like ALM and Requirements management that many people just don't understand deeply enough to see the weaknesses.

So in my model above, I would end up mapping Features to an Epic, Requirements to an Issue (which then naturally ties into linking version control code check-ins), test cases under the Issue, and that's about as close as I can get.  If I bastardize the Feature, I can combine the need there, but its challenging from an architecture and refactoring perspective, as the Need of a stakeholder drove a feature; In a forward trace model, we end up getting myopic about the Feature when we might in fact replace the Feature entirely with a different approach when focusing on the need.  From a reverse trace model, the Stakeholder for a Feature is probably someone like a Product Manager, but in fact the Need likely came from elsewhere before PM encountered it, and having trace back to the sources of the need allows for deeper digging and qualification of the need.  So you *might* be able to get Product Management to manage their own Need trace, perhaps including Need identifiers into the Epic when it is defined, but bottom line, I haven't seen how to do a full trace effectively in JIRA, Tony's approach gets you there but you need to evaluate what compromises you want to make.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events