Relational spreadsheets and analytics platforms (Excel, Google Sheets, Pandas) require tabular 2D structures. JSON to CSV conversion flattens multi-level objects into rectangular rows and columns.
1. Recursive Key Flattening (Dot-Notation)
Nested object properties are transformed into delimited column headers:
// Input JSON
[
{
"id": 101,
"user": { "name": "Alice", "address": { "city": "London" } }
}
]id,user.name,user.address.city
101,Alice,London2. Array Serialization Modes
- JSON String Mode: Encodes inner arrays as stringified JSON (e.g.
"["admin", "billing"]"). - Joined String Mode: Joins primitive array values with semicolons or pipes (e.g.
"admin;billing").
3. RFC 4180 Escaping Compliance
Fields containing commas, line breaks, or double quotes must be wrapped in double quotes, with internal quotes escaped as"".Put this into practice with the JSON to CSV
Runs entirely in your browser — no upload, no signup, and your data never leaves your device.
Open JSON to CSV →