Updated
Using Excel JSON converter
JSON uses an array of row arrays so duplicate or blank column headings remain possible. Cell values may be strings, finite numbers, booleans or null. XLSX formulas export as objects containing the formula and its cached result; dates become ISO timestamps. Formatting is omitted.
A worked example
The JSON example [["Name","Count"],["Octopus",8]] writes a worksheet where 8 is a number, then preserves that type on export.
Before you use the result
JSON uses an array of row arrays so duplicate or blank column headings remain possible. Cell values may be strings, finite numbers, booleans or null. XLSX formulas export as objects containing the formula and its cached result; dates become ISO timestamps. Formatting is omitted.
Cite this page
ToolOctopus. “Excel JSON converter.” Updated 2026-09-29. https://tooloctopus.com/excel-json-converter.
Add an access date if your instructions require one.
Citation formatting uses citeproc-js by Frank Bennett and Citation Style Language styles. Licence and source code.
