TabLib

Tablib is the Pythonic, format-agnostic library for importing, exporting, and manipulating tabular datasets (CSV, JSON, XLSX, etc.).

Tablib is your essential Python library for efficient, format-agnostic tabular data handling. It streamlines the import, manipulation, and export of datasets across 15+ formats (CSV, JSON, YAML, XLSX, ODS, etc.). Developed by Kenneth Reitz, this MIT-licensed tool is the lightweight alternative to heavy data science frameworks, excelling with small-to-medium datasets. Advanced features include dynamic column generation, dataset segregation, and filtering with tags. Major organizations, including National Geographic and Northrop Grumman, leverage Tablib internally for streamlined data operations.

https://tablib.readthedocs.io/