$ json2csv -i input.json -l fieldList.txt -o out.csv Same result will be obtained using passing the fields as a file. Generating CSV containing only specific fields $ json2csv -i input.json -f carModel,price,color -o out.csv 'Porsche',30000,'green' Input file, specify fields and use pretty logging $ json2csv -i input.json -f carModel,price,color -p CLI examples Input file and specify fields $ json2csv -i input.json -f carModel,price,color Use -p to show the result in a beautiful table inside the console. If no output -o is specified the result is logged to the console. Logs output in pretty tables.Īn input file -i and fields -f are required. p, -pretty Use only when printing to console. b, -with-bom Includes BOM character at the beginning of the csv.

a, -include-empty-rows Includes empty rows in the resulting CSV output. H, -no-header Disable the column name header E, -excel-strings Converts string data into normalized Excel style data e, -eol Specify an End-of-Line value for separating rows. d, -delimiter Specify a delimiter other than the default comma to use. Q, -double-quotes Specify a value to replace double quote in strings q, -quote Specify an alternate quote value. v, -default-value Specify a default value other than empty string. u, -unwind Creates multiple rows from a single JSON document similar to MongoDB unwind. c, -fields-config Specify a file with a fields configuration as a JSON array. f, -fields Specify the fields to convert. s, -no-streaming Process the whole JSON array in memory instead of doing it line by line. n, -ndjson Treat the input as NewLine-Delimited JSON. o, -output Path and name of the resulting csv file. i, -input Path and name of the incoming json file. Json2csv can be called from the command line if installed globally (using the -g flag). $ npm install json2csv -save Command Line Interface How to install # Global so it can be call from anywhere

Add a BOM character at the beginning of the csv to make Excel displaying special characters correctly.

Should be used with line endings for full compatibility with Excel. If field doesn't exist in object the field value in CSV will be empty.Supports optional custom quotation marks.Uses proper line endings on various operating systems.See the CHANGELOG for details about the latest release. Can be used as a module and from the command line. Converts json into csv with column titles and proper line endings.

Json 2 csv