Importing Test Cases Using Excel Import


In qTest Manager, you can import test cases from an Excel spreadsheet to create new test cases as well as to make changes to existing test cases. While there is an Example Sample Template,  any column value can be mapped to a custom field within qTest Manager, as long as the test cases and steps are individual rows. Our import wizard provides the ability to import test cases directly into specific modules by altering the Excel file's individual sheet names to align to the modules within qTest Manager. 

Importing Test Cases

Importing Test Cases from Excel consists of the following steps: 

  1. Download the Sample Import Template.
  2. Fill out Test Case information on the Sample Import Template inside Excel.
  3. Adjust Field settings as needed in qTest Manager.  
  4. Import the Excel file to qTest Manager.

Download Sample Import Template

To import Test Cases from the Sample Import Template, perform the following steps: 

  1. Select Test Design, and then select your project.
  2. Select the Import Excel icon in the navigation panel.

  3. The "Import Test Case Wizard" dialog displays. Select the Sample Import Template hyperlink.

Fill Out Sample Import Template Inside Excel

  1. Fill out the Sample Import template by entering the Name, Type, Status, and Description of the test case.  If you wish, you can create custom fields on the spreadsheet. Save the Excel file.
  2. Make sure the field values on the spreadsheet match the available values in qTest Manager. If the values do not match, you must add the values for these fields in Field Settings within qTest Manager.  For additional information, refer to the ‘Modify System Field’ user guide. Similarly, if any columns in the spreadsheet represent a field that does not exist in Field Settings, you must first create the custom field in qTest Manager and assign the values for the field (if the field is a combo-box field type) so the import runs smoothly.  For more information, see the ‘Add Custom Field’ article. 

    If you plan to report on these custom fields using qTest Insights, make sure to make the field settings changes at the Site Level and not the Project Level. Custom fields added at the Project level cannot be reported on within qTest Insights. For information on Site-level field changes, please refer to our Site Fields Article.

    Hint: If you are uploading data to a multiple selection combo box or a checkbox field, you can include multiple values by separating each value with a comma: 1,2,3,4. Do not include spaces between the values.

Adjust Field Settings As Needed 

In the following example, the Type field in qTest Manager has four existing values in qTest Manager: Manual, Automation, Performance, and Scenario.   

The Excel spreadsheet shown below contains two test cases. In Test Case 003 the value ‘Manual’ for the Type field matches an existing value for this field in qTest Manager.  However, in Test Case 004, the value ‘New Value’ for the Type field does not match an existing value for this field in qTest Manager.

Add Custom Field s for Your Test Case in qTest Manager

  1. Select the Settings icon and then select Field Settings .
  2. The Edit System Field Page displays. Select Test Case in the artifacts panel.
  3. Select Type in the "Display Name" column. 
  4. Select Add Value and add a value called ‘New Value’ for the Type field.  Then, click the OK button.


Import Excel File to qTest Manager

After you have modified any existing system fields or added any new custom fields in Field Settings in qTest Manager, perform the following steps to import the Excel file to qTest Manager:

  1. Select Test Design in qTest Manager. The Test Design page displays.
  2. Select your Project.  
  3. Select the Import Excel icon, located in the navigation panel.

  4. The "Import Test Case Wizard" dialog displays. To use your own custom spreadsheet, drag and drop your file into the file upload box or select the click here to pick from a folder link.

    HINT:  If you want to import the test cases into an existing folder, then before importing, make sure to update the Excel sheet’s name to match the existing folder, using the syntax: MD - ## and the Folder name.  As shown in the screenshot below, the syntax MD-27 is located next to the folder name Existing Folder in test design.  

    n this example, the spreadsheet’s sheet name has been updated below to be called MD-27 Existing Folder so the test cases will be imported into this folder.

    you do not wish to import the test cases into an existing folder, leave the sheet name empty and the import process will create a new folder.

  5. When an Excel file is being uploaded, a loading icon will be shown that when hovered over will advise: "The file is being scanned for virus and malware before being processed." Upon clicking the Next button: "Imported file(s) are being scanned for virus and malware. Please wait until the scanning process is done to proceed."

    When the imported file is scanned successfully and is "clean", you can proceed to the mapping step. If the imported file is scanned successfully and is "infected", the file name will show as: (Infected) filename.xls.

    Upon clicking the Next button, a message will display: "Some of the imported file(s) are found virus or malware infected and cannot be processed. Please remove the infected file(s) to proceed." If multiple files are being imported and at least one of them is "infected", you will be unable to import any of the files until the infected ones are removed.

     If the imported file fails to be scanned, an error message will display and the import process will stop: "The file cannot be scanned for virus or malware at the moment. Please try again later."

  6. Select NextThe Import Test Case Wizard redisplays.  The fields in the ‘Available fields for mapping’ area at the top of the screen are the fields in the Excel spreadsheet.  The fields in the ‘qTest’s Test Case Fields area in the left column of the screen are the fields in Field Settings in qTest Manager.  
  7. To perform the field mapping, drag and drop each column name from the ‘Available fields for mapping’ area to the ‘Imported Spreadsheet’s Columns’ in the right column, to the right of the corresponding qTest Test Case field.  

    IMPORTANT: Do not map the Test Case ID. qTest Manager will auto-generate this value.   

    HINT: The Excel column name and corresponding qTest field name do not have to match. For example, if the Excel column is called ‘Test Case Status’ and the qTest field is called Status, that’s fine.

  8. Select Import.

    The following screenshot shows the newly created folder with the uploaded test cases and the test cases we imported into our existing folder.  

Modify Existing Test Cases Using Excel Import

You can upload changes to test cases that currently exist in qTest Manager by using an Excel import. To do this, export the test cases to Excel.  Then, edit the file in Excel and import the file to qTest Manager to update existing test cases.  This functionality enables you to upload all updates at one time, rather than modify one test case at a time in the qTest Manager interface.  

When importing information in an Excel spreadsheet to update an existing test case, make sure the spreadsheet contains the Test Case ID so that qTest Manager updates the correct object.  The process is similar to importing new test cases from an Excel file only there are some rules to keep in mind.

  1. An easy way to start is to export the Test Case Detail report from the top of the left navigation panel in Test Design. Update the content in Excel and save the changes in Excel before importing the updated file into Test Design.

  2. When importing information from an Excel spreadsheet to update an existing test case, you must map the exact Test Case IDs to indicate which test cases you are updating. The Test Case ID is displayed in an individual test case at the top of the page, as shown in the following screenshot. 

    The Test Case ID and Module ID can also be displayed in front of the test case name in the left panel by selecting the Toggle IDs display icon (the top right icon in the left panel). Select the Test Cases and Modules checkbox from the dialog. The ID appears in front of the Test Case name in the left panel.   

The Excel sheet name you are importing must include the Test Case ID and Folder Name and must not exceed 31 characters.  Use the form Test Case ID space Folder Name as your sheet name. For example: MD-23 Login Process.

IMPORTANT: If you do not map Test Case IDs, but rename the Excel sheet by Module ID + Name, you will add new Test Cases into existing Modules. If you map Test Case ID's with an incorrectly mapped Module ID/Name in the Excel sheet name, qTest Manager will generate an invalid Test Case ID Value error, and the import will fail. 

Powered by Zendesk