Excel to JSON

About this tool

This free Excel to JSON converter turns a spreadsheet into JSON — and turns JSON back into a real .xlsx workbook. Drop in an .xlsx, .xls, .xlsm, .ods or .csv file and the JSON appears straight away, ready to copy into your code, an API request or a test fixture.

Everything runs in your browser. Your spreadsheet is never uploaded, so internal data stays internal.

Objects or arrays — your choice

Tick First row is a header and each row becomes an object keyed by the column titles — a sheet with name, role and city columns gives you [ { "name": "Ada Lovelace", "role": "Analyst", "city": "London" } ].

Untick it and you get a plain array of arrays, header row included — handy when the sheet has no titles or you want the raw grid. Numbers stay numbers and dates keep the format shown in the sheet, so the JSON is ready to use as-is. Pretty print switches between readable indented JSON and a compact single line.

Every sheet in the workbook

Multi-tab workbooks are fully supported: a sheet selector appears above the output so you can convert each tab separately and download it as its own .json file.

JSON back to Excel

Switch the toggle to JSON → Excel to go the other way. Paste an array of objects (each key becomes a column) or an array of arrays (each inner array becomes a row), check the preview table, name the sheet, and download a genuine .xlsx file that opens in Excel, Google Sheets, LibreOffice and Numbers.

Features

• XLSX, XLS, XLSM, XLSB, ODS and CSV in — JSON out
• JSON in — real .xlsx out, with your own sheet name
• Array of objects (header row) or array of arrays (raw grid)
• Pretty printed or minified JSON
• Handles multi-sheet workbooks with a sheet selector
• Copy the result or download it as a file
• Works fully in your browser — nothing uploaded
• No sign-up, no row limit, completely free

Common uses

• Turn a product, price or translation sheet into JSON for a website or app
• Build test data or seed files for a database from a spreadsheet
• Hand a colleague's XLSX report to an API that only accepts JSON
• Convert an API response back into a spreadsheet your team can read and edit

How to use it

• Upload your Excel file — click the upload area or drag the file in
• Choose the sheet — if the workbook has more than one tab
• Set the options — header row on for objects, off for arrays; pretty print on or off
• Copy or download — save the JSON, or switch the toggle to convert JSON back to Excel