Map Extract
Free tool

Convert an Excel sheet to JSON

Choose an .xlsx workbook and a sheet, and get JSON you can paste into code, an automation or an API request. By default each row becomes an object named by the header row; untick that option for a plain array of rows.

Runs in your browser. Nothing you enter is uploaded.

A price list sheet as objects

A small sheet called Prices has a header row and two products. One header cell was left blank.

With First row holds the field names ticked, each row becomes an object. The blank header becomes column_4, so no value is lost. Every value is a string, including the prices; the converter does not guess types, so your code decides how to read each field.

Input
Sheet: Prices
sku | product | price_gbp | (blank)
KC-MUG | Stoneware mug | 18 | seconds
KC-JUG | Pouring jug | 32 |
Result
[
  { "sku": "KC-MUG", "product": "Stoneware mug", "price_gbp": "18", "column_4": "seconds" },
  { "sku": "KC-JUG", "product": "Pouring jug", "price_gbp": "32", "column_4": "" }
]

Converting a sheet to JSON

  1. Open the workbook

    Press Choose an Excel file (.xlsx) and select it. The workbook is read on this page.

  2. Select the sheet

    Workbooks with more than one sheet show a Sheet list with row counts. Pick the one you want.

  3. Choose objects or rows

    With First row holds the field names on, the header supplies the keys. Switch it off and each row is written as a plain list of cell values, header row included, in sheet order.

  4. Check the preview

    Up to 50 rows are shown as a table so you can confirm the header and columns are what you expect.

  5. Copy or download

    Copy the JSON or save it as a .json file named after the workbook and sheet.

Where Excel to JSON is useful

Small businesses often keep the real source of truth in a spreadsheet: a price list, a stockist list, a list of service areas or a set of email templates. Websites, chat widgets, booking tools and automation platforms usually want JSON. Converting the sheet saves hand-copying values into a config file and keeps the spreadsheet as the place to edit.

Because dates in date-formatted cells come out as yyyy-mm-dd and formulas give their calculated values, the JSON reflects what you see in Excel rather than the internals. Formatting, comments and hidden sheet properties are left behind.

Questions people ask

How do I convert an Excel spreadsheet to JSON?

Choose the .xlsx file, pick the sheet, and leave First row holds the field names ticked. The JSON shows each row as an object with your column headers as keys. Copy it, or download it as a .json file, and use it in code, an automation tool or a web page.

Why are the numbers in quotes?

The converter keeps every cell as text so that values such as phone numbers, postcodes and product codes cannot be altered. Your code or tool can convert the fields it needs to numbers. For automatic number and true or false detection, export the sheet as CSV and use the CSV to JSON converter.

What happens to empty header cells?

A column with no header is given the name column_ followed by its position, for example column_4, so its values still appear in each object. Duplicate header names are worth fixing in the sheet first, because the later column's value replaces the earlier one under the same key.

Can I convert all sheets at once?

One sheet is converted at a time. Pick each sheet from the list in turn and download its JSON. If you need them combined, put the separate arrays together in one object keyed by sheet name, which is a small edit once you have the files.

Where your data goes

Reading the workbook and building the JSON both happen in your browser. The file is not uploaded and nothing about it is stored.

Checked against the tool on

Top