Skip to main content

Export

QA Sphere allows exporting test case library in CSV (Comma-Separated Values) format. To do that:

  1. Open a project and go to Test Cases tab
  2. Click three dots
  3. Select Export

A new CSV file with the project abbreviation in the name will be saved under the browser's downloads.

The structure of the exported CSV file columns are as follows:

  • Folder
  • Name (Title of the test case)
  • Legacy ID
  • Draft (whether the test case is a draft or not)
  • Priority
  • Tags (comma-separated)
  • Requirements (comma-separated, in format "text")
  • Links (comma-separated, in format "text")
  • Files (JSON string containing file information)
  • Preconditions

After these static columns, there are dynamic columns for steps:

Step1, Expected1 Step2, Expected2 ... (and so on, depending on the maximum number of steps in any test case)

The number of "Step" and "Expected" columns is determined by the test case with the most steps. All other rows are padded with empty values to match this maximum. The rows are sorted first by the Folder name, and then by the test case Title within each folder.

HTML content in preconditions and steps is attempted to be converted to Markdown format for better readability in the CSV.

This structure allows for a comprehensive export of test cases, including their hierarchical organization (folders), metadata (tags, priority, etc.), and detailed step information. The use of CSV format makes it easy to import into various spreadsheet applications or other systems that can parse CSV data.