How to import or load Test cases in Microsoft Test Manager (MTM) or Azure DevOps

Step by step process to Load Test Cases

Step#1: Login or access Azure DevOps portal

Step#2: Search for the project in the home page

Step#3: Click on the project name and then project will be opened

Step#4: Click on the Test Plan from the left side menu, then you could see the some options under the Test plan

Step#5: From the options, Click on the Test plan

Step#6: click on the test plan name, where should test cases be loaded

Step#7: Test plan will be opened and inside that create a folder if not already created

Step#8: If you want to create sub folder under that you can create if not click on the folder and right side you will see the blank space and with tabs like Define, Execute.. In this click on Define

Step#9: Click on the Down arrow button, this will be right side in the same line of the tab Define

Step#10: Once you clicked, You could see the import screen at right side of your screen

Step#11: Click on the import file and select the right file and clikc on open

Step#12: Click on Import

You could see the loading percentage on the screen, once done message will be appeared how many test cases updated and how many loaded

File format and important points to be noted

1. File should be .csv file

2. There are some mandatory columns - ID, Work Item Type, Title, Test Case Step, Step Action, Step Expected. these columns should be included in the .csv file

3. For loading new Test cases - for them ID should be blank, work Item Type - Test Case, Test Case Step - digits (1,2,3...etc)

4. For updating existing test case, we have to provide ID too

5. Format -> ID, Work Item Type, Title should be in one row and from next row only we have to give Test case Step, Step Action, Step Expected Example: