XLSX to JSON Converter

Choose a workbook. Every sheet is included as a name plus its rows.

Use this tool

Drop a file here, or use the picker. The file type is checked from its contents.

Result

The result appears in this panel after you run the tool.

About this tool

The JSON shape is sheets, then name and rows.

How to use it

  1. Choose an .xlsx file.
  2. Convert it. The JSON has a sheets array.
  3. Each sheet has a name and a rows array. Cached formula values are used.

Limitations

Every sheet in one JSON document

Shape

The text is an object with one key, sheets. The value is an array in workbook order. Each item has name and rows. rows is an array of arrays of strings. Numbers are strings of the cached cell text, or an ISO date when the style is a built-in date format. There is no type tag that says a column was numeric. A later program that needs numbers has to parse them. Empty cells that were present become empty strings. Cells that were never written may make a row shorter than its neighbor. The reader does not pad rows to the width of the widest row.

Formulas and dates

The v element is the value. This page does not include a spreadsheet engine, so it cannot recompute SUM or a volatile function. If the cache is stale because the file was edited by a tool that did not refresh it, you get the stale cache. Date handling matches the CSV page: built-in format ids 14 through 22, 1900 system, serial 1 as 1900-01-01, and the fake leap day skipped so that serial 61 is 1900-03-01. Shared strings are joined when a string was stored as several rich-text runs.

Back to a workbook

JSON to XLSX accepts this shape and writes inline strings. The new workbook will not contain the original styles or the original formulas. It contains the values you see in the JSON. Use XLSX to CSV when you only wanted one sheet and a comma file. Use this page when a script should see Sheet2 without a second conversion. Encrypted workbooks fail before any JSON is shown. Files over 80 MB are refused, and the unpacked XML must stay under 256 MB. Other Office formats, including Numbers, are not workbooks this parser understands.

Privacy

Your input is processed in your browser and is not uploaded to UtilChain. File names, text, and results are not sent to analytics.