TodayTools

Excel to JSON

Marks, stock or customer lists move from a sheet straight into your project.

PrivateNo uploadsRuns in your browser

Donate

No file handy?

Each row becomes {"Item": "Rent", "Amount": 15000}, using the first row as names.

Man Laptop

For the class project

From spreadsheet to software.

Group project. Kiran's team loads the class marks into their app.

BeforeRetyping marks into code

With sdevThe sheet becomes data in a click

  • A girl doing homework at a table

    Marks day

    The teacher's sheet turns into a live results page.

  • Three students smiling around a laptop

    Demo day

    The project works on the first try.

How to convert Excel to JSON

  1. Open the workbook

    Drop an .xlsx or .xlsm file on the page or click to choose one. No file handy? Try the monthly expenses sample.

  2. Choose a sheet and shape

    If the file has several sheets, pick one from the Sheet menu. Choose rows with names (each cell named by its column heading), rows as lists, or CSV. Untick First row is header if row 1 holds data.

  3. Copy or download

    Check the preview of the first 20 rows, then press Copy, use Ctrl+C with nothing selected, or Download to save the result with the workbook's name and a .json or .csv extension.

Good to know

  • Date cells are written as 2026-09-26, or 2026-09-26 14:30:00 with a time. Plain numbers stay numbers and TRUE/FALSE become booleans.
  • Formula cells give their last calculated value, as saved by Excel. The formula itself is not exported.
  • Empty cells become null in JSON and empty strings in CSV. Skip empty rows drops rows with no values at all, and trailing blank rows are always dropped.
  • Without a header row, or where a header cell is blank, columns are named by their letter: A, B, C.
  • Only .xlsx and .xlsm are supported. For an old .xls file, open it in Excel or another spreadsheet app and save as .xlsx first.
  • The workbook stays loaded in the worker, so switching sheets or options is quick. Large sheets show the first 1 MB of output; Download has everything, and Copy is disabled above 20 MB. Nothing is uploaded.

Where people use it

  • Load a price list into your app

    Your team keeps prices in Excel. Turn the sheet into JSON your app can read.

  • Make test data from a sheet

    Write sample rows in Excel, then convert them to JSON for your tests.

  • Pick one sheet from many

    Choose the tab you need from a workbook and leave the rest.

  • Get CSV from Excel

    The same page saves a clean CSV when another system wants that instead.

  • Already have a CSV?

    Convert CSV to JSON directly, with separator detection.

    CSV to JSON and JSON to CSV converter

Why this one

It keeps real numbers and dates instead of turning everything into text, so the JSON is ready to use.

  • Numbers, dates and true or false come out as typed values.
  • Large workbooks work in your browser.
  • The file is never uploaded.
  • No sign-up, works on phones.

What you can change

  • Which sheet to read
  • First row is the header
  • Skip empty rows
  • JSON with names, JSON as lists or CSV

People find this page by searching

  • excel to json
  • convert excel to json online
  • xlsx to json
  • excel to json array
  • excel sheet to json
  • excel to csv
  • convert spreadsheet to json
  • excel to json for api
Cite this tool
  • APA
    sdev.in. (n.d.). Excel to JSON converter [Web tool]. https://www.sdev.in/tools/excel-to-json
  • MLA
    "Excel to JSON converter." sdev.in, https://www.sdev.in/tools/excel-to-json.
  • Chicago
    sdev.in. "Excel to JSON converter." https://www.sdev.in/tools/excel-to-json.
  • BibTeX
    @misc{sdev-excel-to-json,
  title = {Excel to JSON converter},
  author = {{sdev.in}},
  howpublished = {\url{https://www.sdev.in/tools/excel-to-json}},
  note = {Web tool}
}

Questions people ask

Why do my dates show as numbers?

Excel stores dates as day counts and marks them with a number format. Cells formatted as dates are written as text like 2026-10-01. If a column shows plain numbers such as 45000, those cells were not formatted as dates in Excel; apply a date format, save, and convert again.

Can I convert a specific sheet?

Yes. When a workbook has more than one sheet, a Sheet menu appears above the output. The first sheet is selected by default.

What happens to merged cells and formatting?

Only cell values are read. A merged range gives its value in the top-left cell and null in the rest. Colours, fonts, column widths and comments are not exported.

Does it work with .xls or CSV files?

No. The tool reads the .xlsx and .xlsm formats only. For .xls, resave the file as .xlsx in Excel or another spreadsheet app. CSV can go straight into the CSV to JSON tool.

Is my spreadsheet uploaded?

No. The file is unzipped and parsed in a web worker inside your browser. Nothing leaves your device.

Donate