Skip to content
SPECIFICTION
Get listed

csvkit

github.com

Free plan WindowsmacOSLinux
Visit github.com
Spec score 8.0 #10 of 28 in Data Preparation Software

What it is

csvkit is a free suite of command-line tools for converting, inspecting and transforming CSV data on Linux, macOS and Windows. Its tools handle common file and table tasks: in2csv converts formats such as Excel, JSON and fixed-width files; csvcut selects, removes or reorders columns; and csvlook and csvstat display data and summary statistics. Other commands filter matching rows, sort records, join related data or stack subsets. For database workflows, csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv exports query results. csvjson converts CSV to JSON or GeoJSON. Commands can read standard input and write standard output, making them suitable for repeatable pipelines. By default, csvkit infers format from the first 1024 bytes and infers cell types, with options to turn off either behavior. Installation instructions include pip and Homebrew and recommend a virtual environment. The tutorial assumes basic command-line familiarity, but not prior data-processing experience. The project notes that larger files or faster processing may exceed its limits and suggests SQL or other tools in that case.

Spec sheet

Purpose
csvkit is a suite of command-line tools for converting to and working with CSV files.Read 7 Oct 2026 · csvkit.readthedocs.io
Intended users
The tutorial assumes basic command-line familiarity and says no prior experience with data processing or analysis is assumed.Read 7 Oct 2026 · csvkit.readthedocs.io
Column editing
csvcut can select, delete, and reorder CSV columns.Read 7 Oct 2026 · csvkit.readthedocs.io
Combining data
csvjoin merges related data, while csvstack combines subsets.Read 7 Oct 2026 · csvkit.readthedocs.io
Command pipelines
The tools accept standard input and output, allowing commands to be piped together into repeatable data-processing workflows.Read 7 Oct 2026 · csvkit.readthedocs.io
Data inspection
csvlook displays CSV data in the command line, and csvstat generates summary statistics.Read 7 Oct 2026 · csvkit.readthedocs.io
File conversion
in2csv converts common formats including Excel, JSON, and fixed-width files to CSV.Read 7 Oct 2026 · csvkit.readthedocs.io
Filtering and sorting
The suite includes tools to find matching rows and sort data.Read 7 Oct 2026 · csvkit.readthedocs.io
Format detection
By default, csvkit infers CSV format from the first 1024 bytes and infers cell types, with options to disable both behaviors.Read 7 Oct 2026 · csvkit.readthedocs.io
Installation
The documentation gives pip and Homebrew installation commands and recommends using a virtual environment.Read 7 Oct 2026 · csvkit.readthedocs.io
JSON and GeoJSON
csvjson converts CSV to JSON and can also output GeoJSON.Read 7 Oct 2026 · csvkit.readthedocs.io
Performance limit
The documentation says csvkit may reach its limits for faster processing or larger files and suggests loading data into SQL or considering qsv or xsv.Read 7 Oct 2026 · csvkit.readthedocs.io
Security and warranty
The MIT license states that the software is provided as is without warranty; the opened project pages do not state security certifications or compliance claims.Read 7 Oct 2026 · csvkit.readthedocs.io
SQL and databases
csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv can extract query results to CSV.Read 7 Oct 2026 · csvkit.readthedocs.io
Support and maintenance
The project welcomes bug fixes and documentation updates, and maintainers offer feedback and code review for larger features; it says new tools are generally no longer added due to limited maintenance time and a desire to keep the toolkit focused.Read 7 Oct 2026 · csvkit.readthedocs.io

Plans and prices

csvkit Free MIT-licensed software · no paid tiers stated Read 7 Oct 2026 · csvkit.readthedocs.io

Every csvkit plan and price →

Strong points and limits

Strong points

  • Free, MIT-licensed software for Linux, macOS and Windows.
  • Converts Excel, JSON and fixed-width files to CSV.
  • Includes column editing, filtering, sorting and summary statistics.
  • Connects commands through standard input and output.
  • Can query CSV with SQL and import into PostgreSQL.

Limits

  • May reach its limits with faster processing or larger files.
  • The MIT license provides the software without warranty.
  • The project says new tools are generally no longer added.

Who it suits

csvkit suits people comfortable with basic command-line use who need repeatable CSV conversion, inspection or database workflows. Its tutorial does not assume prior data-processing or analysis experience.

Verdict

csvkit gathers a broad set of CSV operations into pipe-friendly command-line tools. It is free, but the project warns that larger or faster workloads may call for SQL or another tool.

Where Specifiction places it

Alternatives to csvkitAll alternatives →