Select multiple work items and open them in Excel You can also click the 'Open in Excel' button available on the Queries toolbar as well. 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'. Learn more about Office integration Open an entire query in Excel for editing, data analysis and more Once you are ready to publish your changes, simply hit 'Publish' from Excel to sync your changes back to Azure DevOps. Work items that are opened in Excel can be edited and published back to Azure DevOps with a single click. Use this extension for bulk editing work items, or to leverage Excel tools to analyze and visualize a large number of work items. Team Foundation Server Office® Integration 2017 or later.This extension requires Microsoft Excel and one of the following clients to be installed:
