tabular-cli

Detects and normalizes tabular data (dsv, json, ndjson, xls, xlsx, xml, ods or sylk) and converts it to dsv, json, ndjson, or ssejson. Spreadsheets and DSV must have a header.

examples

To CSV

npm i tabular-cli -g
tabular -o csv < input.xlsx > output.csv

To SSE JSON with snake_case keys

npm i snake-case
tabular -o sse -k snake-case --event status < status.tsv >> events.sse

To JSON in the form of { "rows": .. } with missing values set to null

tabular -o json --style object -d null < input.ndjson > output.json

options

--keys module (shorthand -k)

An optional function to transform and/or filter keys, passed as a module name or location - relative to the current working directory or something installed alongside tabular-cli. For example: tabular -k snake-case or -k camel-case. Everything at change-case works well.

--output format (shorthand -o)

Output format, one of:

• json: via format-data/json with additional options style, prefix, separator and suffix
• ndjson: via ndjson
• dsv: via csv-write-stream with additional options separator and no-headers (a boolean flag)
• csv: shorthand for -o dsv --separator ,
• tsv: shorthand for -o dsv --separator \t
• sse: ssejson with additional option event

The default is json.

--default value (shorthand -d)

Fallback value to use for null and undefined values. Default is 0. The CLI app coerces null, undefined, true, false or any number to a javascript type.

--version

Print version and exit.

--help

Open this readme in a browser and exit.

install

With npm do:

npm install tabular-cli -g

license

MIT © Vincent Weevers. Test data © Statistics Netherlands, The Hague/Heerlen.