explaingit

jazzband/tablib

★ 4,751PythonAudience · developerComplexity · 2/5Setup · easy

TLDR

A Python library for reading and writing tabular data across many formats, load from CSV, then export to Excel, JSON, YAML, HTML, or a dozen other formats without changing how you work with the data.

Mindmap

mindmap
  root((tablib))
    What it does
      Format conversion
      Dataset abstraction
      Pandas integration
    Tech Stack
      Python
      Pandas
    Use Cases
      CSV to Excel export
      Report generation
      Data format bridging
    Output Formats
      Excel CSV JSON
      YAML HTML LaTeX
      SQL ODS DBF
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Read a CSV file and export the same data as an Excel spreadsheet or JSON file in a single Python script.

USE CASE 2

Generate a formatted HTML table or LaTeX table from any in-memory dataset for reports or documentation.

USE CASE 3

Pass structured data between systems using YAML or JSON without writing format-specific parsing code.

USE CASE 4

Hand off tabular data to Pandas for analysis using the built-in DataFrame integration.

Tech stack

PythonPandas

Getting it running

Difficulty · easy Time to first run · 5min

In plain English

Tablib is a Python library for working with tabular data, meaning rows and columns of information like you would find in a spreadsheet. Its main selling point is that it treats the data separately from any particular file format: you load or build a dataset once, then export it to whichever format you need. The supported output formats include Excel, CSV, JSON, YAML, HTML, LaTeX, TSV, ODS (OpenDocument Spreadsheet), DBF, SQL, and Pandas DataFrames. This means a script that reads from a CSV file can produce an Excel file or a JSON file without you changing how the data itself is represented in your code. The library is part of the Jazzband organization, a collaborative group on GitHub that maintains open-source Python projects together. Installation is via the standard Python package manager (PyPI), and full documentation is hosted on readthedocs.io. The README is minimal and points to external documentation for usage details. Tablib is straightforward to use in scripts that need to move data between formats, generate reports, or pass structured data between systems. It does not handle database connections or data analysis on its own, but its Pandas integration means it can hand off to Pandas for those tasks.

Copy-paste prompts

Prompt 1
Using tablib in Python, read a CSV file, add a calculated column, and export the result as both Excel and JSON in one script.
Prompt 2
How do I use tablib to generate an HTML table from a list of dictionaries and save it to a file?
Prompt 3
Show me how to merge two tablib datasets and export the combined result as a YAML file.
Open on GitHub → Explain another repo

← jazzband on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.