JSON records to CSV converter

Create a CSV table from JSON records with the same column keys and an explicit policy for cell values.

How to use this tool

Enter a nonempty array of flat objects with the same keys on every row. Strings-only mode is the default.
If needed, explicitly allow numbers and booleans to become text, then select Convert JSON records to CSV. Review the header and every column.

Scope and limits

Nested objects, arrays, null, inconsistent keys, empty records and empty record arrays are rejected. This is not an Excel workbook exporter.

Spreadsheet applications may interpret cells beginning =, +, - or @ as formulas; import untrusted output as text. Input is limited to 100,000 characters; table field/value bounds and a 1,000,000-character output cap apply.

Inputs start empty. Load example fills them only when you choose it; Reset clears the editor and output.

For the other operations and format choices, open the Structured data workspace.

Worked input and output

Input

[{"id":"001","name":"Ada"},{"id":"002","name":"Lin, Mei"}]

Output

id,name
001,Ada
002,"Lin, Mei"

String identifiers retain their leading zeros. The comma in Lin, Mei requires a quoted CSV field. Explicit scalar mode would turn supported numbers and booleans into strings and lose their original types.

JSON records to CSV converter

Source

Output

Worked input and output

Input

Output

Related tools