JSON to CSV Converter

Convert JSON to CSV 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 JSON to CSV 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

Example

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

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

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

How do I convert JSON to CSV?

Drop your JSON file (or paste the data), check the options, click Convert and download the CSV 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