The only way to get the Azure DevOps Office Integration plug-in is by installing one of the latest editions of Visual Studio or the Azure DevOps Office Integration installer.

Installed Azure DevOps Office Integration 2019 (free).

Installed Microsoft Excel 2010 or later version, including Microsoft Office Excel 365.

Even if you've installed Visual Studio for Mac, connection to Azure DevOps from Excel isn't supported. To learn more, see Bulk import or update work items using CSV files. If you don't have access to Excel, you can still perform bulk import and update using CSV formatted files. For answers to specific questions about the integration of Excel and Azure DevOps, see FAQs: Work in Excel connected to Azure Boards.

Edit Area and Iteration Paths (opens in web portal)įor information about connecting to Excel, see Connect Azure Boards to an Office client.

Open a work item from Excel to add additional information (opens in web portal).

Add attachments to one or more work items.

Link work items, find work items to link to, edit links, and more.

Select user accounts for identity or person-named fields.

Add and remove work item fields from your worksheet.

Convert a flat-list to a tree-list, change your list type or query.

Import or update work items, either a flat list or hierarchy tree list.

Use select Excel features when connected to Azure Boards.

Choose the type of list or query to support your task.

In this article you'll learn how to complete the following tasks: You can also use native Excel features to support other actions, such as summing a column, copy-and-paste rows, fill down data into cells, and more. Excel supports adding work items, updating existing work items, adding links and attachments to multiple work items, and more. When you need to add or modify many work items, using Microsoft Excel can save you time.

Add or modify Azure Boards work items in bulk with Microsoft Excel

Azure devops open in excel