What this does
Shows a JSON array of objects as a table: one row per item, one column per key. Click a column header to sort (ascending, descending, off), type in the filter box to search every cell, and page through large arrays 100 rows at a time.
Columns are the union of all keys in first-seen order. A key that a row does not have is shown as an empty cell, which is different from an explicit null, shown in italics.
Nested data
With Flatten nested objects on, a value like {"address": {"city": "London"}} becomes a column named address.city; you can change the separator. Arrays are shown as compact JSON text inside their cell.
Other shapes
- An object of objects (for example records keyed by ID) becomes a table with a
(key)column. - A plain object becomes a two-column key/value table.
- An array of non-objects gets a
(value)column.
Export
Copy puts the currently filtered and sorted rows on your clipboard as tab-separated text, ready to paste into a spreadsheet. Download saves them as a CSV file with proper quoting.
At most 300 columns are shown; the tool tells you when columns were left out.
Privacy
Everything runs in your browser. Your input is never uploaded, stored, or put in the page URL.