Working with CSV files from the command line #

csvkit is a suite of utilities for converting to and working with CSV. Tools include:

Input

in2csv
sql2csv

Processing

csvclean
csvcut
csvgrep
csvjoin
csvsort
csvstack

Output (and Analysis)

csvjson
csvlook
csvpy
csvsql
csvstat

(via author's comment on a blog post about parsing CSV files with the standard *nix tools: "Just a heads up that most of these commands will fail with non-trivial data because CSV files can contain rows that span multiple lines. I wrote csvkit to solve exactly this problem: http://csvkit.readthedocs.org/en/0.8.0/ Similar commands, but it handles CSV format correctly.")

/nix | Aug 27, 2014

Subscribe or visit the archives.