Setting Up Excel Integration in Azure DevOps

In this article, we want to discuss creating a project report from Azure DevOps into Microsoft Excel. So, let’s get started:

• Download the Azure DevOps Office 2019 here Download Visual Studio Tools – Install Free for Windows, Mac, Linux (microsoft.com)
• After installing, choose Team Tab and after that click new List

• You can add server by put https://dev.azure.com/yourorganization/ . The system will show you to authenticate with Microsoft 365 accounts / Microsoft Account
• After successfully authenticating, try to select your project. You can select existing query by clicking query list or choose new

• You will tree list as shown below.

• After that you can create report by creating chart or insert into Microsoft Project.