QMetry allows users to import test cases from an Excel file to create new test cases as well as to make changes in existing test cases in QMetry.

QMetry supports the seamless import of Excel files with multiple sheets. The import can create a new folder per sheet name and import the test cases accordingly. For example, there are 30 sheets in an Excel file with test cases on each of the sheets. The import will create 30 folders as per the Excel sheet names and import test cases into them if the Create folder with sheet name option is selected before starting the import.

Two separate Test Case templates are available to download and set your test case data within the corresponding template file:

• Test Case with Test Steps in Single Row
• Test Case with Test Steps in Multiple Rows (steps in individual rows)
  

The import wizard helps users import test cases directly into particular folders/sub-folders of the Test Case modules under the current project.

The test cases are imported in the same order that of in the Excel file, following are some of the reasons behind it.

1. In the organization test cases are ordered to produce the most efficient test flow. Hence, the QA Manager wants that the test case import order match the excel sheet.

2. A user creates a series of test cases in a logical order to be tested, one after another- and after creating those test cases the users want to import the excel file with the test cases in the same order as they are found in the excel file allowing them to be easily added to a test suite in the same order.

Best Practice: To carry out the import process smoothly, it is recommended that the size of file you upload should be maximum of 10 MB.