# CSV to JSON Converter

> Convert CSV 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/csv-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 CSV 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.

## Numbers stay numbers

A CSV file has no types: 42, true and 2024-01-31 are all just text. With Detect numbers & booleans turned on, 42 becomes the number 42 and true becomes a real boolean in the JSON, which is what most APIs and JavaScript code expect. Turn it off if a column holds codes with leading zeros, such as 00123, that must stay text.

## Titles above the table are skipped

Exports often start with a report title or a note before the real header row. Those lines are detected and left out, so the JSON keys come from the actual column names. Choose Pretty-print for a readable file, or switch it off for a compact one.

- [JSON to CSV](https://datautility.in/json-to-csv)
- [CSV to JSON for large files](https://datautility.in/csv-to-json-converter)
- [Guide: CSV to JSON](https://datautility.in/blog/how-to-convert-csv-to-json)

## Example

Input:

```
id,name,age
1,Ada,36
2,Alan,41
```

Output:

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

## Frequently asked questions

### How do I convert CSV to JSON?
Drop your CSV 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

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

## Guides

- [How to Convert CSV to JSON in 4 Steps (Free, Private)](https://datautility.in/blog/how-to-convert-csv-to-json)
- [CSV Tick Data to JSON for Charts and Apps](https://datautility.in/blog/csv-tick-data-to-json)
- [Product Feed CSV to JSON for Shop APIs](https://datautility.in/blog/ecommerce-product-feed-csv-to-json)
- [CSV Market Data to JSON for Web Apps and Charts](https://datautility.in/blog/csv-market-data-to-json)

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