Export
QA Sphere allows exporting test case library in CSV (Comma-Separated Values) format. To do that:
- Open a project and go to Test Cases tab
- Click
- 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:
Static Columns:
- Folder: The complete folder path to the test case
- Type: The type of test case -
standalone
ortemplate
- Name: Title of the test case
- Legacy ID: Test case ID from previous test management system
- Draft: Whether the test case is a draft (
true
orfalse
) - Priority: Test case priority -
low
,medium
, orhigh
- Tags: Comma-separated tags
- Requirements: Comma-separated requirements in format
[Title](URL)
- Links: Comma-separated links in format
[Title](URL)
- Files: JSON array containing file information with properties:
fileName
,id
,url
,mimeType
,size
- Preconditions: Test case preconditions or description (in Markdown format)
- Parameter Values: JSON array for template test cases containing parameter sets
- Template Suffix Params: Comma-separated parameter names used in filled test case naming
Dynamic Columns:
After the static columns, there are dynamic columns for:
Steps
- Step 1, Expected 1
- Step 2, Expected 2
- ... (continues based on the maximum number of steps in any test case)
Custom Fields
Custom fields appear after step columns with the format:
custom_field_text_{systemName}
for text fieldscustom_field_dropdown_{systemName}
for dropdown fields
Custom field values are exported as JSON objects containing:
value
: The field valueisDefault
: Whether this is the default value (if applicable)
Export Format Details
Column Organization:
- The number of "Step" and "Expected" columns is determined by the test case with the most steps
- All rows are padded with empty values to match the maximum number of steps
- Custom field columns are included only if custom fields exist in the project
- Rows are sorted first by Folder name, then by test case Title within each folder
Data Formatting:
- HTML to Markdown: Content in preconditions and steps is converted to Markdown format
- Template Test Cases: Exported with their parameter values and template configuration
- File Attachments: Exported as JSON with complete metadata for re-import
- Custom Fields: Exported with their current values and default status
Template Test Cases in Export:
When exporting template test cases:
- The template definition is exported with
Type
set totemplate
- Parameter values are included in the
Parameter Values
column - Template suffix parameters are preserved for consistent naming on re-import
- Filled test cases generated from templates are exported separately as standalone test cases
This comprehensive structure allows for:
- Complete backup of test case libraries including custom fields and templates
- Migration between QA Sphere projects
- Integration with external tools that support CSV format
- Preservation of all test case metadata and relationships