Excel to JSON

Convert an Excel .xlsx sheet to JSON in your browser. Choose the sheet and the header row; every row becomes an object. Free, private, no upload.

Up to 10 MB.

Header rowAll sheets

JSON

Open an Excel file to see the JSON here.

Shortcuts: Ctrl+Enter run · Ctrl+Shift+C copy result · / search (use ⌘ on Mac)

Next steps

Done here? Use the Send to… menu on the result to carry it on to JSON Beautifier, JSON to CSV or JSON Visualizer.

Free Online Excel to JSON Converter

Turn an Excel sheet into JSON. Open an .xlsx file, choose the sheet and which row holds the column names, and copy or download the JSON. It gives developers a quick browser-based way to solve a focused excel to json task before moving the result into a project.

How to convert Excel to JSON

Drop your .xlsx file below. The first sheet is converted at once; pick another sheet or change the header row in the options and the result updates.

Common mistakes

A title row above the table: set the header row to the row that has the column names.
Merged cells: only the top-left cell holds the value, so the others are empty.

Frequently asked questions

Which Excel files can I open?

Modern .xlsx workbooks. Old .xls files are not supported: open them in Excel and use Save As .xlsx first.

What happens to dates?

Excel stores dates as serial numbers (for example 45292 for 1 January 2024). They are shown as those numbers; format or convert them in your code if needed.

Can I convert every sheet?

Yes. Turn on "All sheets" and the result is an object with one list per sheet name.

Is my file uploaded?

No. The workbook is read by your browser and never sent anywhere.

How do I use this excel to json tool?

Use the interactive controls above; processing stays in your browser and the result is intended as a practical starting point for development work.

More Formatters & Parsers

JSON ParserCheck if JSON is valid and see it neatly JSON Schema ValidatorCheck data follows the rules you set JSONPath TesterPick values out of JSON with a path XML/XSD ValidatorCheck XML is valid and follows a schema JSON ↔ TOML ConverterSwitch config files between JSON and TOML URL ParserBreak a web link into its parts Query String ParserRead the ?a=1&b=2 part of a link REST API TesterSend API requests and see the response

View all Formatters & Parsers tools →