Use this extension for bulk editing work items, or to leverage Excel tools to analyze and visualize a large number of work items. Work items that are opened in Excel can be edited and published back to Azure DevOps with a single click. Once you are ready to publish your changes, simply hit "Publish" from Excel to sync your changes back to Azure DevOps.

Note: This extension requires Microsoft Excel, and an installed version of Visual Studio or the free Azure DevOps Office Integration client. Click here to learn more.

If you are using an older version of Azure DevOps Server/Team Foundation Server (2019 or earlier), the compatible extension is published as Azure DevOps Open in Excel 2019.

Documentation

Supported scenarios:

• Open Work Item Query in Excel (from Query explorer or Query results toolbar)

Open an entire query in Excel for editing, data analysis and more

To access an entire query, navigate to Work > Queries, select the query you would like to open and use the right-click option in the context menu to "Open in Excel".

You can also click the "Open in Excel" button available on the toolbar for a query as well.

Support

How to file issues and get help

This project uses GitHub Issues to track bugs and feature requests. Please search the existing issues before filing new issues to avoid duplicates. For new issues, file your bug or feature request as a new Issue.

Microsoft Support Policy

Support for this project is limited to the resources listed above.