pyexcel-xlsx
A wrapper library to read, manipulate and write data in xlsx and xlsmformat
Decision gist · record as of 2026-08-14
Yes. It has low install friction, active maintenance, permissive licensing, no known vulnerabilities, and solves a common task (xlsx I/O) cleanly. Install it if you need straightforward Excel file handling without styling or macro support.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Low install friction with only two runtime dependencies (openpyxl and pyexcel-io).
- Actively maintained as of 2025-03-05 with recent repository activity.
License · maintenance · safety
New BSD (permissive) — Licensed under New BSD (permissive), allowing use in commercial and proprietary projects without restriction.
last release 2025-03-05 (527 days) · last repo commit 2026-07-01 · 121 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,399,183 downloads/mo, #3,955 on PyPI
Alternatives
Verify before relying
pip install pyexcel-xlsx
from pyexcel_xlsx import get_data, save_data
from collections import OrderedDict
data = OrderedDict()
data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]})
save_data("file.xlsx", data)
read_data = get_data("file.xlsx")- Whether read_only and write_only mode performance characteristics are suitable for your file sizes and use case
- Compatibility with specific xlsm file formats or macros beyond basic data read/write
What it is and what it does
pyexcel-xlsx is a lightweight wrapper around openpyxl that simplifies reading and writing Excel files in xlsx and xlsm formats. It abstracts away openpyxl's lower-level API, letting you work directly with Python dictionaries and lists instead of cell objects. The library is designed to be used standalone or as a plugin for pyexcel, the larger data-manipulation framework.
It uses openpyxl's read_only and write_only modes for efficiency, though this means fonts, colors, charts, and password-protected files are not supported. You can read and write to files on disk or in memory, and it supports pagination features for working with large spreadsheets by reading only a subset of rows or columns.
Use it for
- Extract data from xlsx files into Python dictionaries for data processing pipelines
- Generate xlsx reports programmatically from Python data structures
- Read partial data from large xlsx files using row and column limits to manage memory
- Convert xlsx files to and from in-memory buffers for web uploads and downloads
- Integrate xlsx handling into pyexcel-based data workflows without explicit imports
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
It has low install friction, active maintenance, permissive licensing, no known vulnerabilities, and solves a common task (xlsx I/O) cleanly. Install it if you need straightforward Excel file handling without styling or macro support.
Install
pyexcel-xlsx on PyPI
Before you install
Low install friction with only two runtime dependencies (openpyxl and pyexcel-io). Actively maintained as of 2025-03-05 with recent repository activity.
License in practice
Licensed under New BSD (permissive), allowing use in commercial and proprietary projects without restriction.
Quickstart
pip install pyexcel-xlsx
from pyexcel_xlsx import get_data, save_data
from collections import OrderedDict
data = OrderedDict()
data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]})
save_data("file.xlsx", data)
read_data = get_data("file.xlsx")Verify before relying
- Whether read_only and write_only mode performance characteristics are suitable for your file sizes and use case
- Compatibility with specific xlsm file formats or macros beyond basic data read/write
Package facts
| License | New BSD permissive |
| Python support | Supports the current Python release >=3.6 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagesopenpyxlpyexcel-io |
| Maintenance | Actively maintained 527 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 1,399,183 / month, #3,955 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Intended Audience :: DevelopersProgramming Language :: PythonProgramming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.6Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: Implementation :: PyPyTopic :: Software Development :: Libraries |
Evidence: pyexcel_xlsx-0.6.1-py2.py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “read write xlsx files python”
- pyexcel-xlsxReads, manipulates, and writes xlsx and xlsm files by wrapping…
- pyexcel-xlsReads, manipulates, and writes data in xls format; also reads xlsx…
- pyexcelProvides a single API to read, write, and manipulate data across…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also pyexcel-io · pyexcel-xls · pyexcel-ods3 · pyexcel-webio · pyexcel · pyexcel-ezodf · PyExcelerate · openpyxl · xlrd3 · pyorc