JSON to CSV Converter
Turn JSON arrays into CSV tables with a header row. Handles nested objects, custom delimiters and quoted fields.
Last updated: April 2026 · Runs in your browser · No sign-up
Why convert JSON to CSV
APIs return JSON; business users want Excel. Converting gives you a file non-technical colleagues can open, sort and pivot without extra tooling. CSV also imports cleanly into databases via tools like COPY (PostgreSQL) or LOAD DATA (MySQL).
Frequently Asked Questions
What JSON shape is expected?
An array of flat objects — [{"name":"Ada","age":36},{"name":"Alan","age":41}]. Each unique key across objects becomes a column header.
How are nested objects handled?
They can be flattened (user.name → 'user.name' column) or stringified into a single cell as JSON. Pick whichever matches how you'll consume the CSV.
Which delimiter should I use?
Comma is the default and widely supported. Use semicolon for European Excel (which expects locale-specific separators) or tab (TSV) if your data contains commas.
Are quotes and special characters handled?
Yes — fields containing the delimiter, quotes or newlines are wrapped in double quotes, with internal quotes doubled per RFC 4180.