JSON to Excel Converter

JSON API responses often wrap records with metadata.

{
  "page": 1,
  "results": [
    {"id": 1, "name": "Ada"},
    {"id": 2, "name": "Lin"}
  ]
}

The record selector suggests results and shows that it contains two records.

If you select a single object, the tool creates one row. If no tabular record set exists, the preview explains why the structure cannot map cleanly to a worksheet.

Nested objects can use dot-path column names:

customer.name
customer.address.city

• flatten on or off
• path separator
• maximum depth
• preserve values beyond the depth as JSON text

The worksheet preview shows the final headers before the file is generated.

Join Primitive Arrays

A primitive array can become one cell. The default join separator is | .

Keep as JSON Text

Preserve the complete array in one cell when lossless structure is more important than spreadsheet convenience.

The default does not silently drop array items.

When records contain different keys, the tool creates a union of fields across the selected records.

• show missing values as blank or the selected placeholder
• warn when flattening creates duplicate headers
• preserve a deterministic order

A header does not appear twice in the final worksheet.

• JSON numbers → numeric Excel cells
• JSON booleans → boolean cells
• JSON strings → text cells
• JSON null → blank cells

Date-like strings need an explicit option. Automatically turning every ISO-looking string into an Excel date can alter identifiers or source text, so recognized dates are converted only when the option is enabled.

You can set the worksheet name (validated against XLSX naming rules) and the download filename. The sheet name is sanitized automatically if it contains characters that Excel forbids.

The preview shows the selected record path, the record count, the final columns, array and flattening warnings and sample rows before the workbook is generated.

All data appears in one cell

The wrong JSON node was selected or nested values were preserved as JSON text. Choose the record array and enable the appropriate flattening mode.

Arrays are missing values

Change the array strategy. Join, preserve or expand instead of using an unsupported default.

Some columns are blank

The JSON records contain different keys. The workbook uses the union of columns, so missing fields remain blank.

Long numbers changed

Spreadsheet numeric precision may be insufficient. Export identifiers and very large integers as text.

Dates changed format

Keep date-like strings as text or choose a deliberate Excel date conversion. Automatic date handling remains optional.

For large or complex files, start with a representative sample and review the generated output before relying on it.