← Test Evidence Export for Azure Test Plans
Auditors and clients often ask for a table that shows, for each requirement, which test cases cover it and how they last ran. Azure Test Plans holds all of that, but it has no built-in view that puts it in one sheet. This guide shows how to build the matrix in Excel with Test Evidence Export for Azure Test Plans. I'm the developer.
The matrix is built from the links that already exist in Azure DevOps. A test case counts as covering a requirement when it has a Tests link to it (the requirement shows the reverse Tested By link). Adding a test case to a requirement-based suite creates that link for you. Work item types treated as requirements include user story, product backlog item, requirement, feature, epic, issue, task and change request.
In your Azure DevOps project choose Test Plans → Test Evidence Export.
Pick the test plan. Select suites to limit the matrix, or leave the list empty to cover the whole plan. You can also filter by configuration, outcome and run date. Under Results, Latest outcome only is the right choice for a matrix, because each pair shows one outcome.
Set Output to Excel workbook only, or choose Word and Excel if you also want the test execution report. Select Export. The workbook is built in your browser and downloaded to your device.
The Traceability sheet has one row per requirement and test case pair, with these columns:
A requirement that sits in an empty requirement-based suite still gets a row, so a coverage gap is visible instead of silently missing. Because the sheet has a filter on its header row, you can filter on Latest outcome to list everything that failed or has not run.
The workbook also has a Results sheet with one row per test point, including the linked requirement and bug IDs.
The Traceability sheet is a Pro feature. The free plan exports the Results sheet, up to 25 test cases per export. Pro removes the limit and adds the traceability matrix, screenshots, the sign-off block and saved templates.
The extension is read-only (scopes vso.test and vso.work) and runs in your browser. See the privacy policy. For the Word report, see Export Azure Test Plan results to Word.