Release List Exporter

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.

Initial State

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.

Three-Step Workflow

Work Item Preview

Before any file is written, a full-screen preview modal shows you everything that will be exported.

Work Item Preview Modal

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.

Exported Excel File

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.