Export Azure Boards Work Items to Excel

Create a workbook people can sort and edit without losing the metadata needed for a safe return trip.

Start from a bounded query

Use a saved query or a clear project, area, iteration, state, or work-item-type boundary. Export only fields needed by the review, but always retain work item ID and revision.

Preserve types and identities

  1. Write dates as Excel dates and numbers as numbers.
  2. Keep reference names and IDs where an import must resolve users or relations.
  3. Record the Azure DevOps revision for conflict detection.
  4. Keep choice values exactly as the process defines them.

Make the workbook reviewable

Use a table with frozen headers and filters. Put instructions and validation results away from the raw data table. Before sharing, remove fields reviewers should not edit and confirm the workbook contains no unnecessary sensitive data.

Export a typed workbook in Azure DevOps

Excel Import & Export for Azure Boards creates an editable workbook and retains the metadata required for validated re-import.

See Excel Import & Export for Azure Boards