# 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. ## Install ```sh sudo av install brew:csvkit ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install csvkit ``` Evidence: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install csvkit ``` Evidence: Debian stable package indexes: csvkit from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - Nix (92%): ```sh nix profile install nixpkgs#csvkit ``` Evidence: nixpkgs package indexes: pkgs/by-name/cs/csvkit/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - pacman (92%): ```sh sudo pacman -S csvkit ``` Evidence: Arch Linux sync databases: csvkit from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz ## Package facts - **Package key:** brew:csvkit - **Package manager:** Homebrew - **Package manager page:** - **Version:** 2.2.0 - **Source summary:** Suite of command-line tools for converting to and working with CSV - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** MIT - **Source archive:** - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - csvclean (cli) - csvcut (cli) - csvformat (cli) - csvgrep (cli) - csvjoin (cli) - csvjson (cli) - csvlook (cli) - csvpy (cli) - csvsort (cli) - csvsql (cli) - csvstack (cli) - csvstat (cli) - in2csv (cli) - sql2csv (cli) - csvclean (alias) - csvcut (alias) - csvformat (alias) - csvgrep (alias) - csvjoin (alias) - csvjson (alias) - csvlook (alias) - csvpy (alias) - csvsort (alias) - csvsql (alias) - csvstack (alias) - csvstat (alias) - in2csv (alias) - sql2csv (alias) ## Dependencies - python@3.14 ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 2.2.0 - Local data: ok - Upstream repository: https://csvkit.readthedocs.io/ - info: No package-manager update timestamp was available. - info: Release/tag comparison is only available for GitHub repositories. ## 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 Notes broad file, network, media, or database tool signal. - **Geiger risk:** blue / medium - broad file, network, media, or database tool signal ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** csvkit - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## Other Package-Manager Records - Debian apt - csvkit - 2.0.1-3: normalized package name match | Debian stable package indexes: csvkit from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | command-line tools for working with CSV | https://github.com/wireservice/csvkit - Debian apt - csvkit-doc - 2.0.1-3: normalized package name match | Debian stable package indexes: csvkit-doc from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | documentation for csvkit | https://github.com/wireservice/csvkit - Debian apt - python3-csvkit - 2.0.1-3: normalized package name match | Debian stable package indexes: python3-csvkit from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | public modules for csvkit (Python 3) | https://github.com/wireservice/csvkit - Nix - csvkit: normalized package name match | nixpkgs package indexes: pkgs/by-name/cs/csvkit/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Ubuntu apt - csvkit - 1.4.0-1: normalized package name match | Ubuntu 24.04 LTS package indexes: csvkit from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | command-line tools for working with CSV | https://github.com/wireservice/csvkit - Ubuntu apt - csvkit-doc - 1.4.0-1: normalized package name match | Ubuntu 24.04 LTS package indexes: csvkit-doc from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | documentation for csvkit | https://github.com/wireservice/csvkit - Ubuntu apt - python3-csvkit - 1.4.0-1: normalized package name match | Ubuntu 24.04 LTS package indexes: python3-csvkit from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | public modules for csvkit (Python 3) | https://github.com/wireservice/csvkit - pacman - csvkit - 2.2.0-2: normalized package name match | Arch Linux sync databases: csvkit from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz | A suite of utilities for converting to and working with CSV | https://csvkit.readthedocs.org ## Related links - [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Language runtime packages](https://www.automicvault.com/pkg/language-runtime-packages/) - Matched language runtime, compiler, or interpreter metadata. - [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [csvtk](https://www.automicvault.com/pkg/brew/csvtk/) - Shares av.db curated category or tags: cli, command-line, csv, data. - [zsv](https://www.automicvault.com/pkg/brew/zsv/) - Shares av.db curated category or tags: cli, csv, data, tabular-data. - [csvlens](https://www.automicvault.com/pkg/brew/csvlens/) - Shares av.db curated category or tags: cli, csv, data. - [csvq](https://www.automicvault.com/pkg/brew/csvq/) - Shares av.db curated category or tags: cli, csv, data. - [qsv](https://www.automicvault.com/pkg/brew/qsv/) - Shares av.db curated category or tags: cli, csv, data. - [xan](https://www.automicvault.com/pkg/brew/xan/) - Shares av.db curated category or tags: cli, csv, data. - [visidata](https://www.automicvault.com/pkg/brew/visidata/) - Shares av.db curated category or tags: cli, data, python, tabular-data. - [bagit](https://www.automicvault.com/pkg/brew/bagit/) - Shares av.db curated category or tags: cli, data, python. ## Combined YAML source View the package source record on GitHub. [combined/csvkit.yml](https://github.com/automic-vault/db/blob/main/combined/csvkit.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph