JR DevTools logoJR DevTools

Azure DevOps CSV import checker

Paste or open a CSV before you import it into Azure Boards (Boards > Queries > Import work items) or Test Plans. The checker lists the problems that make the import fail or silently drop values, per row and column. Free, no sign-in, nothing uploaded.

Your file never leaves your browser. Nothing is uploaded. The checker runs as a script on this page and makes no network requests with your data.

What it checks

The checker reads the file the way a CSV parser does and then looks at the values. It does not change your file.

The file itself

Boards: Import work items

Test Plans: Import test cases

Values in both

What it can't check

The checker doesn't know your process, your area and iteration paths, your users, or the allowed values of your pick lists. Azure DevOps validates those when it saves the work item. A file without findings can therefore still be refused, so try a few rows in a test project first.

Minimal CSV that works

Boards: new work items with a hierarchy. The ID is empty, the type is on every row, and each child title is one column to the right of its parent, on the row below it.

ID,Work Item Type,Title 1,Title 2
,Epic,Online checkout,
,Feature,,Pay by card
,Feature,,Pay by invoice

Test Plans: new test cases with one row per step. The title is on the first row of a test case.

ID,Work Item Type,Title,Test Step,Step Action,Step Expected
,Test Case,Sign in with a valid account,1,Open the sign-in page,The page shows the form
,,,2,Enter a valid user name and password,The Sign in button is enabled
,,,3,Select Sign in,The dashboard is shown

Sources

Import from Excel without the CSV round trip: Bulk Editor validates values against your process before publishing, and shows the reason per row.
Install from the Marketplace See how it works
Not affiliated with Microsoft. “Azure DevOps” and “Excel” are trademarks of Microsoft. Questions? Email support@jr-devtools.com.