Excel tools
Convert Excel to JSON
Turn spreadsheet rows into JSON for an API, a script or a web app, without writing a parser. The conversion runs in your browser.
How the JSON is shaped
Each sheet becomes an array of objects. The first row supplies the keys, and every row below it becomes one object, so a sheet with columns name, email and plan turns into [{ "name": …, "email": …, "plan": … }, …]. Numbers and booleans stay typed rather than becoming strings.
Prepare the sheet first
The header row matters most: give every column a short, unique name, since those become your JSON keys. Remove title rows, notes and totals above or below the table, or they'll turn into objects too. Formulas are exported as their calculated values.
Common uses
Seeding a database or a test fixture, feeding product or price lists into a static site, importing data into an API, or handing a non-technical colleague's spreadsheet to a developer in a format they can use directly.
Your files stay on your device
Workbooks are read by your browser, so the data never passes through a server on its way to JSON. The work happens in your browser, so nothing is uploaded and nothing is stored on a server. Once the page has loaded it keeps working offline, and it's free, with no sign-up and no watermark.
Questions
What does the JSON output look like?
An array of objects per sheet, using the header row as keys. Each row of the sheet is one object.
What happens with several sheets?
Each sheet is converted separately, so you get JSON for every sheet in the workbook.
Are empty cells included?
Empty cells are usually left out of that row's object, so check how your code handles missing keys.
Can I go back from JSON to Excel?
Yes. JSON to Excel turns an array of objects back into a sheet, with the keys as column headers.