Share via

Can Azure DevOps import Test Cases from Excel and automatically trace the requirement work items to the Test Cases?

Andrew Reynolds 21 Reputation points
2022-06-13T17:08:52.677+00:00

Currently I am working on a project that is converting manual Test Cases from a failed UAT cycle (which had zero requirement traceability as test case steps were recorded in Excel.)

My job is to import the test cases from Excel to Azure DevOps. I am not only doing the 200 Test Cases one-by-one, but also the requirement traceability one-by-one.

My question is: Is there a way to define the traceability in an Excel workbook to tie the 'Requirement (Work Item)' in Azure and it's relationship (Related to) in Azure to the Imported Test case?

In other words: When Importing the Test Case, what fields could I add to Excel to trigger Azure to link Requirements to the Test Case (with the relationship defined as 'Related to')?

Community Center | Not monitored
Accepted answer
  1. MayankBargali-MSFT 70,941 Reputation points Moderator
    2022-06-14T02:09:44.067+00:00

    Hi @Andrew Reynolds

    Welcome to Microsoft Q&A! Thanks for posting the question.

    DevOps is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).
    You can ask the experts in the dedicated forum over here:
    https://stackoverflow.com/questions/tagged/devops
    https://developercommunity.visualstudio.com/spaces/21/index.html

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.