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.

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.

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.

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

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

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.

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

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.

The following screenshot displays the imported information.