JSON to CSV Flattening Mechanics & Dot-Notation Mapping

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,London

2. 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