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

Step 4: Click on Add Server as shown

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

Step 6: Then Enter the username and password as shown

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

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)

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

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

You can see on it Azure Boards also