JSON to CSV
JSON to CSV — runs in your browser. Inputs are not stored.
JSON → CSV
Only arrays of objects are supported. Headers are the union of keys from the first objects. Nested objects are stored as JSON strings.
How to use
- Paste
[{...},{...}]form into JSON (array of objects). The top level must be an array. - Press Convert and check table text in the CSV field below.
- To put it in a spreadsheet, take it with Copy result then paste into Excel or Sheets.
- If parse errors, read the status message, fix commas and quotes, then convert again.
- For other data, Reset clears input and result.
Key concepts
JSON to CSV is for turning an API response or mock object array into a table ops or product can read. Even if keys differ per object, the header is the union of all keys. Missing keys become empty cells. Nested objects or array values go into one cell as a JSON string, so if you need a fully flat table, unroll fields first.
If a value has commas, quotes, or newlines, it is wrapped in double quotes per CSV rules. This tool runs only in the browser and does not send to a server. A single top-level object or a number array will not convert—shape it as a row-wise object array. Korean headers are kept as-is.
Example
Input [{"name":"hong","age":30},{"name":"kim","city":"seoul"}] yields headers name, age, city; the first row has an empty city and the second has an empty age. Nesting puts a string such as {"a":1} in that cell. Before handing to product, unrolling nesting into columns is easier to filter in Excel. Union-of-keys order can push fields missing from the first object to the right; move columns after convert if you need a fixed order. Large arrays can strain the tab, so converting in chunks of a few thousand rows is safer. If a date string becomes a number in Excel, import it as a text column. When retrying, reset first so old output is not mixed in. On a shared computer, clear the fields when you finish. Closing the tab discards what you pasted; no server delete is needed.
Related: CSV → JSON · JSON formatter · JSON → YAML
Frequently asked questions
Must the top level be an array when converting JSON to CSV?
Yes. If you have a single object, wrap it in an array then convert.
Does nested JSON convert to CSV?
Yes, but nested values go into one cell as a JSON string. They are not exploded into columns.
How is the header made for an object array with different keys?
It is the union of every key that appears. Missing cells are empty.
Is JSON-to-CSV data sent to a server?
No. Conversion runs only in the browser.
Do numbers go out of CSV without quotes?
Plain numbers and booleans are written as-is; only strings that contain commas are wrapped in quotes.
What if Korean breaks in Excel?
This result is UTF-8 text. In Excel, specify UTF-8 under Data import.
Last reviewed: 2026-09-04