Tree explorer will appear here once JSON is loaded
Select a node to inspect it
Tree explorer will appear here once JSON is loaded
Select a node to inspect it
Paste a JSON array of objects (the typical shape of an API response or exported dataset) and export it as a CSV file ready to open in a spreadsheet. An array of plain objects becomes one row per object with the union of every key across all rows as columns, in the order those keys first appear; a single object becomes one row; an array of plain values becomes a single-column CSV.
Nested objects are flattened into dot-notation columns automatically - a "user": {"name": "Alice"} field becomes a user.name column. A nested array inside a row is written as a compact JSON string in its cell rather than being silently dropped, since there is no clean tabular representation for a list-within-a-cell.
Numbers are written as-is from the original document; an integer with more than about 15 significant digits is written as text instead of a spreadsheet number, since converting it through a floating-point number would silently change the value.
Commas, quotes, and line breaks inside a value are quoted and escaped per the CSV standard automatically, so a field containing a comma or an embedded newline still round-trips correctly when reopened.