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.

Processed on your device. Files are not uploaded

How to convert Excel to JSON

  1. Choose your workbook

    Drop an .xlsx, .xls or .ods file. It stays on your device.

  2. Choose the sheets

    Convert the first sheet or every sheet.

  3. Set the header

    Say whether the first row holds the column names.

  4. 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.

Related tools