qTest - Import Test Cases

A user can create multiple test cases at a time using the Excel spreadsheet. Excel files are text files represented by rows and columns as cells.

Rules for Excel file

While creating an Excel file, the following points must be considered −

  • The Excel file should have data in the first sheet only.

  • The sheet name should be the same as the module name, where test cases will be imported.

  • The first row should have the names of headers in different columns and the next onwards; data should be represented in columns.

  • Please note, the first row will be mapped with different fields of the Test Case Forms while importing.

  • One column in Excel file can be mapped with only one field in the test case form.

  • The test case ID field should not be mapped with any column. The system will automatically generate test case ID.

  • The required fields must be mapped with the column of Excel sheet and it should not be blank. Otherwise, the system will generate an error message of unsuccessful import.

  • The non-required fields can be left without mapping or data can be blank. While importing either, these fields will be blank or default values as defined in the project’s settings.

  • qTest supports the module’s name up to 500 characters, while Excel sheet supports only 31 characters’ length as the sheet name. Hence, make sure the Module’s name is not too long or expands more than 31 characters.

Following is a sample Excel sheet.

Pre-Condition Step # Step Description Expected Result Test Case Type Test Case Status Test Case Priority Test Case Assigned To Custom Field 1 (if any)
Pre-condition of the test case 1 1 Step 1 Step Expected Result 1
2 Step 2 Step Expected Result 2
3 Step 3 Step Expected Result 3
Pre-condition of the test case 2 1 Step 1 Step Expected Result 1
2 Step 2 Step Expected Result 2
n Step n Step Expected Result n
Pre-condition of the test case n 1 Step 1 Step Expected Result 1
2 Step 2 Step Expected Result 2
n Step n Step Expected Result n

Import an Excel File

Let us now discuss how to import an Excel file.

Step 1 − Go to the Test Design tab and select the root folder. The root folder will have the Project name.

Step 2 − Select the Import Excel icon from the toolbar just above the root folder. Following screenshot shows the Import Excel icon and the root folder selection in the Test Design tab.

Import Excel Icon

Step 3 − The Import Test Case Wizard opens up. It comes with a set of rules. Re-verify whether the Excel sheet fulfills those rules or not.

Step 4 − Browse the Excel file and upload. After successful upload, the filename displays in the Wizard as shown in the following screenshot.Check the box "Use imported file's first row as header". qTest uses the first row of Excel file as header. qTest will get the file's header as available fields for mapping.

Browse Excel File

The following screenshot shows the Available fields for mapping after the check box is selected.

Test Design Available Fields

If you do not select this option, qTest will get the column’s order as the available field mapping. Following screenshot displays the same.

Column Field Mapping

Step 5 − Using the drag and drop functionality, map the test case fields with the Excel sheet column name present at the Available fields for mapping as shown in the following screenshot.


Step 6 − To delete a mapped field, click on the X sign in the box. It will delete the field mapping and you can re-map the field with other column, if required.

Step 7 − By checking the Send out Notification emails checkbox, an email will be sent to import the test cases. Now, click Import as shown in the following screenshot.

Send Out Notification

Step 8 − On successful import, you will get the imported information as shown in the following screenshot.

Successful Import

A dialog box with three buttons appears as in the above screenshot −

  • OK − It will take you to the Test Design tab.

  • OK & Refresh − It will refresh the page and you will be able to see all imported information.

  • View Log − This lets you see the imported logs.

Import Test Case Log

The following screenshot displays the imported information.

Import Test Cases