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

Page: https://datautility.in/excel-to-json
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

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

## How to use the Excel to JSON Converter

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

## What it does

- JSON, CSV, Parquet and Excel
- One file or a whole folder
- Nested JSON flattened into columns
- Nothing is uploaded

## Tips

- Use the Batch / Folder tab to convert many files into one ZIP.
- Nested JSON becomes columns like address.city.
- Excel: the first sheet is read; old .xls files are not supported.

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

- [JSON to Excel](https://datautility.in/json-to-excel)
- [Excel to CSV](https://datautility.in/excel-to-csv)
- [Guide: Excel to JSON](https://datautility.in/blog/how-to-convert-excel-to-json)

## 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}]
```

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

### Is my data uploaded?
No. Everything runs in your browser and nothing is stored.

## Related pages

- [JSON, CSV, Parquet and Excel Converter](https://datautility.in/format-converter): Convert between JSON, CSV, Parquet and Excel online for free, one file or a whole folder. It runs in your browser, so nothing is uploaded.
- [Avro Viewer Online: Open .avro Files](https://datautility.in/avro-viewer-online): Open and view an Avro (.avro) file online: see the schema and records as a table, then save as CSV, JSON, Excel or Parquet. Free, no upload.
- [Avro to CSV Converter](https://datautility.in/avro-to-csv): Convert an Avro file to CSV online. Nested records are flattened. Free, private, runs in your browser.
- [CSV to Avro Converter](https://datautility.in/csv-to-avro): Convert CSV to an Avro (.avro) file online. Column types are detected and written into the Avro schema. Free and private: nothing is uploaded.
- [Avro to JSON Converter](https://datautility.in/avro-to-json): Convert an Avro file to JSON online. Nested records, arrays and maps stay nested. Free, private, no upload.
- [JSON to Avro Converter](https://datautility.in/json-to-avro): Convert JSON to an Avro (.avro) file online. The schema is built from your data. Free, private, no upload.
- [Parquet to Avro Converter](https://datautility.in/parquet-to-avro): Convert a Parquet file to Avro online. Column types are kept in the Avro schema. Free, private, runs in your browser.
- [Excel to Avro Converter](https://datautility.in/excel-to-avro): Convert an Excel (.xlsx) sheet to an Avro (.avro) file online. Numbers, dates and true/false values are kept as real types. Free and private.

## Topic guides

- [JSON Guides and Free JSON Tools](https://datautility.in/guides/json)
- [Excel Guides and Free Excel Tools](https://datautility.in/guides/excel)

## Guides

- [How to Convert Excel to JSON in 4 Steps (Free, Private)](https://datautility.in/blog/how-to-convert-excel-to-json)
- [Excel Financial Statements to JSON for Apps](https://datautility.in/blog/excel-financial-statements-to-json)
- [How to Convert JSON, CSV, Parquet and Excel Files Online](https://datautility.in/blog/convert-json-csv-parquet-excel-online)
- [How to Convert JSON to CSV in 4 Steps (Free, Private)](https://datautility.in/blog/how-to-convert-json-to-csv)

Open the tool: https://datautility.in/excel-to-json
