JSON to Table
Paste JSON, read it as a table, sort by any column and export it as CSV.
Paste JSON above to see the table
Nested values are flattened into dot-path columns like user.name; arrays are shown as JSON text in a single cell.
Processed entirely in your browser — nothing is sent to a server.
About this tool
JSON to Table turns hard-to-scan JSON into a table you can read at a glance, sort by any column, and export as CSV for Excel or Google Sheets.
The problem it solves is reading a long list — orders, users, log entries — that runs to hundreds of lines once it is pretty-printed, making it impossible to compare one entry against another. As a table, the shape of the data is obvious immediately.
Two things set it apart from a naive converter. First, nested values are flattened into columns like address.city instead of rendering as [object Object]. Second, the columns are the union of every row, not just the first one — so a field that only appears on some records still gets a column instead of vanishing silently.
Parsing, sorting and CSV export all run in your browser. Nothing is uploaded. Free, with no sign-up.
How to use
- 1Paste JSON — an array of objects, or a single object — into the input box
- 2It becomes a table straight away, with the row and column count shown
- 3Click any column header to sort ascending or descending
- 4Download as CSV to open it in Excel or Google Sheets
Frequently asked questions
- How are nested objects displayed?
- They are flattened into dot-path columns such as address.city, so you see the real value instead of [object Object]. Arrays stay as JSON text in a single cell, because expanding them would make the column count unpredictable.
- What if some rows are missing a field that others have?
- Every field that appears in any row gets its own column, and rows without it are left blank. Nothing is dropped, so a ragged API response still shows all of its data.
- Does it handle a single object, or data keyed by id?
- Both. A single object becomes one row. An object whose values are all objects — the common "keyed by id" shape — becomes one row per entry, with the key kept as the first column.
- Why are only some rows shown?
- The table renders up to 500 rows to keep the page responsive, and tells you exactly how many are hidden. Download the CSV to get every row.
- Is my file uploaded?
- No. Parsing, sorting and CSV export all happen in your browser.