JSON to Table
Open an object, an array of objects or NDJSON as a sortable table. Expand nested fields, filter rows, and export the current order as CSV or exact JSON records.
Sort Exact IDs in Nested JSON Records
Find & replace in input
Undo: Ctrl/Cmd+Z · Redo: Ctrl/Cmd+Shift+Z or Ctrl+Y. Up to 20 steps and 4 million retained characters in this tab. Clear discards history.
JSON to Table: how to use it
- Paste JSON, open a local UTF-8 file or load the example. For a nested array, enter its JSON Pointer in Record pointer.
- Render the table. Sort a column from its heading, search cell values and filter by the type present in a row.
- Download the matching rows as CSV or copy them as JSON. Both exports follow the selected sort and filter across all pages.
Limits and notes
Up to 4 MiB per file, 10,000 records, 128 columns and 250,000 table cells. Each row must be an object with unique JSON keys. One level of object fields can become separate columns. Array values and deeper containers stay in single cells.
How your privacy works →JSON to Table: common questions
Can I sort IDs past JavaScript’s safe integer range?
Yes. Numeric sorting compares the exact JSON number tokens, and the downloaded JSON keeps their original spelling. Import large IDs as text when a spreadsheet rounds them.
What is the difference between null, missing and an empty string?
The table marks all three separately. CSV writes null literally and uses empty cells for missing or empty-string values. The JSON rows preserve the source distinction.
Which rows will the download include?
The export uses every row matching the filters in the current sort order, across all result pages. The original JSON object structure stays intact in JSON exports.