JSON to Excel
Fast, secure, and free document conversion.
Drop JSON file here
Turn JSON records into a spreadsheet
MAX 100MB
About JSON to Excel
JSON is how systems exchange data; a spreadsheet is how people examine it. Converting an export, an API response or a log dump into XLSX puts it somewhere you can sort, filter and pivot without writing any code.
How to use it
- Upload a .json file.
- Convert it to a spreadsheet.
- Download the XLSX and open it in Excel, Numbers or Sheets.
Worth knowing
Three shapes are handled: an array of objects becomes one row per object, an object wrapping such an array uses that array, and a plain list of values becomes a single column. Nested objects are flattened into dotted column names, so address.city and address.zip each get their own column.
Common questions
- What if my JSON is deeply nested?
- Nesting is flattened into dotted column headings. Very deep structures produce a lot of columns, and arrays inside a record stay in one cell rather than expanding into rows.
- Will leading zeros survive?
- Values that are strings in the JSON are written as text, so a postcode like 0150 keeps its zero. Whether your spreadsheet program then re-reads it as a number is up to its own import settings.