convert a json to a csv, array

Question

I'd like to convert below file into a csv file, I think jq would be the suitable tool for it.

[
  [
    "123456789012",
    "071395e8xxxxxxxx",
    bad,
    failed
  ],
  [
    "098765432123",
    "094e9c34d3xxxxxxxx",
    good,
    successful
  ],
  ...
]

to

123456789012,071395e8xxxxxxxx, bad, failed
098765432123,094e9c34d3xxxxxxxx,good,successful

peak · Accepted Answer · 2021-12-14 09:02:22Z

1

Unfortunately, the input as shown is not quite valid JSON, so you would have to tweak it somehow before presenting it to JSON. The jq command for converting to CSV would then be along the lines of:

jq -r '.[] | @csv' input.json

answered Dec 14, 2021 at 9:02

peak

119k21 gold badges185 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bill Over a year ago

you are the super hero, mate.

Collectives™ on Stack Overflow

convert a json to a csv, array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related