Forum Discussion
Export Azure DevOps Pipelines Generated Work Items
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, thank you so much for your response!
I was just wondering if that’s the only available option to export the work items? I’ve tried applying detailed filters—such as title, state, assigned to, and date—to help exclude unrelated or unlinked work items.
For now, I've been copying and pasting the work items directly into Excel, as it is more convenient than filtering them through the query.