Skip to content

Export Azure DevOps Test Plans to Excel

  • Azure DevOps
  • Export to Excel
  • Test Plans
  • Excel

Export Azure DevOps test results to Excel. Use Test cases with Test Outcomes for a result per case, or Test cases with Test Runs for every step.

Prerequisite: Install Export to Excel on your Azure DevOps organization

Install from Marketplace

Step 1

Select test points

Open the test plan, select the test points, and choose Export to Excel.

Select test points and open Export to Excel
Select test points and open Export to Excel
Step 2

Choose a test template

In the dialog, select Test cases with Test Outcomes or Test cases with Test Runs, then export.

Choose Test Outcomes or Test Runs and export
Choose Test Outcomes or Test Runs and export
Step 3

Review outcomes

Test cases with Test Outcomes lists each case and its result so you can filter and chart the run.

Excel sheet of test case outcomes
Excel sheet of test case outcomes
Step 4

Review step-by-step results

Test cases with Test Runs adds a sheet with each step, outcome, and parameters.

Excel sheet of step-by-step test results
Excel sheet of step-by-step test results

Common questions

How do I export Azure DevOps test plans to Excel?
Install Export to Excel, select test points in the plan, choose Export to Excel, and pick a test template.
Which template should I use?
Use Test cases with Test Outcomes for a result per case. Use Test cases with Test Runs when you need every step.
Can I export test results to Word instead?
Yes. Export test plans to Word or PDF builds a document with steps, outcomes, and a run report from the same test points.

Visual Studio Marketplace

Export to Excel

Export work items, test plans, wiki pages, and work item history to Excel.

Export to Excel guides

Install from Marketplace

Export work items to Excel

Work Items

Export Azure DevOps work items to a formatted Excel workbook, not a CSV. Comments, attachments, and links each get their own sheet. Start from the extension, a sprint, or a query.

Export work item history to Excel

Work Item History

Export Azure DevOps work item revision history to Excel. Items with History writes each field change, comment, and edit as a row, including who changed it and when.

Export wiki pages to Excel

Wiki Pages

Export Azure DevOps wiki pages to Excel when you want page text and comments in a sheet you can filter. For a formatted PDF or Word file, export the wiki to a document instead.