Which JSON shapes can I convert to CSV?

Three: an array of objects (each becomes a row, keys become columns), an array of arrays (first row becomes headers), or a single key-value object (becomes one row). Anything else reports an unsupported-shape error.

What happens to nested JSON values during conversion?

Nested objects and arrays are stringified into their CSV cell so no data is silently dropped. Nulls become empty cells, and column order follows first-seen key order across all rows.

Documentation

Converting formats

Move between CSV and JSON without surprises.

Quick answer

CSV to JSON: load the delimited file, pick array-of-objects or 2D-matrix layout plus indentation, then copy or download. JSON to CSV: paste or upload JSON in one of three supported shapes, convert, and download the CSV. Empty cells become null; nulls become empty cells.

Steps

CSV → JSON: open Tools → CSV to JSON, load the delimited file, choose objects or arrays layout, then copy or download the JSON.
JSON → CSV: open Tools → JSON to CSV, paste or load JSON (array of objects, array of arrays, or single object), then download the CSV.
Empty CSV cells become null in JSON objects; nulls become empty cells going back.
Nested JSON values are stringified into their CSV cell.

Tips

Validate JSON syntax first — the tool reports the exact parse error.
Column order for arrays-of-objects follows first-seen key order across all rows.

Common questions

Which JSON shapes can I convert to CSV?: Three: an array of objects (each becomes a row, keys become columns), an array of arrays (first row becomes headers), or a single key-value object (becomes one row). Anything else reports an unsupported-shape error.
What happens to nested JSON values during conversion?: Nested objects and arrays are stringified into their CSV cell so no data is silently dropped. Nulls become empty cells, and column order follows first-seen key order across all rows.

Use it in

Back to documentation Cleaning data Removing duplicates Handling missing values

Documentation

Converting formats

Move between CSV and JSON without surprises.

Quick answer

Steps

CSV → JSON: open Tools → CSV to JSON, load the delimited file, choose objects or arrays layout, then copy or download the JSON.
JSON → CSV: open Tools → JSON to CSV, paste or load JSON (array of objects, array of arrays, or single object), then download the CSV.
Empty CSV cells become null in JSON objects; nulls become empty cells going back.
Nested JSON values are stringified into their CSV cell.

Tips

Validate JSON syntax first — the tool reports the exact parse error.
Column order for arrays-of-objects follows first-seen key order across all rows.

Common questions

Which JSON shapes can I convert to CSV?: Three: an array of objects (each becomes a row, keys become columns), an array of arrays (first row becomes headers), or a single key-value object (becomes one row). Anything else reports an unsupported-shape error.
What happens to nested JSON values during conversion?: Nested objects and arrays are stringified into their CSV cell so no data is silently dropped. Nulls become empty cells, and column order follows first-seen key order across all rows.

Use it in

Back to documentation Cleaning data Removing duplicates Handling missing values

Converting formats

Quick answer

Steps

Tips

Common questions

Use it in

Loading Datio workspace…

Converting formats

Quick answer

Steps

Tips

Common questions

Use it in