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

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
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

322 views 1 5
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