@json2csv/CLI


Fast and highly configurable JSON to CSV converter.
It fully support conversion following the RFC4180 specification as well as other similar text delimited formats as TSV.

@json2csv/cli makes json2csv usable as a command line tool.

$3

- Fast and lightweight
- Support for standard JSON as well as NDJSON
- Scalable to infinitely large datasets (using stream processing)
- Advanced data selection (automatic field discovery, underscore-like selectors, custom data getters, default values for missing fields, ...)
- Support for custom input data transformation
- Support for custom csv cell formatting.
- Highly customizable (supporting custom quotation marks, delimiters, eol values, etc.)
- Automatic escaping (preserving new lines, quotes, etc.)
- Optional headers
- Unicode encoding support
- Pretty printing in table format to stdout

$3

There are multiple flavours of json2csv:

* Plainjs: Includes the Parser API and a new StreamParser API which doesn't the conversion in a streaming fashion in pure js.
* Node: Includes the Node Transform and Node Async Parser APIs for Node users.
* WHATWG: Includes the WHATWG Transform Stream and WHATWG Async Parser APIs for users of WHATWG streams (browser, Node or Deno).
* CLI: Includes the CLI interface.

And a couple of libraries that enable additional configurations:

* Transforms: Includes the built-in transforms for json2csv (unwind and flatten) allowing the using to transform data before is parsed.
* Formatters: Includes the built-in formatters for json2csv (one for each data type, an excel-specific one, etc.). Formatters convert JSON data types into CSV-compatible strings.

Requirements

- Node v16+

Installation

$3

You can install json2csv as a dependency using NPM.

It's advisable to install it as a global dependency so it can be called from anywhere.

``bash
$ npm install -g @json2csv/cli
`

$3

You can install json2csv using Yarn.

It's advisable to install it as a global dependency so it can be called from anywhere.

`bash
$ yarn global add @json2csv/cli
`

Usage

`bash
$ json2csv -i input.json
`

$3

`bash
Usage: json2csv [options]

Options:
-V, --version output the version number
-i, --input Path and name of the incoming json file. Defaults to stdin.
-o, --output

Path and name of the resulting csv file. Defaults to stdout.
-c, --config Specify a file with a valid JSON configuration.
-n, --ndjson Treat the input as NewLine-Delimited JSON.
-s, --no-streaming Process the whole JSON array in memory instead of doing it line by line.
-f, --fields List of fields to process. Defaults to field auto-detection.
-v, --default-value Default value to use for missing fields.
-q, --quote Character(s) to use as quote mark. Defaults to '"'.
-Q, --escaped-quote Character(s) to use as a escaped quote. Defaults to a double

quote, '""'.
-d, --delimiter Character(s) to use as delimiter. Defaults to ','. (default: ",")
-e, --eol Character(s) to use as End-of-Line for separating rows. Defaults to '\n'. (default: "\n")
-E, --excel-strings Wraps string data to force Excel to interpret it as string even if it contains a number.
-H, --no-header Disable the column name header.
-a, --include-empty-rows Includes empty rows in the resulting CSV output.
-b, --with-bom Includes BOM character at the beginning of the CSV.
-p, --pretty Print output as a pretty table. Use only when printing to console.
--unwind [paths] Creates multiple rows from a single JSON document similar to MongoDB unwind.
--unwind-blank When unwinding, blank out instead of repeating data. Defaults to false. (default: false)
--flatten-objects Flatten nested objects. Defaults to false. (default: false)
--flatten-arrays Flatten nested arrays. Defaults to false. (default: false)
--flatten-separator Flattened keys separator. Defaults to '.'. (default: ".")
-h, --help output usage information
`

$3

#### Input file, data selection and output to stdout

`bash
$ json2csv -i input.json -f carModel,price,color

carModel,price,color
"Audi",10000,"blue"
"BMW",15000,"red"
"Mercedes",20000,"yellow"
"Porsche",30000,"green"
`

#### Input file, data selection and pretty output to stdout

`bash
$ json2csv -i input.json -f carModel,price,color -p

┌────────────────────┬───────────────┬───────────────┐
│ "carModel" │ "price" │ "color" │
├────────────────────┼───────────────┼───────────────┤
│ "Audi" │ 10000 │ "blue" │
├────────────────────┼───────────────┼───────────────┤
│ "BMW" │ 15000 │ "red" │
├────────────────────┼───────────────┼───────────────┤
│ "Mercedes" │ 20000 │ "yellow" │
├────────────────────┼───────────────┼───────────────┤
│ "Porsche" │ 30000 │ "green" │
└────────────────────┴───────────────┴───────────────┘
`

#### Input file, data selection and output to file

`bash
$ json2csv -i input.json -f carModel,price,color -o out.csv

$ cat out.csv

carModel,price,color
"Audi",10000,"blue"
"BMW",15000,"red"
"Mercedes",20000,"yellow"
"Porsche",30000,"green"
`

Same result will be obtained passing the fields config as a file.

`bash
$ json2csv -i input.json -c config.json -o out.csv
`

where the file config.json contains

`json
{ "fields": ["carModel", "price", "color"] }
`

#### Input from stdin, data selection and output to stdout

`bash
$ json2csv -f price

[{"price":1000},{"price":2000}]
`

Hit Enter and afterwards CTRL + D to end reading from stdin. The terminal should show

`bash
price
1000
2000
`

#### Input file, data selection and output to file of multiple json files

Sometimes you want to add some additional rows with the same columns.
This is how you can do that.

`bash


Initial creation of csv with headings

$ json2csv -i test.json -f name,version > test.csv

Append additional rows

$ json2csv -i test2.json -f name,version --no-header >> test.csv
``

Complete Documentation

See https://juanjodiaz.github.io/json2csv/#/parsers/cli.

License

See LICENSE.md.