If you have defects exported from an external system in an Excel file, you can import the file into qTest.
Importing New Defects
Drag available fields and drop to map to corresponding qTest's Defect fields
Click Import button to finish
- Access tab Defects.
- Select Import Excel Beta icon from toolbar.
- Import Defect Wizard Beta pops up.
- Download Sample Import Template to refer to standard format for the best Import Defects
- Drag and drop or select the excel files from a folder to import. The selected file can be in .xls or .xlsx format.
Import Defect Wizard Pop-up
- Check on "Use imported file's first row as header" to let qTest use the first row of your excel file as header. qTest will get the file's header as available fields for mapping.
Mapping with File's Header
Import Defect Wizard Pop-up for Mapping
- When you perform an import, a single stream of emails might be sent out upon notification settings. To prevent any confusion, the email notifications are disabled for the action by default but they can be activated if needed by ticking on option Send out notification emails.
Important Business Rules for Import New Defects:
- You can only map 1 column in excel file to 1 qTest's field.
- DO NOT map Defect ID for importing new Defects. System will automatically generate unique IDs for new Defects.
- qTest's required fields must be mapped to a column in Excel file. If columns mapped to required fields contain no value, system will generate error message indicating an unsuccessful import.
- qTest's non-required fields can be left blank without mapping. If columns mapped to non-required fields contain no value, those fields will be imported into qTest with either blank data or default values you define in your project's Field Settings.
Importing to Update existing Defects
You can export Defects from qTest into Excel file, edit and import back to qTest to update existing ones.
The process is similar to import new Defects from an excel file. You will need to map Defect ID field.