Forum Discussion

gemberbarroso's avatar
gemberbarroso
Copper Contributor
Apr 14, 2025
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?  
Azure devops pipeline
excel
Work items
  • MoritzG's avatar
    MoritzG
    Apr 15, 2025

    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.

MoritzG's avatar
MoritzG
Iron Contributor
Apr 15, 2025

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.

gemberbarroso's avatar
gemberbarroso
Copper Contributor
Apr 21, 2025

Hi,

I will take note of your suggestions.

Thank you for your assistance!

  • MoritzG's avatar
    MoritzG
    Iron Contributor
    Apr 21, 2025

    Happy to help! :)

Resources