csvkit
github.com
- Free plan
- Windows
- macOS
- Linux
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.
Plans
Every plan and pricecsvkit
Free plan
Getting started
- Open the csvkit project website
- Create a virtual environment as recommended in the documentation
- Install csvkit with the documented pip command
- Alternatively, install it with the documented Homebrew command
- 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.