Forum Discussion

Hamzah789's avatar
Hamzah789
Copper Contributor
Oct 31, 2023

azure devops work item duplicates when inserting csv

I am moving from one ADO Board to another. So I have downloaded the CSV from the old board via queries and tried uploading. For all items which arent 'New' I have to manually edit which I have accepted will be a manual effort. The main problem is for every workitem which is 'new' and doesn't have an error duplicates itself. This is the same case for all 'new' work items. Sometimes it can be duplicated 8 times. How do I stop the duplicates

 

1 Reply

  • Hi, this usually happens when Azure DevOps treats each CSV row as a new work item instead of an update to an existing one. If you are importing into another project or board, make sure the CSV does not accidentally contain repeated rows, and be very careful with the ID field because work item IDs are not portable between projects. For migrations, I’d use the Azure DevOps Migration Tools or REST API instead of CSV if you need to preserve hierarchy and avoid duplicates. CSV import is okay for simple new items, but it is not great for full board migration.