Jsony

JSON to CSV Converter

Convert JSON arrays to CSV in your browser. Pick your delimiter, choose whether to include a header. Your data never leaves the page.

Delimiter

What is the Jsony JSON to CSV Converter?

A fast, private converter that turns JSON arrays into CSV files ready to drop into Excel, Google Sheets, a database import tool, or a BI dashboard. Pick the delimiter, decide whether you want a header row, paste your JSON, and copy the result.

Like the rest of Jsony, the conversion happens in your browser — no upload, no server endpoint, no telemetry on your data. The same Web Worker that powers the JSON Formatter parses and serialises here too, so multi-megabyte inputs stay snappy.

How to use it

  1. Paste or load JSON.An array of objects is the sweet spot — that's the standard API response shape. A single object also works (becomes one row).
  2. Pick a delimiter. Comma is the default and what most tools expect. Tab gives you TSV (often friendlier when your data already contains commas). Semicolon is common in European locales.
  3. Toggle the header row. On by default — the first row contains column names derived from your object keys.
  4. Click Convert (or just paste — it auto-converts). The CSV appears in the right pane, with row and column counts in the status pill.
  5. Copy or paste into your destination. Use Copy CSV for the whole result, or select a portion and use Cmd/Ctrl+C.

Common use cases

Importing API responses into a spreadsheet. Pull a response from Postman, Insomnia, or curl, paste it here, copy the CSV, paste into Sheets. Two-step pipeline beats writing a script for one-off explorations.

Bulk-loading data into a database. Most database import tools (Postgres COPY, MySQL LOAD DATA, BigQuery, etc.) prefer CSV over JSON. Convert here, save the file, run the import.

Sharing data with non-technical colleagues. Not everyone reads JSON comfortably. CSV opens in Excel and Sheets natively — much easier to send to product, finance, or marketing teammates.

Cleaning up scraped or exported data. Some export tools dump JSON when you really want a flat table. Convert here, drop the result into your tool of choice.

What about nested objects?

When a cell value is itself an object or array, the converter stringifies it as JSON and escapes it into a single CSV cell. So a row like {"id":1,"tags":["a","b"]} becomes a CSV with two columns: id = 1, tags = "["a","b"]" (escaped). No information is lost — the destination tool can either treat the cell as opaque text or re-parse the JSON.

A future version may add a "flatten with dot notation" option that turns nested keys into parent.child columns. Until then, if you need flat output, transform the JSON first (the JSON Formatter's JSONPath query bar is good for this).

Frequently asked questions

What kinds of JSON can it convert?
Best with an array of objects (the typical API response shape). A single object becomes a one-row CSV. An array of primitives becomes a single 'value' column. Nested objects and arrays in cell values are JSON-encoded into the cell so no information is lost.
How are special characters escaped?
RFC 4180 escaping. Cells containing the delimiter, double quotes, newlines, or carriage returns are wrapped in double quotes, and any literal double quotes are doubled (""). This matches what Excel, Google Sheets, and most CSV parsers expect.
Can I produce TSV (tab-separated values)?
Yes. In the Delimiter setting, pick Tab. Pick Semicolon if you're working with European locales where comma is the decimal separator.
Is my data private?
Yes. The conversion runs in a Web Worker in your browser. There is no server endpoint, no upload, no analytics tracking your input. The complete source is open — see the GitHub link in the footer.
What happens if the rows have different keys?
The header row is the union of all keys, in first-seen order. Rows missing a key get an empty cell for that column. So a heterogeneous array still produces a clean rectangular CSV.
Will this handle large files?
Yes. Conversion runs in a Web Worker so the UI stays responsive even on multi-MB inputs. The same engine that powers the formatter handles the parse step.

Related tools

The JSON Formatter & Validator is the place to start if you need to clean up or explore your JSON before converting. More Jsony tools are on the way: a JSON Diff for comparing two documents, a JWT decoder, and a Base64 encoder.