YYTOOLS / THE EVERYDAY TOOLBOX
Excel to JSON
Turn Excel sheets into JSON for APIs and config imports.
Processed locally · No upload · No sign-up
Add your data. Make it useful.
Choose a file or paste text. Your data stays in this browser.
Choose an .xlsx workbook up to 5 MiB, then select a worksheet.
Up to 5,000 data rows, 200 columns and 100,000 data cells.
How to use
- Choose a file or paste data. For Excel, select a worksheet.
- Adjust options, run the tool, then check the preview or error message.
- Review row and column counts, then copy or download the complete result. Run again after editing input.
Select a worksheet to convert. The first row defines fields. Numbers and booleans keep their types; dates and formatted cells use displayed text. Merged cells and error cells must be corrected first.
Previews show up to 50 rows; downloads contain all results. Limits: 5,000 data rows, 200 columns, 100,000 data cells and 5 MiB per file. Combined exported text and text read from Excel are limited to 10,000,000 characters. Exceeding a limit raises an error; data is truncated only when "Truncate long cells" is enabled, with a count shown.
Supports .xlsx only, not .xls or macro workbooks. Formulas use existing cached values and are not calculated; caches may be stale, and missing caches raise errors. Precision already lost in the source Excel cannot be restored. Exported cell text is limited to 32,767 characters.
Excel processing uses SheetJS CE (Apache 2.0): License and copyright notice