Import from Excel

Import new test assets or re-import previously exported assets from Excel directly into QMetry.

Note

You need Modify rights in the target project to import.

The following table describes the difference between Import and Re-import.

Table 13. Import vs Re-import

Sr. No

Component

Import

Re-Import

1

Definition

Import is the creation of test assets for the first time.

Import always creates version 1.

Re-import is a bulk modification of already created test assets. This simplifies bulk editing.

Re-importing increases the existing version by 1.

2

Supported Formats

XLS, CSV, XLSX

XLS, CSV, XLSX

3

What can be imported?

  • Requirement

  • Test Cases

  • Issues

  • Requirements

  • Test Cases

  • Test Suites - Only Execution Status

4

Mandatory Mapping

  • Summary and all mandatory fields.

  • Map folder paths if you need the assets organized in separate folders.

  • Unmapped fields remain empty.

  • Map Entity Key with ID.

  • Summary and all mandatory fields.

  • Map folder paths only if there are changes to the folder path, or if you want to move assets.

  • Unmapped fields are picked from the previous version of the corresponding test asset.



Also Explore

Importing Requirements

Importing Test Cases

Importing Test Suites

Importing Test Executions

Importing Issues from Excel

Publication date: