convert

JSON to Excel

Turn a JSON array of objects into an Excel spreadsheet, with nested fields flattened into columns.

Runs on your deviceBatch readyPaste textNew

Paste or drop

Paste text below, or drop a file instead.

0 chars · 0 lines
…or drop a file
Drag and drop, or choose files
JSONTXT

Choose an output

Turn a JSON array of objects into an Excel spreadsheet, with nested fields flattened into columns.

Fine-tune

Optional — sensible defaults are already set.

About JSON to Excel

This tool builds a real .xlsx workbook from JSON, with one row per object and one column per key. Nested objects can be flattened into dotted columns such as address.city, which makes API responses readable in Excel, Numbers or Google Sheets. If the JSON is an object that wraps an array, such as {"data": [...]}, the first array inside it is used.

When it helps

  • Turning a REST API response into a spreadsheet for a non-technical colleague.
  • Reviewing exported app data, such as orders, users or logs, with Excel filters and pivot tables.
  • Converting JSON from a database or analytics export for a finance or operations team.

Tips

  • Leave flattening on for nested data. Arrays of plain values are joined into one cell with commas, and arrays of objects are stored as JSON text.
  • With flattening off, nested objects and arrays are written as JSON strings in a single cell, which keeps one column per top-level key.
  • Sheet names are limited to 31 characters, and characters Excel forbids (\ / ? * [ ] :) are replaced with spaces.
  • Columns are collected from all records, so objects with different keys still line up under the right headers.

Good to know

Quick answers about json to excel in your browser.

With flattening on, {"user":{"name":"Ada"}} becomes a column named user.name. Deeper nesting adds more dotted segments, such as user.address.city.

No. Each conversion writes one sheet with the name you choose. For several sheets, convert each array separately and combine the workbooks in your spreadsheet app.

Yes. There is no sign-up, no watermark and no limit on how many files you process.

No. Files are read and processed locally in your browser, so they never leave your device.

Related tools

PDFSheet to XLSXNormalize spreadsheet or delimited data to XLSX.DATEPUB to PDFConvert EPUB text to a simple PDF.DATEPUB to HTMLExtract EPUB spine documents into one HTML file.DATEPUB to TXTExtract readable text from an EPUB.DATCSV/TSV to JSONConvert delimited data to JSON records.DATJSON to CSVConvert a JSON array or object collection to CSV.DATJSON to TSVConvert JSON records to TSV.DATData to HTMLRender data as a portable HTML table.DEVJSON FormatterPretty-print and validate a JSON file with 2-space indentation.

Part of the JSON, YAML & XML Tools collection.