Export custom Zephyr Excel reports

Better Excel Exporter is tightly integrated with Zephyr, the most popular test management app for Jira. Zephyr tests are "first-class citizens" in the Excel exports, meaning that similarly to Jira issues, you can export all test-related information to Excel. It includes test case details (fields, attachments, comments, etc.), test steps, test executions and detailed step results during an execution.

Of course, you can use all the Excel features, from functions and formulas to pivot tables and pivot charts, on Zephyr data. With those, you can implement literally any type of Zephyr test report.

Next steps

Export samples

Zephyr test steps

Zephyr test cases are Jira issues of the "Test" type. This export example generated from the issue-navigator-with-test-steps.xlsx Excel template shows a mix of regular issue fields in the left (key, summary, priority) and Zephyr test step details in the right (instructions, test data, expected result).

jira-zephyr-test-steps.xlsx

Zephyr test executions

Export Zephyr test execution reports to Excel easily! Run a JQL search in Jira to find any arbitrary set of Zephyr tests, then generate a filterable, searchable, shareable, grouped list of their test executions.

jira-zephyr-test-executions.xlsx

Zephyr test step results

This highly detailed Excel export captures the Zephyr test results in three logical levels: tests, test executions for each test, and test step results for each test execution. Being a complete snapshot of testing data, you can search this, import this to external systems, use it for archiving purposes, etc.

jira-zephyr-test-step-results.xlsx

Zephyr test report

You can also export custom Excel reports from Zephyr test data. The zephyr-report.xlsx template gives a valuable overview of test executions per version, test cycle and tester, shows the test execution history, and shows which tests and executions discover the most defects. Build your own Zephyr Excel reports by copying this template.

jira-zephyr-report.xlsx