JSON to CSV converter
Convert JSON to CSV in your browser. Paste or upload an array of objects, flatten nested fields, and download a CSV file. Free, no sign-up, nothing is uploaded.
When to use it
JSON is what most apps and APIs return, but analysts usually want a table. This converter turns an array of JSON objects into rows and columns you can open in Excel or load into pandas.
Nested fields are flattened into dotted column names, so you do not have to write a script. Paste text or drop in a file and download the CSV.
How it works
- Paste your JSON, or drop in a .json file.
- Choose how to handle lists and the CSV separator.
- Check the preview, then copy the CSV or download it.
Questions
What JSON shape works best?
An array of objects, such as [{"name":"Ayesha","age":30},{"name":"Bilal","age":28}]. If your JSON is an object that holds one array, the tool uses that array. Files with one JSON object per line are also accepted.
What happens to nested objects?
Nested objects are flattened into columns with dotted names, so {"address":{"city":"Paris"}} becomes a column called address.city.
How are lists inside a record handled?
Lists of simple values are joined with a semicolon by default. Lists of objects are kept as JSON text in one cell. You can switch the first option to JSON text in the settings.
Does my JSON leave my computer?
No. The conversion runs in your browser tab, and nothing is sent to a server.
Did this help?
Tell me what worked, what broke, or what tool you want next. I read every message.
Send feedback