🏠 Home›Code Tools›JSON to Table, CSV & Excel

📊 JSON to Table

Convert JSON into a table and export as CSV or Excel. Paste JSON or upload a file — free, instant, works entirely in your browser.

About This Tool

This tool turns JSON data into a readable table, then lets you export it as a CSV or Excel (.xlsx) file — useful when you have API responses, config data, or exported JSON that someone needs to open in a spreadsheet instead. Paste JSON directly or upload a .json file. Nested objects are automatically flattened into dot-notation columns (e.g. address.city), and nested arrays are shown as their JSON text in a single cell, since a spreadsheet can't represent deep nesting directly. If your JSON objects have different sets of fields, the table includes every field as a column, leaving blank cells where a particular row doesn't have that field. Everything happens locally in your browser — no file is uploaded to a server.

Common Use Cases

  • Converting an API response into a spreadsheet for a non-technical teammate
  • Exporting JSON config or data files to CSV for use in Excel or Google Sheets
  • Quickly previewing the shape of a JSON array as a table before writing code against it
  • Turning exported JSON data (from another tool or database) into an Excel report

Frequently Asked Questions

What JSON shapes does this support?

An array of objects works best, converting into one row per object. A single JSON object is also supported and becomes a one-row table.

What happens to nested objects and arrays?

Nested objects are flattened into columns using dot notation (e.g. address.city). Nested arrays can't be represented as table columns, so they're shown as their raw JSON text in a single cell.

What if my JSON objects have different fields?

The table includes every field found across all objects as a column. Rows missing a particular field show a blank cell for it.

Is my JSON data uploaded anywhere?

No. Parsing, table conversion, and CSV/Excel export all happen locally in your browser — nothing is sent to a server.

More in this category

|🏠 Home|
|