pyexcel-ods3
A wrapper library to read, manipulate and write data in ods format
Decision gist · record as of 2026-08-14
Yes, if you need ODS file support in Python and are comfortable with a library on a stable maintenance cadence (active but not rapidly evolving). The permissive license and low install friction make it a straightforward choice. Be aware that the latest release was in 2022 and fonts/colors/charts are not supported; verify compatibility with your Python version and ODS feature requirements before committing.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Low install friction with three runtime dependencies (pyexcel-io, lxml, pyexcel-ezodf).
- Maintenance is active with recent commits, though the latest release was in 2022.
License · maintenance · safety
New BSD (permissive) — Licensed under New BSD (permissive), allowing use in commercial and proprietary projects with minimal restrictions.
last release 2022-01-30 (1657 days) · last repo commit 2026-07-02 · 68 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 95,030 downloads/mo, #13,294 on PyPI
Alternatives
Verify before relying
pip install pyexcel-ods3
from pyexcel_ods3 import get_data, save_data
from collections import OrderedDict
data = OrderedDict()
data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]})
save_data("file.ods", data)
read_data = get_data("file.ods")- Whether fonts, colors, and charts can be preserved or manipulated despite the documented constraint.
- Current compatibility with Python versions beyond 3.8, given the latest release was 2022-01-30.
- Performance characteristics when handling large ODS files, given the pagination note about reading the whole file first.
What it is and what it does
pyexcel-ods3 is a wrapper around ODS file handling that lets you read spreadsheet data into Python dictionaries or write dictionaries back to ODS files. It works as both a standalone library and as a plugin for pyexcel, the larger spreadsheet abstraction framework. The library depends on pyexcel-io for format dispatch, lxml for XML parsing, and pyexcel-ezodf for ODS-specific operations.
The package is designed for developers who need to work with ODS files but want to focus on data manipulation rather than format details. It supports reading and writing entire sheets, working with in-memory streams, and pagination (though pagination reads the entire file first). Fonts, colors, charts, and password-protected files are not supported.
Use it for
- Extract tabular data from ODS files into Python for analysis or transformation.
- Generate ODS spreadsheets programmatically from Python data structures.
- Integrate ODS file handling into a pyexcel-based data pipeline.
- Convert ODS data to and from memory buffers for web uploads and downloads.
- Read partial data from large ODS files using row and column limits.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need ODS file support in Python and are comfortable with a library on a stable maintenance cadence (active but not rapidly evolving).
The permissive license and low install friction make it a straightforward choice. Be aware that the latest release was in 2022 and fonts/colors/charts are not supported; verify compatibility with your Python version and ODS feature requirements before committing.
Install
pyexcel-ods3 on PyPI
Before you install
Low install friction with three runtime dependencies (pyexcel-io, lxml, pyexcel-ezodf). Maintenance is active with recent commits, though the latest release was in 2022.
License in practice
Licensed under New BSD (permissive), allowing use in commercial and proprietary projects with minimal restrictions.
Quickstart
pip install pyexcel-ods3
from pyexcel_ods3 import get_data, save_data
from collections import OrderedDict
data = OrderedDict()
data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]})
save_data("file.ods", data)
read_data = get_data("file.ods")Verify before relying
- Whether fonts, colors, and charts can be preserved or manipulated despite the documented constraint.
- Current compatibility with Python versions beyond 3.8, given the latest release was 2022-01-30.
- Performance characteristics when handling large ODS files, given the pagination note about reading the whole file first.
Package facts
| License | New BSD permissive |
| Python support | Supports the current Python release >=3.6 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 3 packagespyexcel-iolxmlpyexcel-ezodf |
| Maintenance | Actively maintained 1,657 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 95,030 / month, #13,294 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.8Topic :: Software Development :: Libraries |
Evidence: pyexcel_ods3-0.6.1-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 › “ods file reader writer”
- pyexcel-ods3Reads, manipulates, and writes data in ODS (OpenDocument Spreadsheet)…
- aspose-cells-pythonAspose.Cells for Python via .NET creates, reads, and manipulates…
- ndjsonProvides a familiar JSON Lines (ndjson) parser and writer with an API…
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-xls · pyexcel-xlsx · pyexcel-webio · pyexcel-io · pyexcel · pyexcel-ezodf · odfdo · ezodf · pyorc · onyx-devtools