#Import & Export Test Cases – Excel Guide
Hawzu allows you to import test cases from Excel files and export test cases to multiple formats. This helps with bulk creation, migration from other tools, backups, and offline analysis.
Import and export actions are available directly from the Repository.
#Exporting Test Cases
Hawzu supports the following export formats:
Excel (.xlsx)
- Best for editing, reporting, and reviews
- Preserves test case structure
- Easy to share with non-technical stakeholders
CSV (.csv)
- Lightweight and widely supported
- Useful for basic analysis
- Limited formatting
JSON (.json)
- Machine-readable format
- Suitable for integrations and migrations
- Preserves full test case structure and metadata
#Exporting Selected Test Cases
To export selected test cases:
- Select one or more test cases in the Repository
- Click the Export icon in the bulk actions bar
- Choose the required export format
As a result:
- A file is downloaded immediately
- The export contains only the selected test cases
- File names include timestamps for easy tracking
#Exporting All Test Cases
To export all test cases in the current view:
- Use
Ctrl + A (or Cmd + A on macOS) to select all visible test cases
- Click Export
- Choose the desired format
Note
Exports respect the current folder and filter context.
#What Gets Exported
Exported data includes:
- Test case title and description
- Folder information
- Priority, severity, test type, automation status
- Preconditions and test steps
- Expected results
- Tags and linked requirements
- Custom fields
- Created and updated metadata
#Importing Test Cases from Excel
Hawzu supports importing test cases using Excel files for bulk creation or migration.
#Importing from Excel
To import test cases:
- Open the Repository
- Click Import Testcases in the header
- Upload an Excel file (
.xlsx or .xls)
- Review the import preview
- Start the import
Imported test cases appear in the repository once processing is complete.
#Excel File Expectations
When preparing an Excel file:
- Each row represents a test case or a test step (depending on structure)
- Column names should match test case fields where possible
- Custom fields must match configured project custom fields
- Empty or invalid rows are skipped during import
Hawzu supports:
- Multiple test steps
- Preconditions
- Gherkin scenarios
- Tags and requirements
- Custom fields
Tip
Use a small sample import first to validate structure before importing large files.
#Import Validation
During import, Hawzu validates:
- Required fields (such as test case title)
- Field values (priority, severity, type, etc.)
- Custom field compatibility
- File format and structure
If errors are found:
- Invalid rows are highlighted
- Valid rows continue to import
- A summary is shown after completion
#Common Use Cases
#Bulk Test Case Creation
Create dozens or hundreds of test cases at once using Excel instead of manual entry.
Export test cases from another tool, adjust formatting, and import into Hawzu.
#Backup & Restore
Regular exports act as offline backups that can be re-imported if needed.
#Reporting & Analysis
Export to Excel or CSV for reporting, metrics, and audits.
#Best Practices
#Export
- Export before large deletions or changes
- Use filters to export only what you need
- Store backups securely with versioning
#Import
- Clean data before importing
- Avoid merged cells
- Keep column names consistent
- Import in smaller batches for large datasets
- Review imported test cases after completion
#Permissions
Import and export permissions depend on project roles:
- Project Manager – Full import and export access
- Project Coordinator – Import and export access
- Project Member – Export access only
- Project Viewer – Read-only export access
Custom roles may further restrict or allow import/export actions.
#File Size Considerations
- Large Excel files may take longer to process
- For very large datasets:
- Split imports into smaller files
- Use JSON exports for migrations
- Apply filters before exporting
#Next Steps