Wrap a line with square brackets and use JSON.parse() to convert to a JSON array. Parsing CSVJSON is done by processing one line at a time. Toggle the switch Output CSVJSON variant to output that format.Д¬SVJSON format variant is not valid CSV however every value is valid JSON. More specifically, objects and arrays would not be wrapped in double quotes but output as is. The variant proposes that every CSV value be a valid JSON value. Dror Harari proposed a variant called CSVJSON ( ). Alternatively, you can flatten nested arrays of objects as requested by Rogerio Marques in GitHub issue #3.Д¬SV values are plain text strings. By default, nested arrays or objects will simply be stringified and copied as is in each cell. JSON to CSV will convert an array of objects into a table.

Make sure to pick that option if you are going to import the CSV file in Excel. In French, Excel will expect a semi-colons instead of a comma. You can then copy (Ctrl+C) and paste (Ctrl+V) it into Excel. TSV or Tab Separated Values is used to store table data in the Clipboard. Often used as an interchange data format to represent table records, one per line.

This function is available as a npm package.

Json file converter