JSON to Table (JSON to HTML Table)

API responses and exported data are usually a JSON array of objects, which is hard to scan as text. This tool lays it out as a table: one row per object, one column per key, with nested objects flattened into dot-path columns such as address.city. It then gives you the same table as HTML code, CSV or TSV to copy into a web page, an e-mail or a spreadsheet. If you paste a whole response, it finds the array of records by itself.

How to use this tool

1. Paste the JSON — an array, an object, or a response that contains an array.
2. Optionally enter the path to the array you want (data.items).
3. Choose how nested objects and arrays inside rows are shown.
4. Pick the code to copy: HTML table, CSV or TSV.

Formula

columns = every key that appears in any row, in the order first seen · cell = the value at that key path

Rows that lack a key get an empty cell. Nested objects become dot paths (address.city) or stay as JSON text. Arrays of simple values are joined with ", ", kept as JSON, or split into tags[0], tags[1] columns; arrays of objects stay JSON unless split. Numbers are copied with exactly the digits they were written with. HTML output escapes &, <, >, " and ' so data cannot break the markup.

Example

The sample has three people. The table gets 8 columns: id, name, email, address.city, address.zip, tags, active and score. Ada's tags become admin, beta; Lin Wei has no email or zip, so those cells are empty; O'Brien & Sons has null email (empty) and a score of 9.5. In CSV, admin, beta is quoted because it contains a comma.