JSON to CSV Converter
Paste JSON, get a clean CSV you can copy or download.
How to use
- Paste your JSON into the input pane. An array of objects works best; a single object becomes one row.
- Pick a delimiter and choose whether to include a header row.
- The CSV appears in the output pane as you type.
- Copy the result to your clipboard or download it as data.csv.
About this tool
This tool converts JSON to CSV so you can move data from APIs, logs, and config files into spreadsheets. Paste a JSON array of objects and each object becomes a row. The column set is the union of every key found across all rows, in the order they first appear, so objects with different shapes still line up correctly; missing values become empty cells.
Values that are themselves objects or arrays are kept as JSON text inside their cell rather than silently dropped, which preserves the data for a later pass. Quoting and escaping follow the CSV rules spreadsheets expect: embedded commas, quotes, and line breaks are handled so Excel and Google Sheets read the file cleanly. If your locale uses semicolon-separated CSV, switch the delimiter before exporting.
The conversion runs completely in your browser. Nothing is uploaded to a server, which makes it safe for customer exports, API responses with credentials in them, and anything else you would rather not paste into a random website that phones home. Common uses: turning an API response into a spreadsheet for a stakeholder, prepping data for a bulk import, or eyeballing a JSON dump in tabular form.
Frequently asked questions
+Is it safe to paste sensitive JSON here?
Yes. The conversion runs entirely in your browser using JavaScript. Nothing you paste is uploaded, logged, or stored, and the tool keeps working even if you disconnect from the internet after the page loads.
+How does the converter handle nested JSON?
Nested objects and arrays are written into their cell as JSON text. Every top-level key becomes a column, and rows that are missing a key get an empty cell. If you need nested keys flattened into separate columns, flatten the data before converting.
+How do I open the CSV in Excel?
Download the file and open it in Excel, or copy the output and paste it into a sheet. If your Excel expects semicolons, which is common with European regional settings, set the delimiter option to semicolon first.
+What JSON structure does the converter expect?
An array of objects works best: each object becomes a row and each key becomes a column. A single object becomes a one-row CSV, and an array of plain values becomes a single value column.
+Is there a file size limit?
There is no hard limit. Conversion happens in your browser's memory, so very large inputs may be slow depending on your machine. A notice appears once the input passes 5 MB.