JSON to Table

How to use

1. Paste a JSON array of objects on the left (or drop a .json file above). 2. Pick Markdown table, CSV or TSV, then click Convert. 3. Copy the result or download it. The preview below shows the first 100 rows.

FAQ

Is my JSON uploaded? No. Parsing and conversion all run in your browser with the built-in JSON parser; nothing passes through our server.
How are nested values handled? Nested objects are flattened with dotted keys, so {"address":{"city":"Shanghai"}} becomes the column address.city. Arrays and other non-scalar values are written out as compact JSON text (for example ["a","b"]).
What if rows have different keys? Columns are the union of all keys, in first-seen order. A row that lacks a key gets an empty cell — nothing is guessed or filled in.
What shapes of JSON work? An array of objects works directly, as does a single object (one row). If the top level is an object holding one array of objects — like {"users":[{...}]} — the tool uses that array and says so in the notice. A bare array of numbers or strings becomes a single column called value.
How is CSV escaped? Per RFC 4180: a field containing a comma, a quote or a line break is wrapped in double quotes, and a double quote inside a field is doubled. That is the form Excel, Google Sheets and pandas all expect.
How large a file can I paste? Anything a browser tab can hold, but the preview only renders the first 100 rows; the copied or downloaded file always contains every row.