JTCSV Command Line Interface

Current version: 3.1.0

Install

npm install -g jtcsv
# or
npx jtcsv --help

Usage

jtcsv <command> [options] <input> <output>

Commands

json-to-csv

jtcsv json-to-csv input.json output.csv

csv-to-json

jtcsv csv-to-json input.csv output.json

save-json

Save JSON to a file (pretty printing optional).

jtcsv save-json input.json output.json --pretty

preprocess

Preprocess JSON with deep unwrapping.

jtcsv preprocess input.json output.json --max-depth=3 --unwrap-arrays

stream

jtcsv stream json-to-csv input.json output.csv
jtcsv stream csv-to-json input.csv output.json
jtcsv stream file-to-csv input.json output.csv
jtcsv stream file-to-json input.csv output.json

batch

jtcsv batch json-to-csv "data/*.json" output/
jtcsv batch csv-to-json "data/*.csv" output/
jtcsv batch process "data/*" output/

You can also use flags instead of positional args:

jtcsv batch json-to-csv --pattern="data/*.json" --output-dir="output/"

batch process converts JSON and CSV files in the same folder. Non-CSV/JSON files are skipped.

tui

jtcsv tui

help / version

jtcsv help
jtcsv --help
jtcsv --version

Options

Conversion options

• --delimiter=CHAR (default: ';')
• --auto-detect / --auto-detect=false
• --candidates=LIST (comma-separated, default: ;,\t,|)
• --no-headers
• --parse-numbers
• --parse-booleans
• --no-trim
• --no-fast-path
• --fast-path-mode=objects|compact
• --rename=JSON
• --template=JSON
• --no-injection-protection
• --no-rfc4180
• --max-records=N
• --max-rows=N
• --pretty

Preprocess options

• --max-depth=N
• --unwrap-arrays
• --stringify-objects

Streaming options

• --chunk-size=N
• --buffer-size=N
• --add-bom

Batch options

• --recursive
• --pattern=GLOB
• --output-dir=DIR
• --overwrite
• --parallel=N

General options

• --silent
• --verbose
• --debug
• --dry-run

Reserved

• --schema=JSON
• --transform=JS

These two are parsed by the CLI but are not wired to any behavior yet.

Examples

jtcsv csv-to-json data.csv output.json --parse-numbers --auto-detect
jtcsv json-to-csv data.json output.csv --delimiter=,