wardi / jsonlines

Documentation for the JSON Lines text file format
http://jsonlines.org
139 stars 33 forks source link

"missing piece" #46

Open pkoppstein opened 3 years ago

pkoppstein commented 3 years ago

The documentation at https://jsonlines.org/examples says:

The biggest missing piece is an import/export filter for popular spreadsheet programs so that non-programmers can use this format.

Since the same page mentions jq, it might be worthwhile pointing out that for flat arrays of the type shown at the top of the page, the following jq command produces valid CSV:

jq -r @csv

(Similarly for TSV.)

Of course jq can be used more generally, e.g. as illustrated at https://stackoverflow.com/questions/57242240/jq-object-cannot-be-csv-formatted-only-array