Convert JSON to CSV
Paste a JSON list and get a clean spreadsheet: one row per item, one column per field, ready to open in Excel.
Sealed on this device
Runs in your browser. Nothing is uploaded.
Sealed
CSV JSON
Your CSV will appear here as you type.
Your JSON will appear here as you type.
How it works
-
Paste or open your JSON
Paste it, type it, drop a .json file or open one. The conversion starts as soon as there is something to read.
-
Check the table
See the rows and columns before you save. Choose the separator, and keep nested objects flattened or as JSON.
-
Download the CSV
Open it in Excel, LibreOffice or Google Sheets, or copy the text to paste it somewhere else.
Frequently asked questions
Is my JSON uploaded to a server?
No. The conversion runs entirely in your browser, so API responses, exports and customer data never leave your device.
What kind of JSON can I convert?
A list of objects gives one row per object and one column per key, even when the objects don’t all have the same keys. A single object gives one row, and a list of lists is written row by row. If the JSON wraps a single list, such as an API response with a “results” list, that list is used.
How are nested objects and lists handled?
Nested objects become columns with dotted names, such as address.city. Lists are written as JSON text in a single cell, for example ["math","poetry"], so nothing is lost. The CSV to JSON tool can rebuild both.
Why do some cells start with an apostrophe?
Spreadsheet apps treat a cell that starts with =, +, - or @ as a formula. A value hidden in data from elsewhere could then open a web page or run a command when the file is opened, which is known as CSV injection. With “Block formulas” on, those cells get a leading apostrophe, so Excel, LibreOffice and Google Sheets show them as plain text. Ordinary numbers such as -12 are left alone. Turn the option off if the CSV is meant for a program rather than a spreadsheet.
Excel puts everything in one column or shows odd characters. What can I do?
If everything lands in the first column, your Excel expects semicolons, which is common where the comma is the decimal separator: choose “Semicolon” as the separator. If accents look wrong, keep “Excel-ready (UTF-8 BOM)” on, so Excel knows the file is UTF-8.
Are numbers kept exactly?
Yes. Numbers are written exactly as they appear in your JSON, so long identifiers and precise decimals are not rounded.