JSON to CSV Converter
Flatten a JSON array into spreadsheet-ready CSV.
About the JSON to CSV Converter
APIs speak JSON, but analysis happens in spreadsheets. When you need to eyeball an API response, share data with a colleague who lives in Excel, or import records into accounting software, converting a JSON array to CSV is the bridge. Paste an array of objects and this tool produces a CSV with a header row assembled from the objects' keys, one line per record, ready to save and open in any spreadsheet application.
The conversion handles the details that trip up hand-rolled scripts. Keys are collected across all objects, not just the first — so records with missing or extra fields still line up in the right columns, with blanks where a value is absent. Values containing commas, quotes or line breaks are wrapped and escaped per the CSV standard, so a note field with an embedded comma won't shift every subsequent column. The output downloads as a .csv file that Excel, Google Sheets and LibreOffice open directly.
One honest limitation: CSV is a flat, two-dimensional format, and deeply nested JSON doesn't flatten unambiguously. This converter expects an array of reasonably flat objects — the shape most list APIs return. If your objects contain nested objects or arrays, those values are serialised as JSON strings in their cell rather than exploded into extra columns, keeping the conversion lossless. Everything runs in your browser; your data is never uploaded.
Frequently asked questions
- What JSON shape does the converter expect?
- An array of objects — the standard shape of API list responses. Each object becomes one CSV row and the union of all keys becomes the header row.
- What happens to nested objects or arrays?
- They're kept as JSON strings inside their cell rather than expanded into columns, so no data is lost. Flatten nested structures upstream if you need them as separate columns.
- Will Excel open the output correctly?
- Yes — fields containing commas, quotes or line breaks are quoted and escaped per the CSV standard that Excel, Google Sheets and LibreOffice all follow.
Related tools
Turn spreadsheet CSV data into a clean JSON array.
JSON FormatterPretty-print, validate or minify JSON instantly in your browser.
Text Diff CheckerCompare two texts line by line and see exactly what changed.
Word CounterCount words, characters, sentences and reading time as you type.