Excel to JSON
A spreadsheet into JSON.
A spreadsheet into JSON.
How to use Excel to JSON
- Upload a spreadsheet whose first row holds the column headers
- Let it map each row into an object using those keys
- Copy or download the resulting JSON array
About Excel to JSON
Excel to JSON reads your spreadsheet and rewrites it as JSON, using the first row as the field names. Every row beneath the header becomes one object in an array, so a sheet of people, products, or transactions comes out as a clean list of labelled records instead of a grid of loose cells. That is the shape most code and APIs expect, so you can drop the result straight into a script, a config file, or a request body without reshaping it by hand.
Converting Excel to JSON here takes three steps: choose your file, let the tool read the rows, then copy or download the output. There is nothing to install, no account, and no cap on how many sheets you run through it. Because the whole conversion happens in your browser, the spreadsheet is read on your own device and nothing is uploaded to a server — handy when the data is a customer list, an export, or anything you would rather not hand to a website.
One thing worth knowing: this tool moves in a single direction, from a spreadsheet to JSON. If you need to go the other way and open or import a JSON file into Excel, that is a job for Excel's own Get Data and From JSON feature rather than this converter, and the FAQ below walks through it. For turning a table into records, though, it does the whole thing in a couple of clicks and keeps your file private on your own machine.
Frequently asked questions
- Is the Excel to JSON converter free?
- Yes. It is free with no account and no sign-up, and there is no limit on how many files you convert.
- Does my spreadsheet get uploaded?
- No. The file is read and converted in your browser, on your own machine, so your data is never sent to a server.
- How do I convert an Excel spreadsheet to JSON?
- Choose your Excel file, let the tool read it, then copy or download the JSON. There is nothing to install and no setup — the conversion runs as soon as your file loads.
- What does the JSON output look like?
- You get an array of objects, one per row. Each object uses your header row for its keys, so a row reads like a labelled record instead of a bare list of cells.
- Does each spreadsheet row become one JSON object?
- Yes. Every row under the header turns into a single object, and all of those objects are collected into one array in the same order as your sheet. The header cells become the keys shared by every object.
- What if my top row is not a real header?
- The tool always treats the first row as the keys. If that row holds data instead of column names, those values become your keys and the first record is lost, so make sure row one is a proper header.
- Can this convert JSON to Excel as well?
- No. This converter runs one way, turning a spreadsheet into JSON. To go from JSON back to a spreadsheet you use Excel itself rather than this tool — the next two questions cover opening and importing a JSON file in Excel.
- How do I open a JSON file in Excel?
- In modern Excel, open the Data tab, choose Get Data, then From File and From JSON, and pick your .json file. Excel opens it in Power Query, where you expand the records into columns before loading them onto a sheet. This is built into Excel and does not need this tool.
- How do I import or convert a JSON file into an Excel table?
- Use the same Data > Get Data > From File > From JSON path, which imports the file through Power Query. Expand any nested fields into columns, load the result to a worksheet, and save it as .xlsx. This tool does the opposite job — turning that worksheet back into JSON.
- Can I use the JSON output in code or with an API?
- Yes. The output is a standard array of objects, the format most languages, config files, and REST APIs expect. You can paste it straight into your code or a request body without any extra reshaping.