macOS
Homebrewverified · 100%
brew install csvkitlocal Homebrew formula metadata
brew / rank 1672
Install csvkit with Homebrew, apt, Nix, pacman
Suite of command-line tools for converting to and working with CSV. Version 2.2.0 via Homebrew; verified from local package data. Also installable with debian: sudo apt install csvkit.
install
Additional install commands
Linux
Debian aptverified · 92%
sudo apt install csvkitDebian stable package indexes · csvkit · source: deb.debian.org
Nixverified · 92%
nix profile install nixpkgs#csvkitnixpkgs package indexes · pkgs/by-name/cs/csvkit/package.nix · source: api.github.com
Arch Linux pacmanverified · 92%
sudo pacman -S csvkitArch Linux sync databases · csvkit · source: geo.mirror.pkgbuild.com
overview
Package summary
Suite of command-line tools for converting to and working with CSV
Project links
Commands and aliases
- csvclean
- csvcut
- csvformat
- csvgrep
- csvjoin
- csvjson
- csvlook
- csvpy
- csvsort
- csvsql
- csvstack
- csvstat
- in2csv
- sql2csv
history
Project history and usage
csvkit is a Python suite of command-line tools for converting, inspecting, querying, and transforming CSV and other tabular data formats.
Project history
The upstream README describes csvkit as a suite for working with CSV, inspired by pdftk, GDAL, and the original csvcut tool by Joe Germuska and Aaron Bycoffe. Its changelog begins in 2012 and records steady expansion from conversion and inspection utilities into SQL import/export, GeoJSON, compressed input, richer type inference, and Python-version maintenance.
Version 1.0.0 arrived in December 2016. The 2.0.0 release in May 2024 was the first major release since 1.0.0 and included backwards-incompatible csvclean behavior changes, new checks, and a renewed focus on standard streams and explicit options.
Adoption history
csvkit became a common package-manager fixture because it provides many small Unix-style commands under one distribution: in2csv, csvcut, csvgrep, csvjoin, csvjson, csvlook, csvsql, csvstack, csvstat, sql2csv, and others. The input package metadata records distribution through Homebrew, Debian, Nix, Arch, and Ubuntu.
The README advertises PyPI download and version badges, while the documentation is hosted on Read the Docs. That combination made csvkit both a Python package and a system-package dependency for users who wanted spreadsheet and database conversion without opening a GUI.
How it is used
Typical use is shell-oriented: convert Excel, JSON, DBF, or SQL data to CSV, select or filter columns, join files, pretty-print tables with csvlook, compute statistics with csvstat, or create/query database tables with csvsql. Its role overlaps with small Unix text tools but handles CSV dialects, quoting, encodings, and tabular types explicitly.
Why package nerds care
csvkit is package-significant because it bundles a vocabulary of CSV subcommands into one installable toolchain. It is also a useful comparison point for newer single-purpose tools: csview's own README benchmarks against csvkit's csvlook, showing how csvkit remains a reference implementation even when leaner tools optimize a narrower job.
Timeline
- 2012: Changelog begins at 0.4.3.
- 2012: 0.5.0 adds csvpy, GeoJSON support, Windows scripts, and lower-memory multi-file handling.
- 2014: 0.7.0 merges sql2csv and improves SQL-on-CSV workflows.
- 2016: 1.0.0 is released.
- 2024: 2.0.0 ships as the first major release since 2016.
- 2025: 2.2.0 adds Python 3.14 support and drops Python 3.9.
Related projects
- csvkit is related to agate, which it uses internally, and to the original csvcut, pdftk, and GDAL inspirations named by upstream. It is commonly compared with xsv, Miller, q, and other command-line tabular-data tools.
Sources
security posture
Risk level: blue
broad file, network, media, or database tool signal.
Risk classifier
blue risk · medium confidence · tool
Why
- broad file, network, media, or database tool signal
Signals
- text:sql
Install behavior
- No Homebrew bottle metadata was recorded.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
csvclean | executable | indexed executable | Discovered from the local executable index. |
csvcut | executable | indexed executable | Discovered from the local executable index. |
csvformat | executable | indexed executable | Discovered from the local executable index. |
csvgrep | executable | indexed executable | Discovered from the local executable index. |
csvjoin | executable | indexed executable | Discovered from the local executable index. |
csvjson | executable | indexed executable | Discovered from the local executable index. |
csvlook | executable | indexed executable | Discovered from the local executable index. |
csvpy | executable | indexed executable | Discovered from the local executable index. |
csvsort | executable | indexed executable | Discovered from the local executable index. |
csvsql | executable | indexed executable | Discovered from the local executable index. |
csvstack | executable | indexed executable | Discovered from the local executable index. |
csvstat | executable | indexed executable | Discovered from the local executable index. |
in2csv | executable | indexed executable | Discovered from the local executable index. |
sql2csv | executable | indexed executable | Discovered from the local executable index. |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-08-03
manager version2.2.0
manager updated
local dataunknown
upstreamnot available
latest detectednot detected
- okNo freshness warnings were generated.
install metadata
Package metadata
| Package key | brew:csvkit |
|---|---|
| Version | 2.2.0 |
| Package manager | Homebrew |
| Homepage | https://csvkit.readthedocs.io/ |
| Bottle | not recorded |
| Service | none declared |
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
Debian apt95%
csvkit 2.0.1-3
command-line tools for working with CSV
https://github.com/wireservice/csvkit
sudo apt install csvkit- Section: utils
- Architecture: all
- 2 dependencies
- 2 optional deps
- normalized package name match
- Matched by: Csvkit
Debian apt95%
csvkit-doc 2.0.1-3
documentation for csvkit
https://github.com/wireservice/csvkit
sudo apt install csvkit-doc- Section: doc
- Architecture: all
- Source Package: csvkit
- 1 dependencies
- normalized package name match
- Matched by: Csvkit
Debian apt95%
python3-csvkit 2.0.1-3
public modules for csvkit (Python 3)
https://github.com/wireservice/csvkit
sudo apt install python3-csvkit- Section: python
- Architecture: all
- Source Package: csvkit
- 10 dependencies
- normalized package name match
- Matched by: Csvkit
Nix95%
csvkit
nix profile install nixpkgs#csvkit- normalized package name match
- Matched by: Csvkit
Ubuntu apt95%
csvkit 1.4.0-1
command-line tools for working with CSV
https://github.com/wireservice/csvkit
sudo apt install csvkit- Section: universe/utils
- Architecture: all
- 2 dependencies
- 1 optional deps
- normalized package name match
- Matched by: Csvkit
Ubuntu apt95%
csvkit-doc 1.4.0-1
documentation for csvkit
https://github.com/wireservice/csvkit
sudo apt install csvkit-doc- Section: universe/doc
- Architecture: all
- Source Package: csvkit
- 1 dependencies
- normalized package name match
- Matched by: Csvkit
Ubuntu apt95%
python3-csvkit 1.4.0-1
public modules for csvkit (Python 3)
https://github.com/wireservice/csvkit
sudo apt install python3-csvkit- Section: universe/python
- Architecture: all
- Source Package: csvkit
- 10 dependencies
- normalized package name match
- Matched by: Csvkit
pacman95%
csvkit 2.2.0-2
A suite of utilities for converting to and working with CSV
https://csvkit.readthedocs.org
sudo pacman -S csvkit- License: MIT
- Architecture: any
- 7 dependencies
- 1 optional deps
- normalized package name match
- Matched by: Csvkit
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Geiger risk classifier
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- pkg.so package database
- pkgdb category and tag curation