csvmagic

Command line utilities to work with csv files.

Contents

• csvread - Display csv rows in a more human-readable format.
• csvcut - Extract or rearrange columns of a csv file.
• csvgrep - Find rows matching a pattern in a csv file.
• csvalign - Print a csv file with its columns aligned.
• csvsql - Query one or more csv files.
• csvcsv - Convert a csv file from one variant to another.
• csvjson - Convert a csv file to json.

Installation

With pip:

pip install csvmagic

With dpm:

dpm install https://github.com/markuskimius/csvmagic.git

With git clone, after installing the dependencies with pip:

pip install getopts
git clone https://github.com/markuskimius/csvmagic.git

CSV Format

All utilities share the same parser:

• The delimiter is guessed from the comma, tab, pipe, and SOH (ASCII 1) characters, or it may be specified explicitly.
• A field that begins with a double quote is a quoted field. It may contain the delimiter and newlines, and a double quote inside it is written as two double quotes ("").
• Any other field is taken literally up to the next delimiter, including any double quotes it contains. This allows values such as unquoted JSON to appear in a field:

firstname	text	lastname
hello	{ "hello" : "world" }	world!

Testing

PATH="$PWD/bin:$PATH" test/test.sh

The test script requires bash 4 or later. It exits with a non-zero status if any test fails.

License

Apache 2.0