Excel tool

JSON to Excel Converter

Turn API responses and JSON exports into an XLSX workbook. Select a records array, choose how nested values become rows or columns, and review the data before downloading.

Private by designRuns in your browser
Recent tools
Ctrl / ⌘ + Enter to run

Loading workspace…

Preparing the controls for this tool. Your files have not been selected or uploaded.
QUICK START

How to use JSON to Excel

  1. Upload a JSON or TXT file, or paste JSON and select Inspect pasted JSON. Choose the records array for each source.
  2. Choose the output layout and nested-data mode. Source traceability and a summary sheet are optional.
  3. Select Preview merged data, then choose output columns and their types. Keep leading-zero codes as Text or their existing string type.
  4. Select Convert to Excel, review the worksheet summary and preview, and download the XLSX. Reopen it to verify rows and identifiers.
BEFORE YOU BEGIN

What to expect

Preview nested layouts and column types before exporting. Quote identifiers at the source to retain leading zeros and avoid numeric precision loss.

Local processing

Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.

Example: a product code and a numeric amount

Code is a quoted string; Amount is a JSON number. Keeping their types exports 0012 as text and 42 as a number. In JSON text mode, address becomes JSON text in one cell. Flattened mode instead creates an address.city column.

Input:
[{"Code":"0012","Amount":42,"address":{"city":"Surat"}}]
Flattened columns: Code | Amount | address.city
Row:               0012 | 42     | Surat

How nested objects and arrays are handled

JSON text cells serialize nested objects and arrays into cells. Flattened columns use dot paths, including array indexes such as items.0.sku. Linked sheets place array children on separate sheets with parent identifiers; parent–child mode puts those records into the same sheet. Non-array nested objects remain JSON text in the linked and parent–child modes. Review the worksheet summary because nesting can add rows, columns or sheets.

Columns, types and leading zeros

Object keys form columns; keys found in later records are included, with absent values left blank. The preview offers column selection and Keep, Text, Number and Boolean types. Quoted codes such as "0012" retain zeros unless converted to Number. Numeric 12 cannot recover an unknown original width. Long identifiers should be strings before parsing; large JSON numeric literals may already lose precision.

Input and output considerations

Use standard JSON without comments or trailing commas. Inputs accept up to 10 JSON/TXT files, 20 MB each and 75 MB total. Output limits include 50,000 rows, 500 columns, 500,000 cells and 30 sheets, with additional nesting guards. Flattened path collisions are rejected; JSON text mode can avoid them. Optional traceability columns contain source labels in your local workbook, not in analytics.

HELP & TROUBLESHOOTING

Frequently asked questions

Can I convert an API response containing a records array?

Yes. Select the discovered array path after inspection, such as /records. A non-empty object can also be treated as a record.

How do I keep leading zeros?

Quote the identifier in JSON, then retain its string type or choose Text. Choosing Number intentionally converts "0012" to 12.

Will nested arrays create extra worksheets?

Linked sheets mode creates child sheets for arrays. JSON text mode keeps them in cells; flattened mode uses indexed columns; parent–child mode shares one sheet.

Why are extra source columns or a summary sheet present?

Traceability and summary options add them. Turn off those options before conversion when you only need your original fields.

Where is my input processed?

Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.