Export work items from any Azure DevOps release pipeline directly to a formatted Excel workbook without leaving the portal. The extension adds a Release Export tab inside your project's Pipelines section and walks you through a guided three-step workflow before generating the file.
No external server, no PAT configuration, and no separate tool needed. Everything runs inside Azure DevOps using your existing session token.
How It Works
Initial State
When you open the Release Export tab, the three-step wizard loads with the first step active. Steps 2 and 3 unlock progressively as you make selections.
Three-Step Selection Wizard
Step 1 — Select a Release Pipeline All classic release pipeline definitions in your project are displayed as selectable cards. Click one to load its releases.
Step 2 — Select a Release The pipeline's 30 most recent releases are shown in a table with the deployment status of every environment displayed as colour-coded badges:
| Badge | Status |
|---|---|
| Green | Succeeded |
| Blue | In Progress |
| Yellow | Partially Succeeded |
| Red | Rejected / Failed |
| Grey | Not Deployed / Cancelled |
Step 3 — Select a Deployment Stage Each stage is shown as a card. The extension automatically computes how many work items are in this release relative to the last successful deployment of that stage, so you always see an accurate delta count.
Once all three steps are complete, the Export to Excel button becomes active at the bottom of the page.
Work Item Preview
Before any file is written, a full-screen preview modal shows you everything that will be exported.
The preview provides the following actions:
- Sortable table — click any column header to sort by Work Item ID, Assigned To, Status, or Tags
- Row removal — click the × on any row to exclude it from the export
- Copy Table — copies a richly formatted HTML table to the clipboard, ready to paste into Word, Outlook, Excel, or Google Sheets with live hyperlinks on each work item ID
- Save Query — creates or updates an Azure DevOps query named Release List Sprint with the current set of work item IDs, keeping your board in sync with the release
Excel Export
Clicking Download Excel generates and saves a .xlsx file directly to your browser's downloads folder.
The workbook is produced with TableStyleLight11 formatting and includes:
| Column | Content |
|---|---|
| Sr. No | Sequential row number |
| Work Item | Type label + ID (hyperlinked to Azure DevOps) + title |
| Assigned To | Display name of the assigned team member |
| Status | Current work item state with colour fill (Active = yellow, Resolved = green, Closed = grey) |
| Tags | Comma-separated tags (omitted automatically for Dev and Test stages) |
Work item IDs are hyperlinked directly to Azure DevOps so the spreadsheet can be shared externally and still navigate back to the source record.
Export History
A sidebar panel tracks every file downloaded during the current session, showing the filename, item count, and time of export.
Requirements
Azure DevOps
- Classic release pipelines (the extension does not support YAML multi-stage pipelines)
- Compatible with Azure DevOps Server (on-premises) and Azure DevOps Services (cloud)
OAuth Scopes
| Scope | Reason |
|---|---|
vso.release |
Read release definitions, releases, and environments |
vso.work_write |
Read work item details and create or update saved queries |
vso.project |
Resolve project context at runtime |
vso.graph |
Resolve user identity and display names |
Publisher
Developed and maintained by Ansi ByteCode LLP.