Promptyard
JSON

JSON ↔ CSV

Convert between flat JSON arrays and CSV / TSV — RFC 4180 quoting via PapaParse.

JSONCSV
3 rows

How it works

Powered by PapaParse, the most-used CSV parser on npm. Handles RFC 4180 edge cases (embedded commas, quote escaping, multi-line fields). Picks delimiter via the dropdown — Excel exports often use semicolons in EU locales.

FAQ

What if my JSON has nested objects?
CSV is flat, so nested objects flatten poorly. The converter only handles arrays of flat objects. For nested data, flatten first (e.g., JSONPath) or use a different export format.
Why are quotes appearing around values that don't need them?
CSV quotes any value containing the delimiter, a quote, or a newline. PapaParse follows RFC 4180. To force always-quote or never-quote, use the npm library directly with config.
TSV (tab-separated)?
Yes — switch the delimiter dropdown to "tab".
Header row required for CSV → JSON?
Yes. The first row becomes property names. Without a header row, use the npm library with header: false to get arrays of arrays.

Related tools