Excel to JSON
Converts an Excel (.xlsx) worksheet into an array of JSON objects, keeping numbers, dates and boolean values.
Table
JSON
JSON longer than a million characters is not shown in the field; copy it or download it as a file.
Notes
Open an .xlsx workbook and pick a worksheet. The first non-empty row of the sheet gives the field names, and every row after it becomes a JSON object.
What the values look like
Numbers and boolean values are written as numbers and true or false, and text as a string. Excel stores dates as numbers, so a date is recognized by the cell format and written as 2026-09-17, and a time as 10:30:00. For a formula, the tool takes the value that Excel calculated.
Duplicate column names
A JSON object cannot have two fields with the same name. A second column named "Sum" gets the name "Sum_2", and a column with no name gets a letter, the same as in Excel. Old-format .xls workbooks are not read: save such a workbook as .xlsx first.
Rate this tool
Help us get better
Tell us what was missing.
Other tools
JSON Formatter
Format and repair JSON in the browser, flagging duplicate keys and long numbers
Regex Tester
Regex testing with a plain-language breakdown and hang protection
JWT Decoder
JWT parsing with fields explained and signature verification
CSV to JSON
A table to JSON with honest types and a reverse check
JSON to CSV
JSON to a table for Excel, with verification and formula protection
SQL Formatter
A readable query layout, verified against the source, with risky spots flagged
XML Formatter
Readable XML, errors explained with a hint, verified against the source
XML Validator
Markup, XSD schema, sitemap, YML and RSS rules, with the path to each error