Record-path selection
Candidate arrays are listed so you can decide which level represents spreadsheet rows.
Nested JSON conversion without silent number rounding
Convert JSON to XLSX locally with record-path selection, explicit array strategies, flattened field previews, duplicate-key checks, and lossless handling for long numeric IDs.
Conversion workbench
Source structure, quality findings, and every deliberate transformation stay visible before download.
Paste JSON or upload a JSON file
Nothing ambiguous is hidden behind “auto.”
Analyze the sample or your own data to continue.
Analysis creates a table preview, a ranked issue list, and an exact transformation summary.
Source bytes remain in this browser tab.
Preview values and risks before export.
Download a JSON conversion report.
What the converter checks
A successful parse is not proof that the result kept the source meaning. These checks surface the places where tabular conversion can change or hide data.
Candidate arrays are listed so you can decide which level represents spreadsheet rows.
The original JSON number text is retained. Unsafe or 16+ digit values are written as XLSX text cells.
Keep arrays as JSON, join scalar arrays, or expand one selected array—never an automatic multi-array cross product.
Literal dotted keys stay distinct from nested paths, and duplicate JSON object keys block conversion.
Preservation rules
The tool records deliberate changes and keeps ambiguous structures visible rather than silently normalizing them.
Read the full check definitions →Original digits are preserved and written as text cells when numeric precision is unsafe.
Flattened into escaped path columns such as profile.name.
Stored as JSON text by default; alternative handling is always explicit.
Shown as missing cells and counted, rather than confused with source empty strings.
A short, inspectable workflow
Paste a document or choose a local JSON file. Parsing stays inside the browser.
Confirm the record path and how any nested array should be represented.
Review types, missing fields, and transformations before creating the workbook.
A concrete failure mode
A 19-digit integer can be rounded before an exporter sees it. DataFormatKit validates duplicate keys, reads the source number text, and writes unsafe identifiers as Excel text cells so the workbook keeps every digit.
Inspect the included example