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.
Sheet: Prices sku | product | price_gbp | (blank) KC-MUG | Stoneware mug | 18 | seconds KC-JUG | Pouring jug | 32 |
[
{ "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
Open the workbook
Press Choose an Excel file (.xlsx) and select it. The workbook is read on this page.
Select the sheet
Workbooks with more than one sheet show a Sheet list with row counts. Pick the one you want.
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.
Check the preview
Up to 50 rows are shown as a table so you can confirm the header and columns are what you expect.
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