csvkit

Input—per 1M tokens

Output—per 1M tokens

Context—tokens

WeightsClosed

About

csvkit is ranked #14 of 36 in data transformation tools on Inferse. It runs on Linux, macOS, Windows. There is a free plan.

Compared on data transformation tools

Free plan: Yescsvkit.readthedocs.io
Deployment model: self_hostedcsvkit.readthedocs.io
Transformation interface: codecsvkit.readthedocs.io
Supported data formats: CSV, DBF, fixed-width, GeoJSON, JSON, NDJSON, XLS, XLSX; gzip, bz2 and xz-compressed CSV inputcsvkit.readthedocs.io
Workflow orchestration: Yescsvkit.readthedocs.io
Data quality checks: Yescsvkit.readthedocs.io

Facts

What it does: csvkit is a suite of command-line tools for converting to and working with CSV files.csvkit.readthedocs.io · 1 Oct 2026
Input tools: Its input tools include in2csv and sql2csv.csvkit.readthedocs.io · 1 Oct 2026
Processing tools: Its processing tools include csvclean, csvcut, csvgrep, csvjoin, csvsort, and csvstack.csvkit.readthedocs.io · 1 Oct 2026
Output and analysis: Its output and analysis tools include csvformat, csvjson, csvlook, csvpy, csvsql, and csvstat.csvkit.readthedocs.io · 1 Oct 2026
File conversion: in2csv converts Excel XLS/XLSX, JSON, and fixed-width files to CSV.csvkit.readthedocs.io · 1 Oct 2026
SQL workflows: csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv extracts query results from PostgreSQL.csvkit.readthedocs.io · 1 Oct 2026
Format detection: csvkit sniffs delimiters using the first 1024 bytes of input by default.csvkit.readthedocs.io · 1 Oct 2026
Type inference: csvkit automatically infers numbers, dates, booleans, and other data types, and the documentation warns that inference can occasionally be erroneous.csvkit.readthedocs.io · 1 Oct 2026
Database integrations: Database connections use SQLAlchemy dialects; the troubleshooting guide specifically lists PostgreSQL and MySQL backends.csvkit.readthedocs.io · 1 Oct 2026
Installation: The project documents installation with pip, recommends virtual environments, supports Homebrew installation, and offers an optional Zstandard extra.csvkit.readthedocs.io · 1 Oct 2026
Supported systems: The documentation states csvkit is supported on non-end-of-life Python versions on Linux, macOS, and Windows.csvkit.readthedocs.io · 1 Oct 2026
Runtime requirement: The current project metadata requires Python 3.10 or newer.github.com · 1 Oct 2026
Performance limits: Some tools stream rows, while others buffer entire files in memory; the documentation says large files may reach csvkit's limits.csvkit.readthedocs.io · 1 Oct 2026
Security and licensing: csvkit is released under the MIT License and the license states the software is provided as-is without warranty.csvkit.readthedocs.io · 1 Oct 2026
Support: User support is provided through the documentation, GitHub issues, and community contributions.csvkit.readthedocs.io · 1 Oct 2026
Target users: Project metadata identifies developers, end users/Desktop, and science/research users as intended audiences.github.com · 1 Oct 2026
Maintenance scope: The maintainers say csvkit generally no longer adds new tools because of limited maintenance time and a desire to keep the toolkit focused.csvkit.readthedocs.io · 1 Oct 2026