>

A CSV Toolkit: csvkit

Use csvcut, csvstat, csvsql and friends to work with CSV files.

macOStextstatscsvLow risk
Run csvstat data.csv to print column types, ranges and statistics.

01Command

Command
$ csvstat data.csv

02What it does

csvkit is a family of Unix-style tools: csvcut selects columns, csvgrep filters rows, csvstat summarises and csvsql runs SQL against CSVs. They chain through pipes and handle headers and dialects correctly.

03Risk

RiskLow risk
CompatibilitymacOS with Homebrew installed
!Warning: csvkit is written in Python and installed through pip; the Homebrew formula bundles it so you do not need a separate Python setup.

04Undo

✓No undo needed — this command does not change persistent state.

05Sources

  • Homebrew formula: csvkit
    Homebrew · vendor-doc · 2026-09-20
    Evidence: Suite of command-line tools for converting to and working with CSV. Packages csvkit, a suite of command-line tools for working with CSV.

Last verified: 2026-09-22 · Category: Developer