How to convert JSON to CSV
- Paste your JSON into the left panel, upload a
.jsonfile, or load it from a URL. - The CSV appears on the right as you type. Pick a delimiter (comma, semicolon, tab, or pipe) if your spreadsheet expects something other than a comma.
- Tick Excel BOM if you will open the file in Microsoft Excel and it contains non-ASCII text.
- Click Copy or Download .csv.
If the input is not valid JSON, the error bar shows the line and column. Click Fix to repair common problems such as trailing commas or single quotes before converting.
What the output looks like
Input:
[
{ "id": 1, "user": { "name": "Maya", "city": "Pune" }, "tags": ["vip", "new"] },
{ "id": 2, "user": { "name": "Lee, Jordan" } }
]
Output:
id,user.name,user.city,tags
1,Maya,Pune,"[""vip"",""new""]"
2,"Lee, Jordan",,
Columns are the union of every key seen, in first-seen order. Missing values are empty cells.
Limits and notes
- Files up to 5 MB. Larger exports are better handled with a script; see the Python and Node examples in how to convert JSON to CSV.
- Arrays of arrays are not tabular. Flatten them first or convert each inner array separately.
- Numbers are written as JSON prints them. Large integer IDs over 2^53 should already be strings in your JSON; see JSON number precision.
- Dates stay as the strings they were. Spreadsheets will parse ISO 8601 dates such as
2026-06-23T14:30:00Zautomatically.