Skip to content
Hawzu Docs

Import & Export Test Cases – Excel Guide

3 min read

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

Section titled “Exporting Test Cases”

Supported Export Formats

Section titled “Supported Export Formats”

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

Section titled “Exporting Selected Test Cases”

To export selected test cases:

  1. Select one or more test cases in the Repository
  2. Click the Export icon in the bulk actions bar
  3. 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

Section titled “Exporting All Test Cases”

To export all test cases in the current view:

  1. Use Ctrl + A (or Cmd + A on macOS) to select all visible test cases
  2. Click Export
  3. Choose the desired format

Note
Exports respect the current folder and filter context.

What Gets Exported

Section titled “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

Section titled “Importing Test Cases from Excel”

Hawzu supports importing test cases using Excel files for bulk creation or migration.

Importing from Excel

Section titled “Importing from Excel”

To import test cases:

  1. Open the Repository
  2. Click Import Testcases in the header
  3. Upload an Excel file (.xlsx or .xls)
  4. Review the import preview
  5. Start the import

Imported test cases appear in the repository once processing is complete.

Excel File Expectations

Section titled “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

Section titled “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

Section titled “Common Use Cases”

Bulk Test Case Creation

Section titled “Bulk Test Case Creation”

Create dozens or hundreds of test cases at once using Excel instead of manual entry.

Migration from Other Tools

Section titled “Migration from Other Tools”

Export test cases from another tool, adjust formatting, and import into Hawzu.

Backup & Restore

Section titled “Backup & Restore”

Regular exports act as offline backups that can be re-imported if needed.

Reporting & Analysis

Section titled “Reporting & Analysis”

Export to Excel or CSV for reporting, metrics, and audits.

Best Practices

Section titled “Best Practices”

Export

Section titled “Export”
  • Export before large deletions or changes
  • Use filters to export only what you need
  • Store backups securely with versioning

Import

Section titled “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

Section titled “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

Section titled “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

Section titled “Next Steps”