Local browser tool

XLSX to JSON

Export every worksheet as row objects or arrays without evaluating formulas.

● Selected files stay on this device

Choose XLSX workbook

Drop a file here or browse your device

Steps

How to use XLSX to JSON

  1. Choose a workbook.
  2. Choose objects using row one as keys or arrays retaining all rows.
  3. Download one JSON or a ZIP.

Worked example

Create API seed data

A sheet begins id,name and contains 001,Ada and 002,Zoë.

Result: Object mode produces id and name keys without calculating formulas.

Supported

What this tool handles

  • Every worksheet
  • Object and array forms
  • Strings, numbers, booleans, dates and inert formula text

Not supported

Important limitations

  • Running formulas
  • Cell styles
  • External links

Operational limits

  • XLSX only
  • Up to 2,000,000 cells per worksheet
  • Styles, charts and macros are omitted

Troubleshooting

Common problems

Keys have suffixes

Duplicate headings receive _2, _3 and so on.

Formula cells begin with =

Formulas are represented as inert JSON strings.

Questions

XLSX to JSON FAQ

Which row supplies keys?

Object mode uses row one; blank headings become column_1 and so on.

Are formulas recalculated?

No Excel calculation engine runs.