Import Excel Updates into Azure Boards Safely

Use an export designed for re-import

The workbook must retain work item ID, revision, and supported field names. Do not match work items by title: titles change and are not unique.

Validate every row

1. Confirm the work item exists and the connected user can edit it.
2. Check required fields, allowed states, choice values, identities, and dates.
3. Compare the exported revision with the current Azure Boards revision.
4. Show the exact proposed changes without writing them.

A revision mismatch means the work item changed after export. Review that row instead of overwriting it.

Import in controlled batches

Apply a small representative batch, inspect the work items in Azure Boards, then continue. Report success and failure per row so one invalid change does not hide what happened to the rest.