JSON → CSV Converter

CSV is flat and two-dimensional, so the ideal input is a JSON array of flat objects: [{"name":"Alice","age":30}]. Each object becomes a row; the union of all keys becomes the column headers. If keys differ between objects, missing values are left empty. Deeply nested objects require flattening first.

The converter collects all unique keys across every object to build the full column set. If a specific object doesn't have a key, that cell is left empty. The CSV will always have a consistent number of columns even if individual JSON objects have different key sets.

Comma (,) is the RFC 4180 standard. Semicolon (;) is preferred in European locales where comma is the decimal separator — Excel in those regions opens semicolon-delimited files correctly. Tab creates TSV files, useful when values may contain commas and semicolons.

Use Data > Get External Data > From Text and the import wizard to specify delimiter and UTF-8 encoding. Avoid double-clicking the .csv — Excel guesses encoding and delimiter, which often corrupts non-ASCII characters and auto-converts values like "1-2" into dates.