Export JSON arrays to spreadsheet CSV locally

Developer notes

• Only objects or arrays-of-objects flatten predictably. • Single-key JSON/XML wrappers (e.g. `{ "orders": [ {...} ] }`) unwrap to row arrays automatically. • Primitive tops or heterogeneous arrays trigger guidance to reshape first. • On **/fr/** routes, CSV uses `;` between columns for European spreadsheet defaults (Numbers, Excel FR). • Split giant exports offline before expecting tab performance.

When teams pick this route

• QA merging webhook payloads into spreadsheets. • RevOps marrying CRM JSON blobs with CSV templates. • Support pairing tickets with summarized exports.

About these options

CSV exports: choose a delimiter (Auto follows locale — semicolon on /fr), RFC-minimal vs always-quoted fields, line endings, and whether to emit a header row. CSV imports: delimiter + whether row 1 holds column names (Auto delimiter follows locale only for convenience). JSON output (XML, YAML, or CSV sources): indentation (including compact one-line) and optional recursive key sort. JSON → XML: toggle pretty-printing and indent width. YAML output: indent width, readable vs tighter layout, and deterministic string quoting (there is no source YAML file to “preserve”). XML comments are not represented in the intermediate JSON tree.

Worked examples

Navigate related converters

Need YAML manifests? Jump to JSON → YAML. Tightening JSON payloads? Refresh with our JSON minifier or revisit XML gateways at JSON → XML.