JSON to XLSX

Your files never leave your device.

Choose a format
Choose a format

JSON numbers and true/false keep their types, and text in quotes, like "007", stays text.

Questions about JSON to XLSX

How does JSON to XLSX work?

JSON to XLSX lays out your JSON as an Excel sheet you can sort, filter and share: the keys become the header row, and each object becomes a row underneath.

Can I get several sheets in one workbook?

Yes. Give the JSON as an object whose values are arrays, such as {"Orders": [...], "Customers": [...]}, and each key becomes a sheet with that name. Characters Excel doesn't allow in sheet names (\ / ? * [ ] :) are replaced with spaces, and names are cut to 31 characters.

Will numbers stored as strings become real numbers?

No. The JSON's own types are kept: "42" in quotes stays text, while 42 without quotes becomes a number. If you want numbers you can sum, make sure they are JSON numbers rather than strings.

Is there any formatting in the XLSX?

No. The sheet holds your values only, with no colours, bold headings, set column widths or number formats.