Work Items in Excel for Azure DevOps

Help

Work Items in Excel is an Excel add-in that loads an Azure DevOps saved query into a sheet, lets you edit it, and publishes your changes back. It runs in Excel on Windows, Mac and the web, and works with Azure DevOps Services organizations. The optional Open in Excel extension adds an entry to your queries in Azure DevOps.

Install

The Excel add-in

  1. In Excel, go to Home → Add-ins (in older Excel: Insert → Get Add-ins).
  2. Search for Work Items in Excel and select Add.
  3. A Work Items button appears in the Azure DevOps group on the Home tab. Click it to open the pane.

Your Microsoft 365 admin can also deploy the add-in to everyone from the Microsoft 365 admin center (Settings → Integrated apps).

The Open in Excel extension (optional)

An Azure DevOps organization admin installs it from the Visual Studio Marketplace. It adds Open in Excel to the menu of every saved query.

Sign in and load a query

  1. Click Work Items on the Home tab.
  2. Enter your Azure DevOps organization: the name after dev.azure.com/.
  3. Select Sign in and sign in with the work or Microsoft account you use for Azure DevOps. The first time, Microsoft asks you to accept the add-in's permissions; after that, sign-in is silent.
  4. Pick a Project and a saved query from My Queries or Shared Queries, and select Load query.

The work items land in a new sheet as an Excel table: ID, Work Item Type and Title first, then the query's own columns, then Parent. Tree queries load with titles indented by level. The add-in sees only what you can see in Azure DevOps.

Your account row at the top of the pane opens a menu with Change organization, Help, Support and Sign out. Change query on the query card picks another query.

Start from Azure DevOps

With the extension installed, open a saved query in Azure DevOps and choose Open in Excel from its ⋮ menu (or the query's menu in the Queries list). A workbook named after the query downloads. Open it in Excel (in Excel on the web, upload it to OneDrive first) and click Work Items: the pane shows that query, ready to load.

Edit

Changed cells turn yellow and new rows green, and the pane counts them under Not published yet. Your changes are kept in the workbook, so you can save, close and publish later.

What you can't change from the sheet

If a row can't be published as it is (an empty title, a state the type doesn't have, a column that can't be set), the pane lists it under rows need a fix with a link to the cell, and Publish waits until it's fixed.

Publish

  1. Select Publish. The pane lists every change by work item, field by field with the old and new value, and every new item with its type and parent.
  2. Select Publish N items to send them, or Cancel to keep editing.

New items get their IDs written into the sheet and the colors are cleared. If Azure DevOps refuses a change (for example, a field its rules require to close a bug), that row is marked, the pane says why with a link to the item, and the other changes are published. Fix the row and publish again.

When someone changed it meanwhile

Publish checks each item against Azure DevOps before writing. If a teammate changed a different field since you loaded, your change is added on top of theirs. If they changed the same field, nothing is overwritten: the pane shows your value and theirs, with who changed it and when. Pick the one that stays and select Publish, or Decide later.

Refresh

Refresh reloads the query into the same sheet with the latest values from Azure DevOps. If you have unpublished changes, it asks first: refreshing discards them.

Admin approval

The add-in asks for one permission: to act in Azure DevOps as you (Azure DevOps user_impersonation). In most organizations each person accepts it on first sign-in. If your organization allows only admins to approve apps, the pane says Admin approval needed: select Copy approval link and send it to a Microsoft Entra admin (Global Administrator, Application Administrator or Cloud Application Administrator). Once they approve, select Try again.

If something's wrong

The pane saysWhat to do
No organization named …Check the name after dev.azure.com/ in your Azure DevOps address.
Sign-in cancelled / Sign-in didn't workSelect Sign in again. If your browser blocks pop-ups, allow them for Excel.
No access to …The account you signed in with isn't a member of that organization. Select Switch account, or Change organization.
Admin approval neededSee Admin approval.
Can't reach Azure DevOpsNothing was lost: your edits stay in the sheet. Select Try again when you're back online. If the connection dropped partway, the items not yet sent stay in the sheet.
Sign in again to publishYour sign-in expired. Select Sign in again; your edits stay in the sheet.
The … column is missingA table column was deleted or renamed. Undo in the sheet, or select Refresh to rebuild the table.
This sheet has no queryGo back to the sheet the query loaded into, or select Load query to load it again.

Your data

Excel talks to Azure DevOps directly; work item content stays in your workbook and in Azure DevOps. The workbook keeps a copy of what the last load brought in, so the add-in can tell what you changed. What we store (usage counts per organization and who opened the add-in): Privacy. Terms: Terms of use.

To remove the add-in, open Home → Add-ins → More add-ins → My add-ins and remove it. To remove its permission from your account, go to myapps.microsoft.com.

Support

Questions or problems: contact support. We reply by email.