csvkit

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

csvkit plans and pricing

All plans

Open-source csvkit Free Free of charge under the MIT License Command-line toolkit · no paid tiers stated csvkit.readthedocs.io · 1 Oct 2026

Compared on data transformation tools

Free plan: Yes
Deployment model: self_hosted
Transformation interface: code
Supported data formats: CSV, DBF, fixed-width, GeoJSON, JSON, NDJSON, XLS, XLSX; gzip, bz2 and xz-compressed CSV input
Workflow orchestration: Yes
Data quality checks: Yes

Best csvkit alternatives

See all 12

jq Free plan LinuxMacself-hostedWebWin

Free6.6 Apache Beam Free plan apiLinuxMacself-hostedWeb

Free6.5 Bruin for Customer Success Free plan apiLinuxMacself-hostedWeb

Free6.5 KNIME Analytics Platform Free plan LinuxMacWin

6.5 OpenRefine Free plan LinuxMacself-hostedWebWin

Free6.5 Apache Hop Free plan LinuxMacself-hostedWin

Free6.4

csvkit

What it does: csvkit is a suite of command-line tools for converting to and working with CSV files.
Input tools: Its input tools include in2csv and sql2csv.
Processing tools: Its processing tools include csvclean, csvcut, csvgrep, csvjoin, csvsort, and csvstack.
Output and analysis: Its output and analysis tools include csvformat, csvjson, csvlook, csvpy, csvsql, and csvstat.
File conversion: in2csv converts Excel XLS/XLSX, JSON, and fixed-width files to CSV.
SQL workflows: csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv extracts query results from PostgreSQL.
Format detection: csvkit sniffs delimiters using the first 1024 bytes of input by default.
Type inference: csvkit automatically infers numbers, dates, booleans, and other data types, and the documentation warns that inference can occasionally be erroneous.
Database integrations: Database connections use SQLAlchemy dialects; the troubleshooting guide specifically lists PostgreSQL and MySQL backends.
Installation: The project documents installation with pip, recommends virtual environments, supports Homebrew installation, and offers an optional Zstandard extra.
Supported systems: The documentation states csvkit is supported on non-end-of-life Python versions on Linux, macOS, and Windows.
Runtime requirement: The current project metadata requires Python 3.10 or newer.
Performance limits: Some tools stream rows, while others buffer entire files in memory; the documentation says large files may reach csvkit's limits.
Security and licensing: csvkit is released under the MIT License and the license states the software is provided as-is without warranty.
Price from: Free

Visit site Alternatives

Where it ranks on Freedom251

Best Data Transformation Tools in 2026#4 of 36

Is csvkit yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote csvkit

Sources

csvkit.readthedocs.io/en/latest/· checked 1 Oct 2026
csvkit.readthedocs.io/en/latest/cli.html· checked 1 Oct 2026
csvkit.readthedocs.io/en/latest/tutorial/1_getting_started.ht· checked 1 Oct 2026
csvkit.readthedocs.io/en/latest/tricks.html· checked 1 Oct 2026
github.com/wireservice/csvkit/blob/master/pyprojec· checked 1 Oct 2026
csvkit.readthedocs.io/en/latest/contributing.html· checked 1 Oct 2026
csvkit.readthedocs.io/en/latest/license.html· checked 1 Oct 2026