XLSX to JSON
Convert to
Tools for this file
Your files never leave your device.
The first row becomes the keys and every row after it becomes one object. A workbook with several sheets gives one list per sheet.
Questions about XLSX to JSON
How does XLSX to JSON work?
XLSX to JSON turns the rows of an Excel workbook into JSON objects, for apps, scripts and APIs. Numbers and true/false keep their types, dates become ISO dates like 2024-01-15, and formulas give their results.
What does the JSON look like?
For a single sheet, an array of objects such as [{"Name": "Ada", "Joined": "2024-01-15", "Score": 92}]. Empty cells are null, completely empty rows are skipped, and the file is pretty-printed.
Are number formats like currency or percent kept?
No, you get the underlying value. A cell showing £1,234.50 becomes 1234.5 and one showing 25% becomes 0.25. If you need the text as displayed, convert to CSV instead.
What if a column has no heading?
It gets the key column1, column2 and so on, by its position. If two columns share a heading, the second becomes Heading_2, the third Heading_3.