Skip to tools

YYTOOLS / THE EVERYDAY TOOLBOX

JSON to Excel

Convert JSON objects to an Excel workbook, preview and download XLSX.

Processed locally · No upload · No sign-up

01 / INPUT

Add your data. Make it useful.

Choose a file or paste text. Your data stays in this browser.

Up to 5,000 data rows, 200 columns and 100,000 data cells. Input: 0 / 2,000,000 characters. Files must use UTF-8.

Run again after editing input or options.

How to use

  1. Choose a file or paste data. For Excel, select a worksheet.
  2. Adjust options, run the tool, then check the preview or error message.
  3. Review row and column counts, then copy or download the complete result. Run again after editing input.

Automatically detects the object array (e.g. data) and expands it into rows; choose the data list before generating a file. Nested objects flatten into a.b.c columns; arrays become JSON text; null and missing values become blank. Safe numbers and booleans keep their types. Quote large integers as strings. The output sheet is named Data.

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

Keep working with your data

JSON to Excel | YYTools.cc