JSON to CSV Converter

What this JSON to CSV converter does

CSV is still the easiest way to move data into Excel, Google Sheets, a BI tool or a database import wizard. This converter reads a JSON array of objects and turns every object into one row, and every unique key into one column. Columns appear in the order they are first seen, so the output keeps the shape of your data instead of sorting it alphabetically.

Real-world JSON is rarely flat. When Flatten nested objects is on, a value such as {"address": {"city": "Pune"}} becomes a column called address.city. Arrays are written into a single cell as JSON text (for example ["Go","Kubernetes"]) so no information is lost. Values that contain the delimiter, quotes or line breaks are quoted according to RFC 4180, so the file opens correctly in every spreadsheet program.

How to convert JSON to CSV

1. Paste your JSON into the left box, drag a .json file onto it, or click Upload.
2. Pick a delimiter. Use semicolon if your Excel uses a comma as the decimal separator (common in Europe), or tab for TSV.
3. Check the result in the CSV tab or switch to Table for a quick visual preview.
4. Click Download to save a UTF-8 .csv file (with a byte-order mark so Excel shows accented and non-Latin characters correctly) or Copy it to the clipboard.

Example

[
  {"id": 1, "name": "Alice", "address": {"city": "Pune"}},
  {"id": 2, "name": "Bob, Jr.", "address": {"city": "Austin"}}
]

id,name,address.city
1,Alice,Pune
2,"Bob, Jr.",Austin

Supported input shapes

• Array of objects – the usual API response: [{...}, {...}].
• Single object – converted into a CSV with one data row.
• Wrapper object – {"items": [...]} with exactly one array is unwrapped automatically.
• Array of values – [1, 2, 3] becomes a single column called value.
• Objects with different keys – missing values are left as empty cells.