Connect Azure Boards to an Office client

Azure DevOps Services | Azure DevOps Server 2022 - Azure DevOps Server 2019

To support your work tracking efforts, you can use Microsoft Excel. You can either work in online mode, where you're connected to either Azure Boards or Azure DevOps Server. Or, work in offline mode, where you access the local computer and document.

Tip

For bulk import or to update work items, use the web portal or CSV import.

Supported Office clients and Azure DevOps versions

The following table indicates the Office clients supported for each Azure DevOps version.

macOS isn't supported. Even if you installed Visual Studio for Mac, connection to Azure DevOps from Excel or any other Office client isn't supported.

---

Azure DevOps/Visual Studio version

Excel

Project¹

PowerPoint Storyboarding²

---

Azure DevOps Services
Azure DevOps Server 2020
Azure DevOps Server 2019 Visual Studio 2022
Visual Studio 2019
Azure DevOps Office Integration 2019

✔️

TFS 2018
Visual Studio 2017

✔️

✔️

✔️

Note

• Support for Project integration and the TFSFieldMapping command is deprecated for Azure DevOps Server 2019 and later versions. You might find support using one of the Marketplace extensions.
• Support for linking PowerPoint files to work items from within PowerPoint is deprecated starting with Visual Studio 2019 and Azure DevOps Office Integration 2019. You can still link to PowerPoint using the Storyboard link from within a work item. Also, the Visual Studio Gallery for PowerPoint Storyboarding is deprecated.

Prerequisites

Connection from an Office client to an Azure Boards project requires the following software and permissions.

• To connect Excel to Azure Boards, install Office Excel 2010 or later version, including Office Excel 365.
• All Office integration tasks require an installed version of Visual Studio or the free Azure DevOps Office Integration 2019.
• The only way to get the Azure DevOps Office Integration plug-in is to install one of the latest editions of Visual Studio or Azure DevOps Office Integration. The plug-in supports connection to Azure DevOps from Excel.
• To connect to an Azure Boards project, you need to be a member of the project. If you don't have an Azure Boards project yet, you can create one.

• Microsoft Excel 2010 or later version, including Microsoft Office Excel 365
• Visual Studio 2013 or later version or Team Foundation Server Standalone Office Integration (free)
• Permissions to connect to the project in Azure Boards. If you don't have an Azure Boards project yet, you can create one.

For information about compatibility requirements, see Azure DevOps client compatibility.

Important

You might receive the following error if you install Microsoft Office 2010 on the same computer as a previous version of Office.

Team Foundation Error, Interface not registered (Exception from HRESULT: 0x80040155)

You might resolve this error by repairing Office. Access the Repair option by opening the Control Panel, choose Uninstall or change a program, open the context menu for Office 2010, and then choose Change. For more information, see Resolve Azure DevOps and Office integration issues.

Publish and refresh work items

When you add or update work items from Excel, local copies of your work items are created. To keep data in sync, refresh your local file when you open it and publish and refresh frequently during a long online session.

At first, the data in the local document matches the data in the database. But you or other team members can change the data about work items and cause the two to differ. To view the most recent changes from the database, refresh the document. The refresh downloads the latest values in the data store to your local document. To write changes from the document to the database, publish the changes. Publishing uploads the changes you made to the work item tracking data store.

To keep work items in sync from your local data store and Azure Boards, publish and refresh often.

Azure DevOps and Excel

To work in Excel, see Bulk add work items with Excel.

Connect an Azure DevOps project to Excel

To add or modify work items by using Excel, connect your worksheet to a project. Establish this connection to bind the document to the Azure DevOps project to exchange information.

Note

• This section illustrates how to connect Excel to an Azure Boards project. The steps to connect to PowerPoint are similar.
• When you connect to Azure Boards in the cloud, the Team Project Collection automatically gets selected, because there's only one collection associated with your Azure DevOps Services organization. When you connect to Azure Boards in an on-premises server, choose the Team Project Collection before you choose the project.

You can start work from the web portal, Excel, or Visual Studio/Team Explorer. Your worksheet is associated with either a list of work items or a work item query.

Open query in Excel (web portal)

This connection method requires that you install Azure DevOps Open in Excel. It also requires Visual Studio 2017 or later version.

1. From your web browser, check that you selected the right project, choose Boards > Queries, and then choose All.

   

2. Choose the query you want to open in Excel.

3. From the Results tab, choose the actions icon.

   

Connect from client to Azure Boards

To connect from your Office client to an Azure DevOps Services project, do the following steps.

1. Start with a blank worksheet.

2. If your client is signed into a user account, make sure that it's your Azure DevOps user account. If not, choose your account name and sign in as another user.

   

3. If you don't see the Team ribbon or the Team menu if you use Office 2007, see Resolve Azure DevOps and Office integration issues.

4. Select Team, place your cursor in Cell A1, and then select New List.

   

5. The Connect to Azure DevOps Server dialog opens.

   

   If you're signed into your Office client with your Azure DevOps user account, the set of servers, both cloud and on-premises that you have access to, automatically populate in the drop-down menu.

   If you're not signed-in, you're working from an older version of an Office client, or you aren't connected to any servers, add them now.

6. Add a server. Choose Servers..., choose Add..., enter the URL of your Azure Boards organization, and check that the preview matches the URL that you entered. Choose OK.

   

   If you can't connect, get added as a team member.

7. With the server selected, choose the project you want to connect to, and then choose Connect.

   

   Make sure your Azure DevOps user account appears at the bottom of the dialog. If it isn't, choose Switch User and sign in to the correct account.

8. From the New List dialog, choose Input list. Or, if you want to work with a list of work items defined in a query, choose Query list.

   

Connect client to Azure DevOps on-premises

To connect from your Office client to an Azure DevOps Server project, do the following steps.

1. Start with a blank worksheet.

2. If your client is signed into a user account, make sure that it's yours. If not, choose your account name and sign in as another user.

   

3. If you don't see the Team ribbon or the Team menu if you use Office 2007, see Resolve Azure DevOps and Office integration issues.

4. Choose the Team tab, place your cursor in Cell A1, and then choose New List.

   

   The Connect to Azure DevOps Server dialog opens.

   

   If you're signed into your Office client with your Azure DevOps user account, the set of servers that you have access to, both cloud and on-premises, automatically populate in the dropdown menu.

   If you're not signed-in, you're working from an older version of an Office client, or you aren't connected to any servers, add them now.

5. Add a server. Select Servers..., choose Add..., enter the name of your Azure DevOps Server instance. As needed, change the Port number if your deployment uses a nondefault port number. The Preview entry should display the correct URL for your deployment. Choose OK.

   

   Choose Close to close the add/remove servers dialog. From the Select an Azure DevOps Server dialog, make sure the server you added is selected, and choose Connect.

   If you can't connect, get added as a team member.

6. With the server selected, choose the project you want to connect to, and choose Connect.

   

   Make sure your Azure DevOps user account appears at the bottom of the dialog. If it isn't, choose Switch User and sign in to the correct account.

7. From the New List dialog, choose Input list. Or, if you want to work with a list of work items defined in a query, choose Query list.

   

Open Excel from Visual Studio

1. Open Visual Studio and then Team Explorer.

   Important

   To work from Visual Studio/Team Explorer, select Tools > Options > Work Items > General > Legacy experience. For more information, see Set the Work Items experience.

   

2. Connect to your Azure DevOps project that contains the work items you want to add to or update. For more information, see Connect to a project.

3. Right-click the query you want to open and choose.

   

   Excel opens with the work items listed in the query that you selected.

For more information, see Bulk add work items with Excel.

Tip

You can use multiple worksheets within an Excel workbook to work with different input or query lists. You can only connect to one project per workbook.

Work offline and reconnect to Azure Boards

One advantage of working in Excel is that you can work offline and add or modify work items. The following procedures show you how to disconnect an Excel work item list from Azure Boards. You can then reconnect later to synchronize the document with the work item database.

Note

If the project that contains work items for your Excel document is moved to a different organization or Azure DevOps Server instance, you must reconfigure the server to which the document connects. For more information, see Connect Azure DevOps project to Excel earlier in this article.

Disconnect a document file from the network

To disconnect an Excel document file from the network:

1. Open the document that you want to change while you're offline.

2. Refresh the work item list to retrieve the latest information from the work item database. In Excel, on the Team ribbon, in the Work Items group, choose Refresh.

3. Add to the work item list the columns for all fields that you want to modify. You can't add columns when the work item list is disconnected from the server.

4. Disconnect your computer from the network, or save the work item list file and copy it to another computer.

   An error message might appear that tells you the Office program couldn't establish a connection with an Azure DevOps Server.

5. Modify or update the work item list as needed.

   You can't create most types of links between work items when the work item document is disconnected from the system. The exceptions are parent-child links in an Excel tree list.

Reconnect a file to Azure Boards

To reconnect an Excel document file:

1. Reconnect your computer to the network, or copy the file to a computer that is connected to Azure Boards.

2. If you changed the document offline, in Excel, on the Team ribbon, in the Work Items group, choose Publish.

3. If you didn't change the document offline, in Excel, on the Team ribbon, in the Work Items group, choose Refresh.

4. Resolve any data validation errors or conflicts that occur.

Marketplace extensions

The following Marketplace extensions support integration between Azure DevOps and Office products.

• Azure DevOps Open in Excel: Opens a selected query in Excel.
• Office 365 Integration: Pushes notifications of configurable Azure DevOps events to an Office 365 Group.

Related articles

• Bulk modify work items (web portal)
• Bulk import or update work items using CSV files
• Work in Excel connected to Azure Boards
• Create your backlog