Skip to content
DYNAMB

JSON to Excel converter

Paste a JSON array of objects — an API response, an export from a database tool — and get back a real .xlsx spreadsheet, converted entirely in your browser. Nested objects are flattened into dotted column names like address.city, and the preview shows exactly what will be written before you download.

  • Nothing you type leaves this page
  • Works offline once loaded
  • Free forever, no signup

One or more fields held an array — each was kept as its JSON text in a single cell rather than dropped or split into extra rows.

Nested objects like address.city are flattened into dotted column names automatically.

How to use this tool

  1. Paste a JSON array of objects

    Or a single object — it is wrapped as a one-row table automatically.

  2. Check the preview table

    Nested fields appear as dotted columns; arrays are kept as their JSON text in one cell.

  3. Convert and download the .xlsx

    Name the sheet, then download.

Questions people ask

What does this tool do with nested objects, like an address field?

Nested objects are flattened one level (and further, recursively) into dot-notation columns — {"address":{"city":"Delhi"}} becomes a column named address.city. Nothing is dropped; it is just spread into more columns.

What happens to array fields, like a list of items on an order?

An array inside a record is not exploded into extra rows or silently discarded — it is kept as its JSON text (for example ["pen","notebook"]) in a single cell, and the tool tells you when this happened so it is never a silent surprise.

Will a long ID number turn into scientific notation?

Not unless you ask for it to. "Parse numbers" is off by default, so every value — including a long invoice ID or a code with a leading zero — is written as text, exactly as it appeared in the JSON.

What if my JSON is not an array?

A single JSON object is automatically wrapped into a one-row table. Anything that is not an object or an array of objects — a bare string or number, for example — is reported as an error rather than converted into something misleading.

Is my JSON sent anywhere?

No — parsing, flattening and building the spreadsheet all happen in your browser's JavaScript. There is no upload endpoint on this page.

Related tools

Bookmark this page — the tool keeps working offline, and your settings stay in this browser. Built by Dynamb Technologies, who make software for a living.