Export Test Cases to Excel

Export Bulk Test Cases to Excel

Users can export test cases created in QMetry for Jira to an Excel file. The latest version of test cases will be exported along with system and custom fields.

Use Cases:

  1. Users can export test cases, make changes in bulk and re-import them as a new version.

  2. Users can share test cases in an Excel file e.g. sharing with a third-party vendor who does not have access to QMetry.

You can -

A. Export Individual Test Cases to Excel

B. Export Test Case folder to Excel

A. Export Test Cases to Excel

Steps

The steps are described below.

1. Select the test cases you want to export to Excel.

You can select individual test cases or all test cases.  Select All has two options:

  • Select all records on the current page:

Clicking on the check box in the column header selects all the records on the current page only.

An alternate way is to open the check box drop-down and select Current Page.

  • Select records across all pages:

Open the check box drop-down and select the Across All Pages option.

Note: Maximum 1000 test cases can be selected at a time.

 

 

The options for Bulk Operation start displaying on the screen on the selection of test case(s).

2. Open the Export To drop-down and select Export to Excel.

 

 

B. Export Test Case folder to Excel

You can export all the test cases of a particular folder/root folder to Excel. Select the test case folder and right-click on Export to Excel.

When a parent folder is exported, the test cases at the parent folder level will get exported. Test Cases beneath the subfolders will not get exported.

Export test case operation gets started in the background.

3. Open the Notification section to view background processes.

 

4. To download the excel file, click on the Download File link.

Note: The file will be available to download for 24 hours.

Export a Single Test Case to Excel

Users can export test case details to an Excel file.

Note: Only the latest version of a test case can be exported. The export icon will not be visible for the older versions of the test case.

Steps

1. Open the test case detail page.

2. Click on the Export icon at the top.

 

Check the background process and download the file.