Tool Kumar tool
JSON to table
Paste an array of JSON objects to see it as a table, with one row per record and one column per key. Sort by any column, open nested objects and arrays in place, and export what you see.
How to use this tool
- Paste a JSON array of objects, or open a file.
- Read it in the Table view. Click a column header to sort by it, and click again to reverse the order.
- Click a nested object or array to open it as a table of its own; the path above the table leads back. The More options menu copies the table as CSV or downloads CSV or Excel.
Worked example
One row per user and one column per key. The nested address object stays a single cell you can open, and a missing value shows as a dot.
Input
[{"id":1,"name":"Ada","role":"admin","active":true,"address":{"city":"London","zip":"N1"}},{"id":2,"name":"Lin","role":"editor","active":false,"address":{"city":"Oslo","zip":"0150"}},{"id":3,"name":"Sam","role":"viewer","active":true}]Output
# id name role active address
0 1 Ada admin true {2}
1 2 Lin editor false {2}
2 3 Sam viewer true ·Options and edge cases
- Columns are the keys found across the records, up to 120 columns.
- An object works too: each key becomes a row.
- Nested values stay nested in the grid. The CSV and Excel exports flatten nested objects into dotted columns such as address.city.
- Only the rows on screen are drawn, so long arrays scroll smoothly.
Private by default
Your document stays in this browser. Tool Kumar parses, converts and creates downloads on your device, with no account or upload step.
JSON to table questions
- How do I convert JSON to a table?
- Paste a JSON array of objects. The Table view shows one row per object and one column per key; export it as CSV or Excel when you need a file.
- Can I view nested JSON in a table?
- Yes. Nested objects and arrays appear as cells you can open, each as a table of its own, with a path to go back.
- Can I sort the table?
- Yes. Click a column header to sort by it, and click it again to reverse the order.