How to use
- Paste JSON into the box or drop a
.json,.jsonlor.ndjsonfile. Files up to 20 MB are read. - The table appears right away. Nested objects become dotted column names such as
customer.name. - 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.
- Use Choose columns to hide what you do not need. Hidden columns are left out of the export too.
- 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.50and1e3would turn into12345678901234567000,10.5and1000if 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 asa\.bso it stays distinct frombinside a nesteda. - 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-3or+1.5are 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.