Convert JSON to CSV

1. 1Choose a .json or .jsonl file.
2. 2Keep “Excel-compatible” ticked if you will open the CSV in Excel; untick it for a database or script.
3. 3Click Convert to CSV. The result shows how many rows and columns were created and where the records were found.
4. 4Download the CSV and open it in Excel, Google Sheets or your database tool.

Nested objects become dot columns, simple arrays are joined.

{
  "data": [
    { "id": 1, "name": "Ana", "address": { "city": "Lisbon" }, "tags": ["admin", "beta"] },
    { "id": 2, "name": "Ben", "active": true }
  ]
}

id,name,address.city,tags,active
1,Ana,Lisbon,admin; beta,
2,Ben,,,true

01API responses in a spreadsheet

Most APIs answer in JSON. Save a response to a file and convert it to inspect the data, share it with someone who works in Excel, or attach it to a report.

02Database and app exports

mongoexport writes one JSON document per line by default, and many apps export JSON. CSV is what spreadsheets, BI tools and most import wizards expect.

03Logs and event data

Structured logs are often JSON Lines, one event per line. As CSV they can be sorted, filtered and counted in any spreadsheet.

• Nested objects become dot-separated columns: {"address": {"city": "Lisbon"}} gives a column address.city.
• Arrays of simple values are joined in one cell: ["admin", "beta"] becomes admin; beta.
• Arrays of objects, such as order line items, are kept as JSON text in one cell, so nothing is lost.
• The columns are every field found in any record, in the order they first appear. A missing field or a null value leaves an empty cell.
• Numbers and true/false are written exactly as they appear in the JSON.

If the file is an array, each element becomes a row. If it is an object, the first property that holds a non-empty array is used, which covers common API shapes such as {"data": [...]}, {"results": [...]} and {"items": [...]}. A single object becomes a single row. A file that is not one JSON document is read as JSON Lines, one value per line.