I'm using the "Teams" tab provided by MS in Excel to add repeating Azure DevOps User Stories (US), i.e. work that needs to be done every sprint (don't ask). This seems to be the recommended approach to bulk add work items to Azure DevOps.
The US all belong under a single Feature and they have a couple of tasks each.
I use a tree hierarchy in the Excel file, with US at the top level and Task at the secondary level. This works fine, except that I can't place the new US under the desired Feature in any way. When I publish they end up unparented.
If I add the Parent column, I can see existing parent ID's for those US that are already assigned a parent. But this column is read only, so I can't use it to actually place a new US under the desired parent Feature.
If I add a third level to the Excel file, for the parent Feature level, I can of course place the new US under the desired parent Feature. But in this case I end up with all the old closed US in the Excel file, and I can't seem to find a way to hide them. These will soon count in hundreds, so this is not nice.
Is there any way that I can assign the new US to the desired parent Feature in Excel, without having to see the old closed US under the same parent Feature (and their tasks)?