No file open
Create a new file or open an existing one from the sidebar
Paste a JSON array and press To CSV in the Convert panel.
No file open
Create a new file or open an existing one from the sidebar
To convert JSON to CSV, paste a JSON array of objects above, open Convert and press To CSV. Each object becomes a row and each key becomes a column, using every key found across all the objects, so rows with extra fields keep them.
Nested objects are flattened into dot notation columns like address.city, arrays of simple values are joined into one cell, and arrays of objects are kept as JSON inside the cell. Press Save to download the result as a .csv file for Excel or Google Sheets.
[
{
"id": 1,
"name": "Alice",
"address": {
"city": "London",
"country": "UK"
},
"skills": [
"JavaScript",
"Python"
]
},
{
"id": 2,
"name": "Bob",
"address": {
"city": "Paris",
"country": "France"
},
"skills": [
"Go"
]
},
{
"id": 3,
"name": "Carol",
"address": {
"city": "Tokyo",
"country": "Japan"
},
"skills": [],
"manager": true
}
]id,name,address.city,address.country,skills,manager
1,Alice,London,UK,"JavaScript, Python",
2,Bob,Paris,France,Go,
3,Carol,Tokyo,Japan,,trueCSV is a table, so the converter needs a list of rows. If the array is wrapped in an object, like {"users": [...]}, pull it out first, Query view with $.users[*] does that in one go.
Yes. Values with commas, quotes or line breaks are quoted the standard way, so Excel and Google Sheets keep them in one cell.
Yes, press To JSON in the CSV section. Values come back as strings and the dot notation columns stay flat.
No, this runs entirely in your browser, so nothing you paste is sent to a server. The only feature that sends data anywhere is the optional AI assistant, and only when you actually ask it something.