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

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


You may also like...

4 Responses

  1. I’m impressed, I must say. Seldom do I come across a blog that’s both
    educative and engaging, and without a doubt, you have hit the nail on the head.
    The issue is something that too few men and women are speaking intelligently about.
    Now i’m very happy I found this in my hunt for something relating to this.

  2. I’ve been surfing online more than three hours today, yet I
    never found any interesting article like yours. It’s pretty worth enough for me.
    Personally, if all web owners and bloggers made good content as
    you did, the internet will be a lot more useful than ever before.

  3. WOW just what I was looking for. Came here by searching for cbd oil that works 2020

  4. Oh my goodness! Awesome article dude! Thanks, However I am encountering difficulties
    with your RSS. I don’t know the reason why I can’t join it.
    Is there anybody getting similar RSS issues?

    Anybody who knows the answer can you kindly respond? Thanks!!

Leave a Reply

Your email address will not be published.

thirteen + 5 =