Skip to main content

Create new work items with Excel for Azure DevOps

It's no secret that practicing DevOps is just as much of a business position as it is a technical position. We have a very specific job to do - ship the product and ship it fast to stay ahead of competition. To successfully do so, we must plan our work and collaborate properly. If you're using Boards in Azure DevOps to track your tickets, you may be excited to know that there's a great Excel extension called "azure devops standalone office integration" that'll actually allow you to create work items right from Excel and publish those tickets to Azure DevOps. Let's get started!

The first thing you'll need to do is have Excel (at least Office 2010) installed and the Team Foundation Server Standalone Office Integration (

After you have that let's go ahead and open up Excel and head over to the "team" tab.

Next thing we want to do is click on "New List"

Let's go ahead and click on "Servers" so we can connect to our Azure DevOps portal and click "add".

After you type in the URL to your portal you will be prompted to type in your email and password associated with your account. Once you return to the add/remove screen go ahead and click close.

Choose which Team Project you would like to connect to then click "Connect". Once you click connect you will be presented with a "New List" screen. Choose the "Input List" option.

Now that we have our list let's go ahead and create some tickets!

Now click on your "title" bar and click "Publish in the Team ribbon.

Let's head back over to our Azure DevOps portal and go to Boards > Work items.

We now have our two new tickets.

You may be asking yourself "why do this in Excel?". The primary reason why I would do this in Excel is for the convenience. I don't have to manually go into Work Items and add a bunch of new tickets in. Let's say you have 10 tickets to add. Would it make more sense to do it manually 1 by 1? Or put them in a spreadsheet all at once and simply click the "publish" button?


Popular posts from this blog

Run PowerShell code with Ansible on a Windows Host

Ansible is one of the Configuration Manager kings in the game. With it's easy-to-understand syntax and even easier to use modules, Ansible is certainly a go-to when you're picking what Configuration Management you want to use for your organization. Your question may be "but Ansible is typically on Linux and what happens when I'm in a Windows environment?". Luckily I'm here to tell you that Ansible will still work! I was pleasantly surprised with how easy it is to use Ansible on Windows with a little WinRM magic. Let's get started.

Pre-requisites for this post:
1) WinRM set up to connect to your Windows host from Ansible
2) Ansible set up for Windows Remote Management
3) SSH access to the Ansible host
4) Proper firewall rules to allow WinRM (port 5985) access from your Ansible host to your Windows host
5) Hosts file set up in Ansible that has your IP or hostname of your Windows Server.
6) At least one Linux host running Ansible and one Windows Server host …

Running PowerShell commands in a Dockerfile

As Docker continues to grow we are starting to see the containerization engine more and more on Windows. With the need for containers on Windows, we also need the same automation we get in Linux with Dockerfiles. Today we're going to create a Dockerfile that runs PowerShell cmdlets.
Prerequisites; 1. Docker for Windows
2. A code editor (VSCode preferred)

Let's go ahead and get our Dockerfile set up. Below is the Dockerfile I used for this post.

from MAINTAINER Michael Levan RUN powershell -Command Install-WindowsFeature -Name Web-Server RUN powershell -Command New-Item -Type File -Path C:\ -Name config
As you can see from the above, this is a tiny Dockerfile. What this will do is install the IIS Windows 

Feature and create a new file in C:\ called "config".
You should see something very similar to the below screenshot;

Next let's create a running container out of our image. First we'll need to run docker container ls to

 get o…

DevOps tooling in the Microsoft realm

When I really started to dive into automation and practicing DevOps with specific tooling, there were a few key players. At the time Microsoft was not one of them. They were just starting to embrace the open source world, including the art and practice of DevOps. Since then Microsoft has went all in and the tech giant has made some incredible tooling. Recently I switched to a Microsoft-heavy environment and I love it. I went from AWS/Python/Ansible/Jenkins to Azure/PowerShell/ARM/Azure DevOps. My first programming language was PowerShell so being back in the saddle allowed me to do a full circle between all of the different types of tooling in both worlds. Today I want to share some of that tooling with you.

The first thing I want to talk about is ARM. What is ARM? ARM is a configuration management tool that allows you to perform software-defined-infrastructure. Much like Ansible and Terraform, ARM allows you to define what you want your environment to look like at scale. With ARM, yo…