How to Convert JSON to a Table for Analysis and Reporting

JSON is the native format of APIs, but tables are how humans read data. Converting JSON arrays to tables immediately reveals schema drift, missing values, and structural patterns that are invisible in raw JSON. Use our JSON to Table converter to visualise any JSON array in seconds.

Which JSON Shapes Produce Good Tables

Arrays of objects where each object has similar keys produce the cleanest tables. Each object becomes a row and each unique key across the entire dataset becomes a column. Single objects render as a one-row table. Scalar arrays produce a single-column value table.

Handling Nested Objects

Nested objects are flattened using dot notation. A field like {"user": {"address": {"city": "London"}}} becomes a column named "user.address.city". This makes deeply nested API responses browsable in a spreadsheet-style grid without manual restructuring.

Missing Keys Across Rows

When rows have different keys — common in semi-structured API responses — columns are inferred from the union of all keys. Rows that lack a column show null. This ensures the table always has consistent headers regardless of which fields appear in which records.

Exporting Tables to CSV

Once the JSON is rendered as a table, click Export CSV to download the full dataset as a comma-separated file ready for Excel, Google Sheets, or data analysis tools. All columns including flattened nested fields are included in the export.