pyexcel-io
A python library to read and write structured data in csv, zipped csvformat and to/from databases
Decision gist · record as of 2026-08-14
Yes. The package is actively maintained, has low install friction, carries a permissive New BSD License, and fills a clear niche: providing a unified API for reading and writing common tabular formats. It's well-suited for applications that need to handle multiple file formats without tight coupling to any single format library. No known vulnerabilities.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.6 or later; fonts, colors, charts, and password-protected files are not supported.
- Low install friction with a single runtime dependency (lml).
- Active maintenance with a recent release 47 days ago and ongoing issue fixes.
License · maintenance · safety
New BSD (permissive) — New BSD License is permissive and poses no restrictions on commercial or private use, modification, or redistribution.
last release 2026-06-28 (47 days) · last repo commit 2026-06-28 · 59 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 2,619,491 downloads/mo, #2,968 on PyPI
Alternatives
Verify before relying
pip install pyexcel-io
from pyexcel_io import get_data
data = get_data('file.csv')- Whether the package handles large files efficiently or has memory constraints.
- Performance characteristics when reading/writing files with many rows or columns.
- Exact behavior when multiple format plugins are installed and how library selection works.
What it is and what it does
pyexcel-io is a Python library that abstracts away file format details, letting you read and write structured data through a single consistent API regardless of whether you're working with CSV, TSV, or their zipped variants. It acts as a foundation layer for handling the low-level mechanics of parsing and serializing tabular data. The library is designed to be extended via plugins—additional packages add support for formats like XLS, XLSX, and ODS—so you can install only the format handlers you need.
You use it when you need to load data from or save data to flat files without writing format-specific parsing code, or when you want a pluggable architecture for handling multiple file types in a single application. It integrates with SQLAlchemy and Django for database workflows. The package has been actively maintained since 2014 and supports Python 3.6 and later.
Use it for
- Load CSV or TSV files into Python data structures for processing without manual parsing.
- Save tabular data to CSV/TSV files for distribution or archival.
- Build a data pipeline that accepts multiple file formats by installing format-specific plugins.
- Integrate with SQLAlchemy or Django for database import and export operations.
- Extend the library with custom file format handlers for specialized data needs.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The package is actively maintained, has low install friction, carries a permissive New BSD License, and fills a clear niche: providing a unified API for reading and writing common tabular formats. It's well-suited for applications that need to handle multiple file formats without tight coupling to any single format library. No known vulnerabilities.
Install
pyexcel-io on PyPI
Before you install
Low install friction with a single runtime dependency (lml). Active maintenance with a recent release 47 days ago and ongoing issue fixes.
Requires Python 3.6 or later; fonts, colors, charts, and password-protected files are not supported.
License in practice
New BSD License is permissive and poses no restrictions on commercial or private use, modification, or redistribution.
Quickstart
pip install pyexcel-io
from pyexcel_io import get_data
data = get_data('file.csv')Verify before relying
- Whether the package handles large files efficiently or has memory constraints.
- Performance characteristics when reading/writing files with many rows or columns.
- Exact behavior when multiple format plugins are installed and how library selection works.
Package facts
| License | New BSD permissive |
| Python support | Supports the current Python release >=3.6 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 1 packagelml |
| Maintenance | Actively maintained 47 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 2,619,491 / month, #2,968 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Intended Audience :: DevelopersLicense :: OSI Approved :: BSD LicenseProgramming 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_io-0.6.8-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 csv tsv files”
- pyexcel-ioProvides a unified API to read and write data in CSV, TSV, and zipped…
- aiocsvProvides async-compatible CSV reading and writing using AsyncReader,…
- 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 · pyexcel-xlsx · pyexcel-ods3 · pyexcel-xls · pyexcel-webio · tablib · pyexcel-ezodf · DrissionRecord · DataRecorder · dataflows-tabulator