JSON to CSV
Turn JSON records into a CSV table.
- 1Add input
- 2Adjust settings
- 3Get your result
Tool input and files are processed in this browser without being uploaded.
Before you start
Export a JSON object array to CSV using the union of object keys. Exact JSON numeric tokens are retained; nested structures become JSON text, and formula-like strings are escaped by default.
How to use this tool
- Paste content into “JSON input” or choose a local file.
- Review Delimiter before selecting “Convert to CSV”.
- Review the CSV result, then use the available copy or download controls.
Supported inputs and limits
Pasted JSON is limited to 1 MiB, files to 10 MiB and output to 200,000 cells. Nonempty object arrays are required. Formula-like strings and headers gain an apostrophe; JSON numbers retain exact tokens. Spreadsheet apps may remove that prefix after resaving.
Worked example
Example input
[{"id":"001","nested":{"x":1}},{"id":9007199254740993,"formula":"=1+1"}]Example options
{}Example output
id,nested,formula
001,"{""x"":1}",
9007199254740993,,'=1+1When something does not work
Correct the reported syntax or range and run again. Formatting is not execution: scripts, SQL, expressions and pasted markup do not run against your system or a remote service.
Frequently asked questions
Are my files uploaded?
No. Files and tool input are processed in your browser. Moving around the site can keep a temporary workspace in the same tab. Refreshing or closing the tab clears it, so download results you want to keep.
What should I check in this result?
Export a JSON object array to CSV using the union of object keys. Exact JSON numeric tokens are retained; nested structures become JSON text, and formula-like strings are escaped by default.