Skip to main content
JSON‑Table

Tables

How to view JSON as a table

A list of JSON records is really a table in disguise — rows and columns wrapped in braces. Seeing it as a grid lets you sort, filter, and scan it the way you would a spreadsheet. Here's how the mapping works.

Updated July 20264 min read

Which JSON becomes a table

The natural table shape is an array of objects, where each object is a record and the keys are the fields:

[
  { "id": 1, "name": "Ada",  "role": "admin"  },
  { "id": 2, "name": "Linus","role": "editor" },
  { "id": 3, "name": "Grace","role": "admin"  }
]

That maps cleanly onto a grid: three rows, and columns for id, name, and role. The header row is derived from the keys automatically, so you never define columns by hand.

How to convert JSON to a table

With the JSON to Table converter:

  1. Paste or open JSON containing an array of objects (files up to 10 MB).
  2. Columns appear automatically, one per key, with each object as a row.
  3. Sort by any column, add per-column filters, drag to reorder columns, and edit cells inline.

Handling messy, real-world data

Objects with different keys

Records rarely have identical fields. When one object has a key another lacks, the column still appears and missing cells are simply empty — you don't lose any data, and you can see at a glance which rows are incomplete.

Nested objects and arrays

A field whose value is itself an object or array doesn't flatten well into one cell. Instead of cramming it in, nested values open into their own nested table, so you can drill in without losing the top-level view.

Very large arrays

Tables with tens of thousands of rows stay responsive because the grid is virtualized — only the visible rows are rendered — and columns are inferred from a sample rather than every row. For the biggest documents, the workspace pairs the grid with a tree so you can navigate structure and data side by side.

What you can do once it's a table

  • Sort by any column to find the largest values or group similar rows.
  • Filter per column to narrow thousands of records down to the ones you care about.
  • Reorder columns so the fields you're comparing sit next to each other.
  • Edit inline to fix a value, then read the updated JSON back out.

Frequently asked questions

How do I turn JSON into a table?

Load JSON that contains an array of objects. Each object becomes a row and the keys become columns automatically — no conversion step or script required.

What shape of JSON works best as a table?

An array of objects with overlapping keys, like a list of records. Deeply nested or irregular data still works — nested values open into their own tables.

Can I sort and filter the table?

Yes. You can sort by any column, apply per-column filters, reorder columns by dragging, and edit values inline.

Do I need to upload my file?

No. The conversion runs in your browser with JSON-Table, so your data stays on your machine.

Try the tools