JSON to CSV
Processed in your browser · nothing is uploaded
Turns an array of objects into CSV, using the union of every key as the header so a field present on only some rows still gets a column.
How to use the json to csv
Taking the union rather than the first object’s keys is the difference between a correct export and a silently lossy one. If row one has three fields and row two has a fourth, using row one as the template drops that fourth field entirely and nobody notices until the data is needed. Nested objects and arrays are a genuine problem with no good answer; CSV is flat and JSON is not. Those are serialised as JSON text inside the cell, which at least preserves the data; flattening them into dotted columns first, with the JSON flattener, usually gives a more useful spreadsheet.
Questions
They become empty cells. The header is the union of every key, so nothing is dropped.
Serialised as JSON text in the cell. Flatten the JSON to dotted paths first if you want real columns.
If the first header is "ID", Excel treats the file as SYLK. Rename it or open via the import dialog.
Only when they need it; a comma, a quote or a line break in the value.
No. Parsing and formatting happen in your browser, which matters when the JSON is an API response with real data in it.