How to add workitems,tasks to Azure Boards(VSTS) from Excel

Let us see how to add tasks to VSTS from Excel.Instead of adding it from Azure Boards it’s easier to add it via Excel

Step 1: Open Excel and Click on Team tab (By Default it’s available in latest version of excel)

Step 2: Click on New List on the team tab as shown


Step 3: If there is no AzureDevops(VSTS) server saved, a popup would be displayed as shown below, Click on servers in the popup

image 1

Step 4: Click on Add Server as shown

image 2

Step 5: Then Add the Azure Devops (VSTS) url as shown below

image 3

Step 6: Then Enter the username and password as shown

image 4

Step 7 : Once you have signed in, the VSTS url will be displayed as shown

image 5

Step 8 : Then select the Project for which you want to add tasks as shown

Step 9 : Then select the Query as shown (A simple query can be directly created from Backlogs)

image 7

Step 10 : You will see some thing like this in the Excel sheet

image 8

Step 11: Add as shown in the below excel and then click on Publish button.Once published you can see workitem ids next to it

image 9

You can see on it Azure Boards also

985e8ba6 9d33 4a51 9dcc d4423e0e9cb3

You may also like...