JSON to CSV Converter
Convert a JSON object or an array of records into CSV in your browser. Choose whether nested objects remain JSON text in one cell or become dot-named columns. Review the detected column count, copy the text, or download a UTF-8 CSV.
Your JSON stays in this browser tab. A single object or a non-empty array of objects is supported.
Formula protection adds an apostrophe to text beginning with characters such as =, +, - or @. Disable it for a machine-readable round trip. Arrays stay JSON text; missing fields and null become empty cells. CSV cannot preserve spreadsheet cell types such as leading-zero IDs automatically.
What this tool helps with
JSON API exports often contain nested values and different fields across records. A naive conversion can overwrite keys, produce malformed quotes, or create spreadsheet formulas from untrusted text.
How to use it
- Paste JSON or select a local file up to 1 MB.
- Choose how nested objects are represented and whether spreadsheet formula protection is needed.
- Convert, review the columns and empty cells, then copy or download the CSV.
Requirements
A modern browser with JavaScript and file APIs. Inputs are processed locally; no account or server upload is used.
Limits and privacy
The top level must be one object or a non-empty array of objects. Maximum 1 MB, 10,000 records, and 500 columns. Arrays stay JSON text. Missing fields and null become blank cells. Flattened dot-path collisions are rejected. CSV has no cell types; spreadsheet software may strip leading zeros from IDs unless imported as text. Formula protection changes risky text with a leading apostrophe; disable it for machine round trips when appropriate. Inputs are processed locally in this browser. The site does not provide an upload endpoint for this tool.
Frequently asked questions
Does the tool upload my JSON?
No. Parsing and CSV generation run in this browser tab.
How are nested objects represented?
Keep them as JSON text in one cell, or flatten object keys into dot-named columns. Arrays remain JSON text in both modes.
Will leading-zero IDs survive in Excel?
The CSV text retains the zeros, but spreadsheet applications may infer a number and remove them when opening the file. Import those columns as text.
Why is a quote added before some values?
With spreadsheet formula protection enabled, strings starting with formula-like characters receive an apostrophe so opening an untrusted CSV is safer. Turn it off when the destination expects original machine-readable values.
Step-by-step guide
Export JSON records to CSV without losing nested data →