1. Home
  2. Spreadsheets & Data
  3. JSON to Table

JSON to Table

Paste JSON or drop a file and get a sortable table.

Runs in your browser · No upload
Choose columns (7/7)
#
1A-1001Jane DoeVIPT-shirt, Cap34.9true
2A-1002John SmithStandardSocks5.9falseLeave at door
3A-1003Ann LeeVIPHoodie, Gloves, Scarf128true
Showing 3 of 3 rows
Rows
3
Columns
7
Export (visible columns, with the current sort and search)
Result
orderId,customer.name,customer.tier,items,total,paid,note A-1001,Jane Doe,VIP,"T-shirt, Cap",34.9,true, A-1002,John Smith,Standard,Socks,5.9,false,Leave at door A-1003,Ann Lee,VIP,"Hoodie, Gloves, Scarf",128,true,

Your JSON and files are processed in this browser and never uploaded.

How to use

  1. Paste JSON into the box or drop a .json, .jsonl or .ndjson file. Files up to 20 MB are read.
  2. The table appears right away. Nested objects become dotted column names such as customer.name.
  3. Click a column header to sort ascending, again for descending, a third time to restore the original order. The search box looks through the columns that are currently visible.
  4. Use Choose columns to hide what you do not need. Hidden columns are left out of the export too.
  5. Pick an export format (CSV, TSV, Markdown, HTML or JSON), then copy or download. The export uses exactly what is on screen: the visible columns, the sort and the search result.

Shapes of JSON that work

What you paste How it becomes a table
An array of objects [{...}, {...}] One item per row
An object wrapping an array, like {"orders": [...]} The largest array of objects is used as the rows. If there are several candidates, choose one under Use as rows
{"kim": {...}, "lee": {...}} The keys become row names in a key column
An array of values [1, "x", null] A single value column
A 2D array [[1,2],[3,4]] Columns named 0 and 1
JSON Lines, one value per line One line per row

Example

This JSON holds three orders. Converted with the default settings it looks like this.

{"orders": [
  {"orderId": "A-1001", "customer": {"name": "Jane Doe", "tier": "VIP"}, "items": ["T-shirt", "Cap"], "total": 34900, "paid": true},
  {"orderId": "A-1002", "customer": {"name": "John Smith", "tier": "Basic"}, "items": ["Socks"], "total": 5900, "paid": false, "note": "leave at door"}
]}
orderId customer.name customer.tier items total paid note
A-1001 Jane Doe VIP T-shirt, Cap 34900 true
A-1002 John Smith Basic Socks 5900 false leave at door

note exists only in the second order, so it becomes a column and the missing cell is blank.

Options

Option What it does
Array cells: Auto Arrays of plain values are joined with commas in one cell. Arrays that contain objects are spread into columns like items.0.name
Array cells: Spread into columns Even value arrays become items.0, items.1 columns
Array cells: Join / One JSON cell Keep each array in a single cell. Useful when you would otherwise get too many columns
Array column names items.0.name (dot) or items[0].name (brackets)
Spread depth With 1 level, inner objects stay as one cell of JSON text like {"name":"Jane Doe",...}
Show null as blank Turn it off to print null

Good to know

  • Column order is the order of first appearance. A key that first shows up in a later row is added at the right end.
  • Big numbers and their notation are kept as written. 12345678901234567890, 10.50 and 1e3 would turn into 12345678901234567000, 10.5 and 1000 if read as JavaScript numbers, but this tool puts the original text in the table.
  • A key that contains a dot ("a.b": 1) is shown as a\.b so it stays distinct from b inside a nested a.
  • Limits are 50,000 rows, 500 columns and 20 MB per file. Beyond that only the beginning is kept and a notice explains it. Nesting is read up to 200 levels.
  • A syntax error is reported with its place and cause, like Line 3, column 8: Unexpected character "x". Trailing commas, single quotes and unquoted keys are the usual causes.
  • The table draws 200 rows at a time; the Show 200 more rows button adds more. The export contains every row that matches the search.
  • When saving CSV, values starting with =, + or @ can run as formulas in Excel, so an option that prefixes them with ' is on by default. Plain numbers such as -3 or +1.5 are left alone. A UTF-8 BOM is added by default so Excel reads non-English text correctly.
  • In Markdown, a | inside a cell becomes \| and a line break becomes <br>. In HTML every value is escaped.

FAQ

How do I turn JSON into Excel?

Copy the TSV output and paste it into Excel; the columns split automatically. To get a file, download the CSV and open it in Excel. For a real .xlsx, continue with CSV to Excel Converter.

My nested arrays make too many columns, or get crammed into one cell.

Change Array cells. Choose “Join with commas” when there are too many columns, or “Spread into columns” when a single cell is hard to read.

Does an API response like {"data": [...], "total": 100} work?

Yes. The tool finds the array, uses it as the rows, and lets you pick another one under Use as rows if there are several.

How is this different from a JSON to CSV converter?

JSON to CSV Converter shows the conversion as text and goes both ways between JSON and CSV. This tool lets you look through the data as a table first, sort, search and choose columns, and then export.

I only want to flatten nested JSON into one level.

Use JSON Flatten & Unflatten to get keys like a.b.0.c and to turn them back.

Related tools: JSON Formatter, CSV Table Viewer, Markdown Table Generator, Excel & CSV Workbench

Your JSON and files are processed in this browser and never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.