How to convert JSON to CSV
- Paste a JSON array of objects (like an API response) into the JSON input box.
- Pick a delimiter — comma works with Excel and Google Sheets; semicolon suits some European locales.
- Click Convert to CSV. The first row becomes the header, each object becomes a row, and values are escaped automatically.
- Copy the result or Download .csv to open it directly in a spreadsheet app.
How the converter handles your data
- Objects → rows, keys → columns. Column order follows the order keys first appear in your data.
- Missing keys become empty cells — rows don't have to share every field.
- Nested objects & arrays are stored as compact JSON in their cell so no information is lost.
- Correct escaping — fields containing commas, quotes or newlines are quoted and escaped exactly as the CSV standard requires.
- CSV → JSON parses quoted fields (even multi-line ones), then rebuilds an array of objects using the header row.
- Full privacy — conversion happens locally in your browser. Sensitive data never leaves your machine.
Why convert JSON to CSV?
JSON is the native format for most web APIs, but business users live in spreadsheets. Converting to CSV lets you open API exports, analytics dumps or config listings in Excel, Google Sheets or a data-science notebook. Because the conversion is done in your browser, even data you would not normally paste into a website — customer lists, internal reports — stays private.
Frequently asked questions
Does it work with any JSON, or only arrays of objects?
The common case is an array of objects, which maps naturally to a table. A single object becomes a one-row CSV. An array of arrays becomes a matrix, and an array of plain values becomes a single value column.
What happens to nested objects and arrays inside my JSON?
They are kept intact as compact JSON inside their cell (for example ["ts","go"]). This guarantees a lossless round trip: converting back from CSV restores the same structure. If you need each field spread across separate columns, flatten the JSON first with a tool like jq.
Why do some cells have quote marks around them?
That is standard CSV escaping. When a value contains your chosen delimiter, a double-quote or a line break, the cell is wrapped in quotes and internal quotes are doubled. Spreadsheet apps understand this automatically.
Excel shows odd characters or splits columns — what now?
Use the Download .csv button rather than copy-pasting: it adds a UTF-8 byte-order mark that helps Excel detect the encoding. If columns still split oddly, try switching the delimiter to match your region's list separator.
Is my data uploaded anywhere?
No. Both directions of this converter run entirely in JavaScript inside your browser. Your data is never transmitted, stored or logged by us.