toolgarden.xyz
中文

Excel → JSON

Free online tool to read an Excel (.xlsx/.xls) file and convert it to a JSON array, restoring multi-level fields with >

Upload Excel File

Click or drag to upload

Supports .xlsx / .xls

JSON Output

Result will appear after uploading a file

About this tool

Excel to JSON reads the first worksheet in an XLSX or XLS workbook, treats its first row as field names, and converts later rows into an object array. Blank cells usually omit a property, so the same key can be present in one record and absent in another.

Headers containing `>` paths, such as profile>name or items>0>sku, are reconstructed as nested objects and arrays. This matches the flattening convention used by JSON to Excel; ordinary headers remain first-level properties.

How to use it

  1. Choose a workbook

    Upload an XLSX or XLS file. It is parsed in the browser and not sent to a conversion server.

  2. Inspect the first sheet

    Confirm row one contains unique headers and review the detected record count and generated JSON fields.

  3. Copy or download JSON

    Check numbers, dates, blanks, and reconstructed paths before copying or saving the formatted result.

Supported range and limits

Input formats
XLSX and XLS
Header handling
The first row becomes the keys. Merged cells or multi-row headers need tidying in Excel first
Multiple sheets
Converts the selected worksheet; sheets are not merged automatically
Type inference
Numbers, dates and booleans follow the cell type, while text-formatted numbers stay strings
Dates
Excel stores dates as serial numbers, so the converted representation can differ from what the cell displayed
Formulas
Reduced to their computed values; the formula itself is not kept

When you would use it

  • Creating application seed data

    Convert a maintained product, region, or permission table into a JSON array for scripts and frontend code.

  • Receiving manually cleaned data

    Let a business user clean rows in Excel, then turn the result into structured JSON for an application.

  • Wiring an operations spreadsheet into code

    Copy, prices and feature switches maintained in Excel by non-technical colleagues become JSON your code can read directly.

What to know before you start

  • Only the first worksheet is read. Hidden sheets and later sheets are not merged automatically.
  • Formula cells generally expose their cached result rather than the formula text; uncalculated or external references may be blank.
  • Excel dates are serial values interpreted through cell formatting. Sample dates and time zones after conversion.

Related concepts

header row
The first row used to create JSON keys. Blank or duplicate headers can produce unclear or overwritten fields.
worksheet
One tab inside a workbook. A single XLSX file can contain several worksheets.

Frequently asked questions

Which Excel formats are supported?
It reads .xlsx and .xls files, parsing the worksheet into a JSON array of objects.
What happens to the header row?
The first row is used as the field names (keys) and each remaining row becomes a JSON object, ready for an API or program.
Is my uploaded spreadsheet stored?
No. The Excel file is parsed locally in your browser; its contents are never uploaded or stored.
Why did my dates turn into numbers?
Excel stores dates as serial numbers counted from 1900, and what the cell shows is just a display format. Conversion follows the cell type, so a column formatted as Text or General can yield the raw serial. Set date columns explicitly to a date format before converting.
Can it handle merged header cells?
No. The first row becomes the keys, and merged cells or multi-row headers produce empty keys or shifted columns. Flatten the header to a single row with one unique name per column in Excel first.

Related tools