JSON to CSV
Convert a JSON array of objects into RFC 4180 CSV. Headers come from the union of object keys. Values with commas, quotes, or newlines are auto-quoted. Runs entirely in your browser — no upload.
JSON in, CSV out
See exactly how JSON maps onto CSV — the converter on this page produces output identical to the example below.
[
{"id":1,"name":"Alice","age":30,"city":"NYC"},
{"id":2,"name":"Bob","age":25,"city":"SF"},
{"id":3,"name":"Charlie","age":35,"city":"LA"}
]id,name,age,city 1,Alice,30,NYC 2,Bob,25,SF 3,Charlie,35,LA
What you'll use this for
Converting JSON to CSV is a daily task in API integration, config management, and data pipelines.
API integration
Convert API JSON responses into CSV for downstream pipelines or analysts.
Config migration
Move between JSON-based APIs and CSV-based spreadsheets effortlessly.
Data import
Feed CSV into Postgres COPY, MySQL LOAD DATA, BigQuery, or Snowflake.
CI pipelines
Script the conversion in CI to produce reports from JSON build artifacts.
How to convert JSON to CSV
Paste your JSON
Drop it into the left editor. The sample is loaded by default — clear it or click the wand to reload.
Click Convert
Or leave auto-convert on for live updates. Conversion runs entirely in your browser — no upload.
Copy or download
Copy to clipboard or save the output as data.csv.
Reverse if needed
Jump to the CSV to JSON converter for a round-trip check.
Frequently asked questions
CSV is text-only — numbers, booleans, and strings all become text fields. Nested objects/arrays are stringified as JSON.
Nested objects and arrays are emitted as JSON strings inside the CSV cell (and properly escaped).
Yes. No signup, no limits.
You'll see a clear parse error in the output panel.
Use the CSV to JSON converter for the opposite direction.
About JSON and CSV
JSON is a structured, nested format with types. CSV is a flat, tabular text format defined by RFC 4180. Converting JSON arrays to CSV is common when feeding spreadsheets, BI tools, or SQL COPY commands.
Common pitfalls
- Each JSON object should have a similar shape — missing keys become empty cells.
- Nested objects/arrays get serialized as JSON strings inside cells.
- Values containing commas, quotes, or newlines are auto-quoted per RFC 4180.
- Excel users: open the CSV via Data → Import to control delimiters.