pytest-excel

What it is and what it does

pytest-excel is a pytest plugin that captures test execution results and writes them to Excel (.xls) files. It integrates directly into pytest's test collection and execution pipeline, allowing you to generate structured reports without modifying your test code. The plugin depends on openpyxl for Excel file creation and pandas for data handling.

You invoke it by passing --excelreport=filename.xls to pytest; it supports verbose output (one test per line) and test collection-only mode (--collect-only) to document test structure without running them. Timestamp-based filenames are also supported via strftime formatting in the filename argument.

Use it for:

• Generate Excel test reports for stakeholders who prefer spreadsheet formats over terminal output.
• Archive test results over time in a structured format for trend analysis and regression tracking.
• Export test documentation by running pytest with --collect-only to list all tests in a workbook.
• Integrate test reporting into CI/CD pipelines where Excel files are ingested by downstream tools.
• Create timestamped test reports automatically for each test run without manual file management.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

A pytest plugin that generates Excel reports from test execution results, capturing test outcomes and metadata into .xls files with optional verbose formatting.

Yes. The plugin is actively maintained, has no known vulnerabilities, low install friction, and a clear use case for teams that need Excel-formatted test reports. Install it if your workflow or stakeholders require test results in spreadsheet form; skip it if terminal or JSON reporting suffices.

Install

pytest-excel on PyPI

pip install pytest-excel

uv add pytest-excel

poetry add pytest-excel

Installing pytest-excel

Before you install

Low friction install with three straightforward runtime dependencies. Actively maintained as of 2026-04-14, marked Production/Stable, and supports current Python versions (3.11+).

License in practice

MIT license permits unrestricted use, modification, and distribution in both open and closed projects with minimal obligations.

Quickstart

pip install pytest-excel openpyxl

Then run tests with:
py.test --excelreport=report.xls

For verbose output:
py.test --verbose --excelreport=report.xls

Requires Python 3.11 or above; openpyxl must be installed alongside pytest-excel.

Verify before relying

• Whether the plugin handles test parameterization and fixtures in the Excel output.
• Performance characteristics with large test suites (thousands of tests).
• Compatibility with pytest plugins that also modify test reporting.

Package facts

Evidence: pytest_excel-1.8.1-py3-none-any.whl

Keywords: excel, pytest, report

Tags

More Utilities packages