Open-source JSON editor that turns JSON, YAML, CSV and XML into interactive graphs, with format conversion and code generation.
44.6K3.6KTypeScriptApache-2.0Updated 2 months ago
jazzband/tablib
A Python library for working with tabular datasets, importing and exporting them across Excel, CSV, JSON, YAML and more formats.
- Stars
- 4,758
- Forks
- 643
- Open issues
- 77
- Last commit
- 5 days ago
What is it?
Tablib is a format-agnostic library for handling tabular data in Python. It lets you build a dataset once and export it to many formats, including Excel, JSON, YAML, CSV, TSV, HTML, LaTeX, ODS, DBF and SQL, as well as Pandas DataFrames.
Datasets can be organized as single sheets or as books containing multiple sheets, depending on the format. The same object model works regardless of the output, so code that prepares rows and headers does not need to change when the target format does.
The project is maintained under the Jazzband collective and is distributed on PyPI.
Key features
- 01Exports one dataset to Excel, JSON, YAML, CSV, TSV, HTML, LaTeX, ODS, DBF and SQL.
- 02Supports multi-sheet Books for Excel, JSON and YAML output.
- 03Converts datasets to and from Pandas DataFrames.
- 04Installable from PyPI.
Use cases
- Generating Excel or ODS reports from Python data without writing format-specific code.
- Converting tabular data between CSV, JSON and YAML in a script.
- Passing query or processing results into a Pandas workflow.
Quick start
- 1
Get tablib from its PyPI page
Things to know
- XML is not supported and the project does not plan to add it.
Topics
FAQ
- What is tablib?
- A Python library for working with tabular datasets, importing and exporting them across Excel, CSV, JSON, YAML and more formats. Tablib is a format-agnostic library for handling tabular data in Python. It lets you build a dataset once and export it to many formats, including Excel, JSON, YAML, CSV, TSV, HTML, LaTeX, ODS, DBF and SQL, as well as Pandas DataFrames.
- Is tablib free to use? What license does it have?
- tablib is open source under the MIT license. Check the license terms before using it in commercial products.
- Is tablib still maintained?
- Actively maintained. The last commit to tablib was on Nov 2, 2026.
- What can I use tablib for?
- Generating Excel or ODS reports from Python data without writing format-specific code. Converting tabular data between CSV, JSON and YAML in a script. Passing query or processing results into a Pandas workflow.
- How do I install tablib?
- Get tablib from its PyPI page
- Where can I get tablib?
- The source code and installation instructions are on GitHub: https://github.com/jazzband/tablib
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
Python library for reading and writing Excel spreadsheet files (XLSX, XLSM, XLTX, XLTM, XLAM), ported from the Go Excelize library.
52+1 this week31PythonBSD-3-ClauseUpdated 3 days ago
A terminal spreadsheet multitool for exploring, arranging and transforming tabular data across many file formats.
9.5K+17 this week377PythonGPL-3.0Well maintainedUpdated 6 days ago
A Java library for reading and writing Excel and CSV spreadsheets with low memory use, suited to large files.
6.3K+4 this week554JavaApache-2.0Updated 9 hours ago
A lightweight terminal (TUI) app for viewing and querying CSV, Parquet, JSON, Excel, SQLite and other tabular data files.
3.2K+2 this week99RustMITWell maintainedUpdated 10 days ago
Python library for loading, shaping, embedding and visually exploring large graphs, with optional GPU acceleration via RAPIDS and the Graphistry visual analyzer.
2.6K+1 this week232PythonBSD-3-ClauseUpdated 6 days ago