Convert JSON to CSV, or CSV to JSON

Paste the JSON or drop the file, check that the direction says JSON to CSV, and press Convert. An array of objects becomes a table: each object is a row and each key a column, with the columns taken from every key that appears. Copy it, or download the .csv file.

Nested objects are flattened into columns named with a dot, so `{"user":{"name":"Ada"}}` gives a `user.name` column. Arrays go into one cell as JSON text, or joined with a semicolon if you tick that option. Untick Flatten nested objects if you want the whole nested value kept as text in one cell.

Excel in many countries expects a semicolon, not a comma, and reads non-English letters wrongly unless the file starts with a byte-order mark. Keep UTF-8 with BOM ticked and choose Semicolon if your columns land in one cell.

By default every value stays text, exactly as it is in the CSV, so an id such as 00123 is not changed. Tick Detect types to turn numbers, true and false and null into real JSON values; long digit strings and values with leading zeros stay as text even then.

No. What you paste, and any file you drop, is converted by code running in this page and is not uploaded; the only thing the site counts is the anonymous usage listed on the privacy page. A file can be up to 200 MB, and the page keeps working offline after one visit and a short wait.

The conversion runs in the background so the page stays usable. A file over 200 MB is refused as too large for a browser tab, and a phone may run out of memory on a smaller one, in which case the page says so instead of giving a half result. Split the file and convert the pieces if that happens.