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

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…

Monitoring your containers in an AKS cluster with Prometheus

Monitoring and alerting is arguably one of the most important thing in Cloud Engineering and DevOps. It's the difference between your clients stack being up and a client being down. Most of us have SLA's to abide by (for good reason). Today we're going to learn how to spin up Prometheus in an AKS cluster to monitor our applications.

1. Intermediate knowledge of Kubernetes
2. An AKS cluster spun up in Azure

Recently AKS supports Prometheus via Helm, so we'll use that for an automated solution to spin this up. This installs kube-prometheus, which is a containerized version of the application. With raw Prometheus, there are a few things that are needed for the operator;

1. Prometheus: Defines a desired deployment.
2. ServiceMonitor: Specifies how groups of services should be monitored
3. Alertmanager: Defines the operator to ensure services and deployments are running by matching the resource

With kube-prometheus, it is all packaged for you. This means configuri…

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 …