JSON ↔ CSV Converter
Convert between JSON and CSV formats
About JSON CSV Converter
This tool converts between JSON and CSV in both directions: an array of JSON objects becomes a spreadsheet-ready table, and a CSV file becomes structured JSON. It runs entirely in your browser, so the data never leaves your machine.
How the two formats map
Each object in a JSON array becomes one CSV row, and each key becomes a column header. Going the other way, the first CSV line is read as the header row and every subsequent line becomes an object. The formats are not equivalent, though: CSV is flat and untyped, so it cannot express nesting, and everything arrives back as text unless you convert it.
[{"name":"Ada","age":36},{"name":"Alan","age":41}] converts toname,ageAda,36Alan,41What happens to nested objects and arrays?
They have to be flattened, because CSV has no way to represent depth. A nested value is typically written into a single column, so {"user":{"city":"Ankara"}} becomes a user.city column. Deeply nested or variable-shape data does not survive the trip cleanly — if the structure matters, keep it as JSON.
What about commas and quotes inside values?
A value containing a comma, a quote or a line break must be wrapped in double quotes, and any quote inside it doubled. Getting this wrong is the usual cause of a CSV that opens with columns shifted. If your data is full of commas, a tab-separated export avoids the problem entirely.
Try our other free tools: JSON formatter, base64 encoder, and regex tester.