csvjson

Convert CSV to JSON array

$ csvjson [data.csv]

$ csvjson -i [4] [data.csv]

$ csvjson --stream [data.csv]

$ csvjson -k [id] [data.csv]

$ csvjson --lat [latitude] --lon [longitude] [data.csv]

$ csvjson -d "[;]" [data.csv]

csvjson [options] file

csvjson is part of csvkit that converts CSV files to JSON format. It supports various output formats including JSON arrays, keyed objects, newline-delimited JSON for streaming, and GeoJSON for geographic data.
By default, output is a JSON array of objects where each row becomes an object with column names as keys. The -k option creates a keyed object using a unique column's values as keys.
Type inference converts numeric and boolean values appropriately. The streaming mode outputs one JSON object per line, suitable for processing with tools like jq or for large files that shouldn't be loaded entirely.

FILE

CSV file to convert. Uses stdin if not specified.

Indentation level for pretty printing.

Column to use as object keys (creates object instead of array).

Output newline-delimited JSON (one object per line).

Latitude column for GeoJSON output.

Longitude column for GeoJSON output.

Field delimiter (default: comma).

Input file encoding.

Disable type inference (keep all values as strings).

The -k option requires unique values in the key column. Large files may use significant memory without streaming mode. GeoJSON output requires valid latitude/longitude values. Type inference may misinterpret some values.

csvjson is part of csvkit, created by Christopher Groskopf in 2011. It enables easy conversion of tabular data to JSON, the dominant format for web APIs and JavaScript applications.

in2csv(1), jq(1), csvkit(1), miller(1)