JSON to Table
Instantly render any JSON array of objects as an interactive HTML table with sortable columns, letting you spot patterns and compare records at a glance. The generated table HTML is also available to copy or download, so you can drop it straight into a static page or email. Paste your JSON or load a file — everything is processed client-side with no data ever sent to a server.
Input JSON
What is JSON to Table Converter?
When you receive a JSON API response and need to quickly understand what is in it — how many records, which fields, what the values look like — opening it in a formatter shows structure but not data at a glance. This tool renders a JSON array as an interactive, sortable, searchable HTML table. Click any column header to sort; type in the search box to filter rows across all fields in real time. Nested objects are automatically flattened to dot-notation column names. The column picker lets you show or hide specific fields. Pagination handles large datasets smoothly. You can export the current view as a CSV, or copy the rendered HTML table markup for embedding in documentation or dashboards. It functions as a lightweight, zero-setup data explorer for API responses, database exports, and JSON fixture files.
How to Use
- 1
Paste Your JSON Array
Paste your JSON array of objects into the input area. Each object in the array becomes a table row; the union of all unique keys across objects becomes the column set.
- 2
Customise Columns and Display
Use the column visibility picker to show or hide specific fields, set rows-per-page for pagination, and choose whether to flatten nested objects into dot-notation column names.
- 3
Explore the Interactive Table
Click column headers to sort ascending or descending. Use the search box to filter across all visible columns in real time. Nested object keys appear as dot-notation headers (e.g., address.city).
- 4
Export the Table
Download the filtered, sorted view as a CSV file — or copy the rendered HTML table markup to embed in documentation, dashboards, or static web pages.
Common Use Cases
API Response Exploration
Instantly visualise a REST API response as an interactive table to explore field values, spot missing data, and understand the data shape without writing any code or importing into a spreadsheet.
Data Review Meetings
Convert a JSON dataset to a sortable, searchable table to present during data reviews or stakeholder meetings — more readable than raw JSON and faster to produce than a full dashboard.
QA & Test Data Inspection
Render test fixture JSON or database query results as a table to quickly scan for anomalies, missing values, or unexpected field content during QA and debugging sessions.
Database Query Result Preview
Paste JSON exported from MongoDB, DynamoDB, or a REST API to get an immediate paginated table view — useful for validating query results before building a frontend component.
Conversion Examples
JSON Array → Sortable HTML Table
Each object becomes a row; column headers are derived from the union of all keys.
Input JSON
[
{"id": 1, "name": "Alice", "score": 95, "active": true},
{"id": 2, "name": "Bob", "score": 82, "active": false},
{"id": 3, "name": "Carol", "score": 91, "active": true}
]Output CSV
Interactive table with columns: id | name | score | active Sortable by any column, searchable, paginated. Row 1: 1 | Alice | 95 | true Row 2: 2 | Bob | 82 | false Row 3: 3 | Carol | 91 | true
Nested JSON → Flattened Table Columns
Nested object keys are dot-flattened into separate table columns.
Input JSON
[
{"id": 1, "user": {"name": "Alice", "city": "London"}},
{"id": 2, "user": {"name": "Bob", "city": "Paris"}}
]Output CSV
Columns: id | user.name | user.city Row 1: 1 | Alice | London Row 2: 2 | Bob | Paris