JSON → Table Converter

Convert a JSON object array into a rows-and-columns table and export to CSV.

Category: Dev Tools

When to use?

Use it to compare JSON arrays like API responses or log data at a glance, to review JSON as a table, or to export to CSV.

How to use

  • Paste a JSON object or object array.
  • A table appears with all keys as columns and each object as a row.
  • Copy as CSV to use in Excel/spreadsheets if needed.

Input Explanation

Enter an object array ([{...}, {...}]) or a single object. Even if rows have different keys, all keys are gathered as columns.

Calculation Basis

It parses the JSON, gathers all objects' keys into table columns, and expands each object into a row. Nested objects/arrays are shown as JSON strings.

Usage Examples

  • Review API responses - Expand a JSON API response into a table to compare values.
  • Tidy data - Organize JSON data into a table to find missing values or outliers.
  • Export to CSV - Convert a JSON array to CSV to open in Excel.

Examples

  • [{ "id": 1, "name": "A" }, { "id": 2, "name": "B" }] → an id·name 2-column table
  • Copy the table as CSV to paste into a spreadsheet

Cautions

  • Generated output is for reference; test carefully before production use.
  • Arrays or sub-objects nested 3+ levels deep are simplified to strings in table cells.

Guides

How columns are built

It gathers all objects' keys into table columns. Even if rows have different keys, all keys become columns, and missing cells are blank.

Nested data and CSV

Nested objects/arrays are shown as JSON strings. Copy the whole table as CSV to open directly in Excel or a spreadsheet.

FAQ

What if rows have different keys?

It gathers all keys into columns; missing cells are shown blank.

How are nested objects shown?

Nested objects or arrays are shown as JSON strings in cells.

Can I export to CSV?

Yes. The "Copy CSV" button copies the whole table as CSV.

Is a single object converted?

Yes. A single object is shown as a one-row table.

Related Tools