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.

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 · CSV Guides and Free CSV Tools

How to use the CSV 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

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.

Example

Input: id,name,age 1,Ada,36 2,Alan,41

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

Related pages

Topic guides

Guides