Free tool

Excel to JSON Converter

Choose an .xlsx file and every row of the selected sheet becomes a JSON object named by the header row. Numbers stay numbers and dates become date strings.

Your data never leaves your computer: everything runs in your browser.

The file is read only in your browser. Save old .xls files as .xlsx in Excel first.

How to use it

  1. Choose an Excel file (.xlsx). It is opened only in your browser.
  2. If the workbook has several sheets, pick the one you want from the list.
  3. Keep First row is the header ticked to use the headers as JSON keys. Otherwise columns are named column_1, column_2…
  4. Copy the result or download it as .json.

Example

An orders sheet with a header row (as it looks in Excel):

Input

Order ID | Customer | Date       | Total
1042     | Jane Doe | 01/15/2026 | 249.90

Output

[
  {
    "Order ID": 1042,
    "Customer": "Jane Doe",
    "Date": "2026-01-15",
    "Total": 249.9
  }
]

Need more?

Run ForLab Formatter on Apify to do the same conversions every day, automated and validated.

  • Call it from the API or on a schedule: files convert inside your workflow, not by hand.
  • In: CSV/TSV, Excel, JSON, NDJSON, XML, YAML and HTML tables; merge up to 10 files or Apify datasets.
  • Clean in the same run: dedupe, filter, sort, flatten nested JSON, select and rename columns, repair broken JSON; Turkish encodings and ; delimiters are detected.
  • Out: JSON, CSV, Excel, SQL INSERT, Markdown, HTML and JSON Schema; every row is validated against one example object.
  • Pay only for valid rows: $0.0001 each (1,000 rows ≈ $0.10), plus $0.001 per run.

Frequently asked questions

How are dates converted?

Excel date cells become YYYY-MM-DD (for example 2026-01-15), and cells with a time become ISO 8601 without a time zone (for example 2026-01-15T14:30:00), because Excel cells carry no time zone. They read the same in every language and system.

What happens to empty cells?

Empty cells become null, and the column still appears in every object, so all records have the same fields.

Are formulas converted?

You get the last calculated value Excel saved in the file, not the formula itself.

Are old .xls files supported?

No, only .xlsx. Open an old .xls file in Excel, use Save As → Excel Workbook (.xlsx), and try again.

Are leading zeros kept?

If the cell is stored as text in Excel (for example 0617000001), it comes through unchanged. If it is stored as a number and only formatted to show zeros, you get the number Excel saved.

Other free tools