JSON to Table Viewer
Paste a JSON array of objects to see it as a table you can sort, filter and export.
Everything runs in your browser — your JSON never leaves this page.
How it works
- Paste a JSON array of objects into the input box — the table renders instantly as you type.
- Click any column header to sort by that key, or type in the search box to filter rows.
- Use Copy as CSV or Copy as Markdown to export exactly the rows and order you see.
Frequently asked questions
- What JSON structure does the table viewer expect?
- It works best with an array of objects, such as a typical REST API response. The columns are the union of all keys found across the objects, so rows with missing keys simply show empty cells. A single object or an array of plain values is also accepted and shown as a one-column or one-row table.
- How are nested objects and arrays displayed?
- Nested values are stringified into compact JSON and shown inside the cell, so a field like address: {city: "Rome"} appears as {"city":"Rome"}. This keeps the table flat and readable while preserving the full data. Sorting on such a column compares the stringified text.
- Does sorting handle numbers correctly?
- Yes. When every non-empty value in a column is numeric, the viewer sorts numerically, so 2 comes before 10. Mixed or text columns fall back to case-insensitive alphabetical order, and clicking the same header again reverses the direction.
- Is my JSON uploaded anywhere?
- No. Parsing, sorting, filtering and export all run in JavaScript inside your browser tab, and the page makes no network requests with your data. You can safely paste API responses that contain private or internal information.
- What do the CSV and Markdown export buttons copy?
- They copy the current view — after any search filter and sort you have applied — to your clipboard. CSV output quotes fields containing commas, quotes or line breaks so it opens cleanly in Excel or Google Sheets. The Markdown version is a pipe-delimited table ready to paste into GitHub, Notion or a README.
About this tool
JSON to Table Viewer turns a raw JSON array into a readable table in one paste. API responses, database exports and log dumps are easy for machines to parse but hard for people to scan; laying the same data out in rows and columns makes it obvious which records exist, which fields are missing and where the outliers are. The table renders live as you type, and parse errors are reported immediately with the reason, so you also get a quick sanity check that your JSON is valid.
Everything happens client-side. The tool parses your text with the browser’s native JSON engine, collects the union of keys across all objects to build the column set, and renders the rows directly — nothing is sent to a server, which matters when the payload contains customer records or internal identifiers. Nested objects and arrays are stringified into compact JSON so the table stays flat, and null or missing fields appear as empty cells rather than breaking the layout.
Sorting and filtering work the way you would expect from a spreadsheet. Click a header to sort ascending, click again to reverse; columns made up entirely of numbers sort numerically, everything else alphabetically. The search box filters rows by matching any cell, and the row counter shows how many of the total rows are currently visible — a fast way to answer questions like how many users have a given status.
When the view looks right, export it. Copy as CSV produces a properly escaped file body for Excel, Google Sheets or further scripting, while Copy as Markdown gives you a table you can drop straight into a pull request, issue or documentation page. Both exports respect the active filter and sort order, so what you see is exactly what you get.