---
id: pyxlsx
version: "1.1.3"
license: MIT
license_treatment: permissive
maintenance: dormant
---

# pyxlsx

License: permissive · Maintenance: dormant · Downloads: 230.7K/mo

## What it is and what it does

pyxlsx wraps openpyxl to provide a more intuitive, dictionary-oriented interface for working with Excel files. Instead of navigating cells by coordinate, you can append rows as dictionaries, access cell values by header name, and iterate over content rows as structured objects. It handles header row detection, automatic column discovery, and mixed access patterns (by column number or by header name).

The package is designed for straightforward read-write workflows: creating new spreadsheets, appending data rows, reading back structured content, and modifying cells. It abstracts away much of openpyxl's lower-level cell manipulation, making it suitable for data entry, simple ETL tasks, and spreadsheet-based data management where you want to treat rows like records.

Use it for:

- Append product inventory data to a spreadsheet by passing dictionaries with id, name, and price fields.
- Read an existing spreadsheet and iterate over rows as structured objects to extract or transform data.
- Build a simple data export tool that writes tabular data to Excel with automatic header generation.
- Modify cell values in a spreadsheet by row and column name without managing cell coordinates manually.
- Access adjacent cells (top, left, right, bottom) to implement spreadsheet-level logic or validation.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Provides dictionary-like read and write access to Excel worksheets through openpyxl, letting you treat spreadsheet rows as structured data objects.

Yes, if you need a lightweight dictionary-style interface to Excel files and are comfortable with a dormant package. The low install friction and permissive license make it a reasonable choice for simple spreadsheet tasks. However, be aware that maintenance is inactive—if you encounter bugs or need compatibility updates, you may need to fork or switch to openpyxl directly.

## Install

pip install pyxlsx
uv add pyxlsx
poetry add pyxlsx

## Installing pyxlsx

Before you install: Low friction install with only two runtime dependencies (openpyxl and pycel). However, the package is dormant—last release was 2020-07-21 and no commits since 2024-07-15, so maintenance is inactive.

License in practice: MIT license is permissive, allowing commercial and private use with minimal restrictions.

Quickstart:

pip install pyxlsx

from pyxlsx import new_xlsx, open_xlsx

with new_xlsx('output.xlsx') as wb:
    ws = wb.create_sheet('sheet1')
    ws.append_by_header({'id': '001', 'name': 'example'})

Requires Python >= 3.5; openpyxl must be installed as a runtime dependency.

Verify before relying:

- Whether pycel dependency is actively maintained and what its purpose is in this package.
- Whether the dormant status affects compatibility with recent openpyxl versions.
- Real-world performance characteristics when handling large spreadsheets.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: dormant
- Downloads: 230.7K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

excel worksheet dictionary interface, read write xlsx as dict, openpyxl wrapper, spreadsheet row access, excel data structure, xlsx dict-like api, spreadsheet-wrapper, data-entry

[View on SkillFed](https://skillfed.io/packages/pyxlsx) · [View on PyPI](https://pypi.org/project/pyxlsx/)