Issue with Importing New Test Cases into Azure DevOps: "Invalid Workitem Field Values Found" Error

Question

I am facing challenges importing test cases into Azure DevOps using CSV or XLSX files. I have imported the test cases using the following columns and received the error: “Error occurred while importing one or more test cases: Invalid workitem field values found."

 

ID          

Work Item Type              

Title      

Test Step            

Step Action       

Step Expected 

State

Answer 1

Hi GOWTHAM DURAISAMY

Ensure the field Work Item Type is set to Test Case (case-sensitive). If it's blank or mismatched, Azure DevOps won't process it.

Also, remove the ID column.

Steps to Follow:

1. Go to Azure DevOps -> Azure Boards -> Work Items -> New Work Item -> Test Case -> Create Test Case by adding the required details: State, Under Steps Section - Steps, Action, Expected Result and then save it.
2. Click on Column Options and adjust as shown in the screenshot below:
3. Then Click on Open in Queries -> Click on 3 dots -> Export to CSV. Open Excel file and remove the ID column and update the excel with the columns of Test Step, Step Action, Step Expected, State in the below format as shown in the screenshot and save the file.
4. Now Go to Test Plans -> Click New Test Plan -> Click on Import Option -> Choose the excel csv file -> Select Import.

Hope this helps!

Please Let me know if you have any queries.

If you found the information helpful, please click "Upvote" on the post to let us know and consider accepting the answer as the token of appreciation. Thank You.