csvkit

7.1easy start · #5 of 36
in Data Transformation Tools

Free to practise onyes
Free trialnot on record
Well documentedyes
Runs where you workyes

Runs on Linux, Mac, Windows.

csvkit is ranked #5 of 36 in data transformation tools on The Geeks Club. 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 20

KNIME Analytics Platform 0 of 4 in the starter kit Lesson 17.7 dbt Semantic Layer 0 of 4 in the starter kit Lesson 27.5 Matillion Transform 0 of 4 in the starter kit Lesson 37.5 Coalesce Catalog 0 of 4 in the starter kit Lesson 47.4 OpenRefine 0 of 4 in the starter kit Lesson 67.1 Apache Beam 0 of 4 in the starter kit Lesson 77.0

The record

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

Where it ranks on The Geeks Club

Best Data Transformation Tools in 2026#5 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