Skip to content
{ }JSON Formatter

JSON to Table Viewer

Render a JSON array of objects as a clean, sortable table — click a column to sort, copy the whole thing as CSV. The readable way to eyeball a dataset.

JSON (array of objects)
Table

Paste a JSON array of objects to see it as a table.

The fastest way to read a dataset

A JSON array of records is precise but hard on the eyes — you scroll past braces counting commas. As a table it clicks instantly: one row per object, one column per field, aligned so you can scan a column top to bottom. Keys become the header (the union across all rows, so nothing is hidden), and clicking a header sorts the data — numbers numerically, text alphabetically, blanks to the bottom.

Nested values, honestly shown

Real data has nested bits. A cell holding an object or array is shown as compact JSON rather than blowing up the layout, so the table stays flat and legible. Want those nested fields as real columns? Run the data through JSON Flatten first — its dot-notation keys become extra columns here.

Straight into a spreadsheet

Copy as CSV puts the current table (in its sorted order) on your clipboard, ready to paste into Excel or Google Sheets. For a downloadable .csv with delimiter options, the JSON to CSV converter is the dedicated tool — this page is about seeing the data quickly.

Frequently asked questions

What JSON works here?

An array of objects — each object is a row, and the union of all keys becomes the columns. Objects with different keys are fine: missing cells are shown empty. A single object is shown as a one-row table.

How are nested objects and arrays shown?

Cells that hold an object or array are displayed as compact JSON text, so the table stays flat and readable. Flatten the data first (JSON Flatten) if you want nested fields as their own columns.

Can I sort the table?

Yes — click any column header to sort ascending, click again for descending. Sorting is type-aware: numbers sort numerically, strings alphabetically, and empty cells sink to the bottom.

Can I get the data back out?

Copy as CSV puts the table on your clipboard for a spreadsheet. For a downloadable file or other formats, the JSON to CSV converter has more options.

Is my data uploaded?

No — the table is rendered entirely in your browser from the JSON you paste. Nothing is sent anywhere.

JSON ViewerExplore JSON in a collapsible tree, search keys and values, copy JSONPath.JSON SorterSort object keys alphabetically (A–Z or Z–A), recursively, for stable diffs.JSON EscapeEscape text so it is safe to embed inside a JSON string value.JSON UnescapeDecode escaped JSON strings back to plain readable text.JSON DiffCompare two JSON documents structurally — key order and formatting ignored, only real changes shown.JSONPath TesterEvaluate JSONPath expressions live — wildcards, recursive descent, slices, filters — with a cheat-sheet.