Question 1

What if my objects have different keys?

Accepted Answer

Every key found in any object becomes a column, in the order they first appear. Objects missing a key get an empty cell.

Question 2

How are nested objects and arrays handled?

Accepted Answer

With Flatten nested objects on, each nested field gets its own column named by its path, like address.city. Lists of plain values are joined into one cell with “; ”, and lists of objects get numbered columns (items.0.sku, items.1.sku). Turn it off to keep nested values as JSON text inside the cell.

Question 3

What if the rows are wrapped in an object, like an API response?

Accepted Answer

If the JSON is an object with a single key that holds a list of objects, such as {"data": [{…}, {…}]}, that list becomes the table, and the status line names the key it used. With several keys, the whole object is one row.

Question 4

Are commas and quotes in values escaped?

Accepted Answer

Yes. Any value containing the delimiter, a quote or a line break is wrapped in double quotes, with inner quotes doubled, as the CSV standard requires.

Convert JSON to CSV

How to convert JSON to CSV

Opening the result in Excel