You can also do this if you have new tasks or bugs or issues, to add to an existing project. So, if you have a new Azure DevOps Project and want to bulk import a bunch of tasks for the team to work through you can do that by connecting Excel to the Project and starting the list. Once you install the plug in when you open Excel, you have a tab called Team, which allows you to connect with Azure DevOps within Excel. And being able to bulk load would be handy and this is what the plugin allows you to do! Using Azure DevOps Boards to keep track of work items, bugs, whatever it might be is an awesome way to create visibility for you and your team, however, it can be a bit tiresome entering a bunch of those things at a time. Use Excel to create items in Azure DevOps Boards For a full list of prerequisites please do check out the official documentation. To get to work with this feature you need to have Excel 2010 or later installed, the plug, be a member of the project you want to interact with, have the relevant permissions to modify items in the project you want to interact with and of course be using Azure DevOps. Now I don’t believe this tool is only for non-developers, I think it can help everyone that needs to interact with DevOps Boards. This plug in is part of the Azure DevOps Office Integration 2019 feature that allows non-developers to interact with Azure DevOps.

So, Tricia’s session opened a whole new world to me.ĭuring her session Tricia mentioned there was a plugin for Excel that allowed you to bulk import or modify DevOps Board items, which I had no idea existed! Something I use daily, but don’t even scratch the surface of functionality wise.

Recently Tricia Sinclair, delivered a brill session going into Azure DevOps Boards. As many of you may know I run the Glasgow Azure User Group, and over the last three years I’ve had the privilege to hear a good number of excellent speakers deliver their sessions at the group’s meetups.

Azure devops open in excel