Excel to JSON Converter

Convert Excel to JSON in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.

Quick answer: Convert JSON, CSV, Parquet and Excel – one file or a whole folder.

Related: JSON, CSV, Parquet and Excel Converter · Avro Viewer Online: Open .avro Files · Avro to CSV Converter · CSV to Avro Converter · JSON Guides and Free JSON Tools

How to use the Excel to JSON Converter

Convert JSON, CSV, Parquet and Excel – one file or a whole folder.

The Format Converter moves data between JSON, CSV, Parquet and Excel without code or an install. It reads your file in the browser, flattens nested JSON into columns, keeps or guesses column types, and writes the format you choose. Use it to open API data in Excel, load a spreadsheet into an app, shrink a big CSV into Parquet, or look inside a Parquet file. Nothing is uploaded, so it is safe for customer and business data.

  1. Pick From and To
  2. Drop or paste your data
  3. Convert and download

Tips

Excel to JSON for an app or an API

Each row of the first sheet becomes one JSON object, and the first row gives the names of the keys. The result is an array you can paste into code, load as seed data, or send to an API. Turn on Pretty-print for a readable file with indentation, or leave it off for the smallest file to send over a network.

Before you convert

Make the first row a clean header: short names without line breaks make keys that are easy to use in code, such as customer_id rather than Customer ID (internal). Old .xls files are not supported, so save as .xlsx first. If you need the data the other way round, JSON to Excel turns an array of objects back into a sheet.

Example

Input: A Excel file with the columns id, name and age.

Output: [{"id":1,"name":"Ada","age":36},{"id":2,"name":"Alan","age":41}]

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

How do I convert Excel to JSON?

Drop your Excel file (or paste the data), check the options, click Convert and download the JSON result.

How big can a file be?

It depends on your device. A few hundred MB usually works.

Which conversions does the Format Converter support?

Any direction between JSON, CSV, Parquet and Excel (.xlsx), for one file or a whole folder. Nested JSON is flattened into columns such as address.city. For Excel, the first sheet is read; old .xls files are not supported.

Why did my number or date change after converting?

Types are detected from the values. Turn off "Detect types" to keep everything as text, which also keeps leading zeros in IDs and phone numbers.

Related pages

Topic guides

Guides