The "Export to Excel" extension for Azure DevOps allows you to export Azure work items into real Excel reports in XLSX format📊, enabling you to create custom reports and dashboards using custom Excel templates.

This extension simplifies and automates the process of generating reports from your work items and test plans, providing convenient features and flexibility.

Automate Creation of all kinds of Reports - Release Notes, Summaries, Sprint Reviews, Analysis, Time Sheets, Test Results

Features

Sample reports

Use Excel capabilities: Data Types, Sorting, Filtering, Links, Conditional Formatting and more

Export all Comments, Attachments and Links related to work items

Use work item data in PivotTable & PivotChart

Example: Completed Work - Time report by assignee

Example: Created vs Resolved by Month Report

Example: State of work items by Iteration - Configure custom reports

Export Work Items from Any View

Export up to 1000 work items into one document with a single click: Save time and effort by exporting multiple work items simultaneously with just one click using the context menu.

Export from any view: Whether you're working with Sprints, Backlog, Query Results, or Work Item Details (by clicking on the three dots in the top right corner), you can export documents from various views within Azure DevOps.

Export from Sprints/Backlog/Queries/Work Item Details

Export Modal

Manual Work Items Selection Feature

Our extension features a user-friendly interface that allows you to manually search and select specific work items for export, putting you in control of the content you include in your reports.

Work Items Selection

Use Custom XLSX Templates

Define custom XLSX templates for your Azure projects: Create and use multiple custom spreadsheet templates (.xlsx format) according to your specific requirements. You can use and manage multiple document templates per project.

Templates Management

Test Plans, Test Cases and Test Results support

Export Azure DevOps Test Plans, Test Cases and Test Results with detailed Steps, Test Results, and grouped Outcomes including test configuration info. Get clear, organized Excel Test reports in seconds.

Test cases with Test Results

Utilize System and Custom Fields

Access and utilize all system and custom fields available in your Azure DevOps projects, allowing for comprehensive document creation. The extension will analyze all your work item types and prepare a list of all possible placeholders for your documents.

The extension provides support for Formatted Text Fields (HTML), exporting lists of work item comments, links and attachments.

Custom Template Example

No Setup Required

Export to Excel is ready-to-use just after you install the extension without any configuration or installing additional software. Extension provides a convenient default, generic document template for work item export.

Default templates:

• Items with basic fields
• Items with description fields
• Items with Comments, Attachments, Links
• Test cases with Test Results
• Report - State by Type, Iteration
• Report - Workload distribution
• Report - Completed Work
• Report - Created vs Resolved

Settings & Permissions

The extension allows Project Administrators to control which Azure DevOps User Groups can manage document templates and/or export documents within each Azure project. You can also control extension visibility across your projects.