How to "Import" Test Cases from Excel Spreadsheet?

Step 1: Go to Test Case Module.

Step 2: Select the folder in which you want to import the spreadsheet containing test cases.

Step 3: Click on “Import from XLS” button.

Step 4: The content and format of the Excel Spreadsheet -

Scenario 1: Test case steps in single rows

  • All the steps & expected outcomes should be in in a single row.
  • If other excel columns are not in QMetry Mapping fields, then you have to create UDF (User defined fields) to import those values of column according the type of data i.e. string, custom list, description. (Please follow mapping step below)
  • How to write test steps in a single row? – Write 1st step then add Comma <,> then put space & then (Alt+Enter). You will switch to new line in the same row & move on likewise for adding further steps.
  • Same for expected outcomes.


Scenario 2: Test case steps in multiple rows

  • In excel sheet test steps should be in different rows.
  • Each row should contain single step, one by one from up to down as shown in below figure.


Step 5: Mapping of Spreadsheet columns and QMetry columns

  • This is mapping of excel sheet columns with QMetry already present fields.
  • If any of the column doesn’t have field in QMetry then add the UDF from Admin> Manage Fields>Add fields. Then map that column with that UDF.
  • Mark in red are Mandatory columns that should be mapped.
  • Auto Map functionality helpful when spreadsheet columns and QMetry columns names are exactly same, which map columns correctly.


Step 6: Selecting a Scope i.e. on domain level or release level or cycle level?


Step 7: Job scheduler to see Errors and success of import job.


Step 8: Check the folder in which import has taken place. With the successful message in Job Queue makes the imported test cases available in the folder. Partial data has not been imported in QMetry if this must has happened then QMetry gives parsing error which saves us to avoid mess up of data.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk