Excel to JSON Converter
Turn an Excel workbook (.xlsx, .xls or .ods) into JSON, one object per row keyed by the column names, for the first sheet or every sheet.
How to convert Excel to JSON
Choose your workbook
Drop an .xlsx, .xls or .ods file. It stays on your device.
Choose the sheets
Convert the first sheet or every sheet.
Set the header
Say whether the first row holds the column names.
Copy or download
Use the JSON in your code.
When to use Excel to JSON Converter
You need spreadsheet data as JSON for an app, an API or a database import.
A workbook with several sheets should become one JSON file keyed by sheet name.
Tips for a better Excel to JSON Converter result
Drop an .xlsx, .xls or .ods file, choose the first sheet or every sheet, and say whether the first row holds the column names.
Turn on number and true or false conversion if you want typed values.
Excel to JSON Converter: limits and what to check
It reads the values Excel shows, which are the results of formulas.
A column with no name is called column_2, column_3 and so on, and repeated names get _2, _3 added.
About Excel to JSON Converter
Turn a spreadsheet into JSON for an app, an API or a database import. Each row becomes an object keyed by its column names. Cells are read as Excel shows them, so dates and currency keep their format, and numbers and true or false values can be typed for you.
FAQs
Does it read formulas?
It reads the values Excel shows, which are the results of formulas.
What if a column has no name?
It is called column_2, column_3 and so on. Repeated names get _2, _3 added.
Can I convert JSON back?
Yes. Use JSON to Excel Converter.