Forum Discussion
Solved
Export Azure DevOps Pipelines Generated Work Items
Hi, Is there a way to export the work items linked to the Build or Release pipelines into an Excel file?
Hi,
there is an Azure DevOps Office Integration (Plugin), which allows to edit work items directly in Excel: https://learn.microsoft.com/en-us/azure/devops/boards/backlogs/office/bulk-add-modify-work-items-excel?view=azure-devops&tabs=agile-process.
But tbh, I never used or worked with that.Alternatively, you can use the DevOps REST API to execute your tasks programmatically (e.g. with a python script). There are calls available to get builds and their linked work items.
Hi,
you could use a DevOps Query to get the work items and then export the results of the query to excel. To do so:
- In Azure DevOps, go to Boards > Queries.
- Create a new query that filters work items based on the linked builds
- Run the query, then use the "Export to Excel" option.