Bulk Editor for Azure DevOps
Open in Excel, but in the browser: edit hundreds of work items in a spreadsheet grid, on Windows or Mac, checked against your own process before you publish. And clean up your tags: rename, merge and delete them, which Azure DevOps itself can't do.
Azure DevOps Services (cloud)Azure DevOps Server 2022+ (on-premises) On-premises install
Latest release: version 1.3.3, November 2026 · Release notes
Install free from the Marketplace Pricing
14-day Pro trial starts automatically. No account and no credit card needed.
Watch the 1-minute walkthrough with captions on YouTube.
Features
Select and fill down
Select a block with Shift+arrows, Shift+click or by dragging. Ctrl+D or the fill handle copies the top cell down, Delete clears the block, and the status line shows its count, sum and average. One Undo reverts it all.
Rollups in the tree
Next to its own value, a parent shows the sum (Σ) of its children's Story Points, Remaining Work, Effort and other estimates, updated live while you edit, paste or move items.
Test case steps (editing: Pro)
Test cases get a Steps column. Read the steps in a table of action and expected result, add, move and change them with Pro, and export and import them one row per step, like Azure Test Plans.
Queries across projects
A query without a project filter opens in one grid. Every row is checked against the rules, states and paths of its own project, and is published there.
Edit like a spreadsheet
Open a query, a backlog selection or any list of work items in a grid and type. Enter and Tab move on, Ctrl+V pastes a block copied from Excel, Ctrl+Z undoes. Nothing is saved until you select Publish.
Keyboard navigation like Excel
Move an active cell with the arrow keys, Home/End, Ctrl+Home/End and PageUp/PageDown. Enter, F2 or typing edits it, Esc cancels, Delete clears it, and Ctrl+C and Ctrl+V copy and paste.
Redo
Went back one step too far? Redo with Ctrl+Y or Ctrl+Shift+Z, or use the Redo button next to Undo.
Your process, your fields
Pick lists, required fields, states, and area and iteration paths come from your own process, including custom fields and inherited processes.
People, paths and tags
Search people for Assigned To, pick area and iteration paths, and choose from the tags already used in your project.
Never lose work
Unpublished changes are kept as a draft in your browser and restored when you come back, even after going to another page. If someone changed a work item since you opened it, that row is refused and your edit is kept.
Your formatting is safe
Descriptions with bold text, links, lists or images are never flattened: the grid leaves them to the work item form, and tells you why.
Fast with thousands of rows
Only the rows in view are drawn, so large queries stay responsive. Sort and filter any column. Works in the light and dark theme.
Excel round trip (import: Pro)
Export to .xlsx with clean text (no HTML tags), edit in Excel, and import it back. Only real changes are applied; rows without an ID become new work items.
Hierarchy (Pro)
Tree queries show as a collapsible tree. Add new work items and children right under their parent, and change parents.
Tags page: clean up your tags (Pro)
Under Boards, see every tag in your project with its number of work items. Search, sort by name or count, and show only unused tags. Rename, merge and delete tags with Pro. Free shows the overview.
Cloud and on-premises
Works on Azure DevOps Services and on Azure DevOps Server 2022 and later, with the same features and license. See Azure DevOps Server.








How it compares
| Bulk Editor | Open in Excel | Built-in CSV export/import | |
|---|---|---|---|
| Nothing to install on your computer | ✔ | Office add-in and Visual Studio components | ✔ |
| Works on Mac and Linux | ✔ | Windows only | ✔ |
| Edit right in Azure DevOps | ✔ | In Excel | In a separate file |
| Pick lists and validation while editing | ✔ | ✔ | Only when importing |
| Warns before overwriting someone else's change | ✔ | ✔ | – |
| Formatting in rich-text fields is kept | ✔ | Lost when publishing from Excel | HTML tags in the export |
| Tree queries and parents | ✔ (Pro) | ✔ | Parent ID only |
| Sort, filter, paste blocks | ✔ | ✔ (Excel) | ✔ (Excel) |
| Test case steps, one row per step | ✔ | – | ✔ |
Based on the reviews and Q&A of “Azure DevOps Open in Excel” on the Visual Studio Marketplace and Microsoft's documentation of CSV import (September 2026).
Pricing
One license for your whole organization, for all projects. Every paid tier includes all Pro features; the tiers differ only in the number of users.
Free
- The grid, validation, sort and filter, paste and undo
- Multi-cell selection, fill down and rollups
- Export to Excel
- Publish changes to 25 different work items per organization per month
Team
2 months free, or $12 per month
- Up to 25 users
- All Pro features
Business
2 months free, or $29 per month
- Up to 100 users
- All Pro features
Enterprise
invoice or purchase order on request
- Unlimited users
- All Pro features
Users are the people in your organization who use the extension. Pick the tier that fits; we don't count or track users. Using Azure DevOps Server (on-premises)? A license covers one project collection; see Azure DevOps Server.
Free vs Pro
| Free | Pro | |
|---|---|---|
| The grid, validation, sort and filter, paste, undo and redo | ✔ | ✔ |
| Excel-like keyboard navigation | ✔ | ✔ |
| Select cells, Ctrl+D and fill handle, count and sum, rollups in the tree | ✔ | ✔ |
| Queries across projects | ✔ | ✔ |
| Test case steps: read and export | ✔ | ✔ |
| Export to Excel | ✔ | ✔ |
| Tags page: counts, search, sort, unused-only filter | ✔ | ✔ |
| Work items you can publish changes to, per organization per month | 25 | Unlimited |
| Import from Excel | – | ✔ |
| Create work items and children | – | ✔ |
| Change parents | – | ✔ |
| Edit and import test case steps | – | ✔ |
| Rename, merge and delete tags | – | ✔ |
| Users in your organization | Any number | Per tier: 25, 100 or unlimited |
Try before you buy: every organization gets a 14-day Pro trial automatically when the extension is first used. Prices exclude VAT/sales tax, which is added at checkout where applicable; businesses can enter their VAT ID. Payments are processed by Lemon Squeezy, our Merchant of Record, which sends the invoice. Need a purchase order or several organizations on one invoice? Email support@jr-devtools.com.
Get started
- An organization admin installs the extension from the Marketplace. Project Collection Administrators can install directly; other users can request it.
- On the Queries page, open the ⋮ menu above the results and select Open in Bulk Editor, or select work items in a backlog or query and choose Open in Bulk Editor from the context menu. You can also open Boards → Bulk Editor directly.
- Edit, review the highlighted changes and select Publish.
- After buying Pro, an admin enters the license key under Organization settings → Extensions → Bulk Editor.
Permissions and security
- Your work items stay in Azure DevOps. The extension runs in your browser and only calls your organization's Azure DevOps REST API. Excel files are created and read in your browser. There is no analytics or telemetry.
- The only external call is the license check with Lemon Squeezy (about once a week). It sends the license key and your organization name and ID, never work item data. See the privacy policy.
- Why it asks for Work items (read and write): to read the work items you open and to save the
changes you publish (
vso.work_write). No access to code, builds or pipelines. - It acts as the signed-in user and can't do more than that user is allowed to: area paths, field rules and state transitions are enforced by Azure DevOps itself. Every change is a normal work item revision in that user's name, so the history shows who changed what.
More detail, including how to check the network calls yourself: Security.
Frequently asked questions
Azure DevOps can already edit several work items at once. Why this?
The built-in bulk edit sets the same value on every selected work item. The grid lets every row have its own value: re-estimate a sprint, reassign a backlog or rename twenty items in one pass, or paste a whole column from Excel, and review everything before you publish.
Does every user need a license?
No. One license covers the whole Azure DevOps organization and all its projects; its tier sets how many people may use it (25, 100 or unlimited). Anyone who can edit work items can use it; what they can change is decided by their own Azure DevOps permissions, exactly as in the work item form.
Where are my drafts and settings stored?
Unpublished changes stay in your browser's local storage until you publish or discard them (at most 7 days). The license, trial date and free-plan counter are stored in your organization's own extension data storage. Nothing is sent to us; see the privacy policy.
Which Azure DevOps versions are supported?
Azure DevOps Services (dev.azure.com), and Azure DevOps Server 2022 or later (on-premises). Older versions (2020, 2019, TFS) are not supported. See Azure DevOps Server for install steps and licensing.
What counts as a work item on the free plan?
Each different work item you publish a change to counts once per calendar month; changing the same item again in the same month doesn't count twice. Opening, sorting, filtering and exporting don't count. After 25 work items, you can still open, export and publish work items already counted this month; changes to other work items wait for Pro or the next month.
What happens when the trial ends or we stop paying?
The organization falls back to the free plan. Nothing breaks, and changes you published stay as they are. You can buy Pro at any time to continue.
Does it work with our custom fields and process?
Yes. Fields, pick lists, required fields and states are read from your process, including inherited processes.
Can I edit work items from several projects?
Yes. Open a query without a project filter, or a saved query with Query across projects, and every row is checked against the rules, states and area and iteration paths of its own project and published to that project. New work items are created in the project you opened the Bulk Editor from.
Can I edit test case steps?
Yes. Test Case rows get a Steps column; open it to see the steps as a table of action and expected result. With Pro you can add, remove, move and change steps and publish them with your other edits. In the Excel export every step gets its own row (Test Step, Step Action, Step Expected), the same layout as the Azure Test Plans export, and the import reads that back. Steps with formatting and shared steps are shown but never rewritten, and step ids stay the same, so attachments keep pointing at the right step.
Can I rename, merge or delete tags?
Yes, with Pro. Azure DevOps can't do this in its web UI, but the Tags page under Boards can: rename a tag, merge one into another, or delete tags you no longer use. Tags are shared with pull request labels, so renaming, merging or deleting a tag changes those labels too; the page warns you before you confirm. On the free plan the page shows every tag with its work item count, with search, sorting and an unused-only filter.
What if we make a mistake in a bulk change?
Before publishing: Undo, or Discard. After publishing: every change is a normal revision, visible in the work item history.
What are the known limitations?
- Formatted rich text is read-only in the grid (plain descriptions can be edited).
- State changes follow your process rules: a transition your process doesn't allow is refused and shown on that row.
- Test case steps are edited as plain text: steps with formatting and shared steps are read-only, and attachments on steps aren't shown.
- Rollups add up the children that are in the grid; the Excel export contains the field values, not the sums.
- Links other than parent/child (related, predecessor/successor, …) are not edited in the grid.
- Up to 5,000 work items per grid.
Is it still maintained?
Yes. See the release notes for what changed recently. Questions and bug reports get an answer within 2 business days; see the support policy.
What if JR DevTools stops?
Your work items and settings live in Azure DevOps, so there is nothing to migrate. If development of the extensions ever stops, they will be made open source and handed over to another maintainer, so your team can keep using them.
Guides
- How to edit multiple work items at once in Azure DevOps
- How to bulk edit Azure DevOps work items without Excel
- How to move child work items to the next sprint in Azure DevOps
- Azure DevOps Excel add-in not working: fixes
- Azure DevOps work items in Excel on a Mac
- Azure DevOps Open in Excel alternatives (2026)
About
Built and supported by JR DevTools, a software company in the Netherlands (EU) that also makes Merge Conflict Resolver. Questions are answered within 2 business days: support@jr-devtools.com.