Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

csvkit

github.com

  • Free plan
  • Windows
  • macOS
  • Linux
7.4 Club score Visit github.com

What csvkit is

csvkit is a free suite of command-line tools for converting and working with CSV files on Linux, macOS and Windows. Its commands cover file conversion, column editing, inspection, filtering, sorting and combining data. in2csv converts formats such as Excel, JSON and fixed-width files to CSV, while csvcut selects, deletes or reorders columns. csvlook displays data in the terminal, and csvstat produces summary statistics. csvjoin merges related data and csvstack combines subsets. For SQL work, csvsql can query CSV data and import it into PostgreSQL; sql2csv exports query results to CSV. csvjson converts CSV files to JSON and can also produce GeoJSON. Standard input and output let commands be linked into repeatable pipelines. By default, csvkit infers format from the first 1024 bytes and infers cell types, though either behavior can be turned off. Installation instructions cover pip and Homebrew and recommend a virtual environment. The tutorial assumes basic command-line familiarity, not prior data-processing or analysis experience. The project is MIT-licensed and provided without warranty. Its documentation cautions that larger files or faster processing may exceed its limits and suggests SQL or other tools for those cases.

Who it suits

csvkit suits people comfortable with basic command-line use who need to convert, inspect or reshape CSV data. It can also support repeatable data workflows that connect command-line tools.

Good to know, and what to watch

  • Converts Excel, JSON and fixed-width files to CSV.
  • Supports SQL queries and PostgreSQL imports.
  • Commands can be connected through standard input and output.
  • Available on Linux, macOS and Windows.
  • Free and MIT-licensed.
  • Large files or faster processing may exceed its limits.
  • The tutorial assumes basic command-line familiarity.
  • The software is provided without warranty.

csvkit

Free

Free plan

Getting started

  1. Open the csvkit project website
  2. Create a virtual environment as recommended in the documentation
  3. Install csvkit with the documented pip command
  4. Alternatively, install it with the documented Homebrew command
  5. Run the command-line tools on Linux, macOS, or Windows

Limits to check

csvkit is provided as a free plan at no cost, with no paid tiers stated. Its documentation says processing speed and larger files may reach the toolkit's limits.

The verdict

csvkit offers a broad set of CSV tasks as composable command-line tools without a paid tier. For larger datasets or speed-sensitive work, its documented performance limitation is worth considering.

Questions people ask

How much does csvkit cost?

The csvkit plan is free. It is free, MIT-licensed software, and no paid tiers are stated.

Which operating systems does csvkit support?

csvkit runs on Linux, macOS, and Windows.

Can csvkit work with databases?

Yes. csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv can export query results to CSV.

Does csvkit support JSON and GeoJSON?

csvjson converts CSV to JSON and can also output GeoJSON. in2csv accepts JSON as an input format.

How is csvkit installed?

The documentation provides pip and Homebrew installation commands and recommends using a virtual environment.

Is csvkit open source?

It is MIT-licensed software. The MIT license provides the software as is without warranty.

What the maker publishes

Column editing
csvcut can select, delete, and reorder CSV columns. source
Combining data
csvjoin merges related data, while csvstack combines subsets. source
Command pipelines
The tools accept standard input and output, allowing commands to be piped together into repeatable data-processing workflows. source
Data inspection
csvlook displays CSV data in the command line, and csvstat generates summary statistics. source
File conversion
in2csv converts common formats including Excel, JSON, and fixed-width files to CSV. source
Filtering and sorting
The suite includes tools to find matching rows and sort data. source
Format detection
By default, csvkit infers CSV format from the first 1024 bytes and infers cell types, with options to disable both behaviors. source
Installation
The documentation gives pip and Homebrew installation commands and recommends using a virtual environment. source
Intended users
The tutorial assumes basic command-line familiarity and says no prior experience with data processing or analysis is assumed. source
JSON and GeoJSON
csvjson converts CSV to JSON and can also output GeoJSON. source
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. source
Purpose
csvkit is a suite of command-line tools for converting to and working with CSV files. source
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. source
SQL and databases
csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv can extract query results to CSV. source
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. source

Checked against the maker's pages on 7 Oct 2026.