📊

JSON to CSV

Convert JSON arrays to CSV and back

Input JSON
Output CSV

About JSON to CSV

Turns a JSON array of objects into a CSV file you can open in Excel or import into any database. Column headers come from the object keys, detected automatically. Handles edge cases correctly: commas inside values are quoted, quotes inside values are escaped, newlines in values are handled per RFC 4180. The output opens without mangled columns. CSV to JSON works in reverse — paste a CSV and get a clean array of objects. Useful when exporting data from spreadsheets or legacy systems and needing to consume it in code.

Common Use Cases

  • →Exporting API data to Excel or Google Sheets for non-technical stakeholders
  • →Preparing data for import into a database or CRM
  • →Converting analytics or log exports between formats
  • →Getting CSV exports from tools back into a format usable in code

Frequently Asked Questions

What JSON structure does this expect?+
An array of objects where each object has the same keys — the standard tabular data format. A single object is also supported and produces a one-row CSV.
What happens with nested objects?+
Nested objects are serialised as JSON strings within the CSV cell. For deeply nested data, flatten your JSON first.
Does it handle commas and quotes inside values?+
Yes. Values containing commas, quotes, or newlines are properly escaped per RFC 4180, so the output opens correctly in Excel and other tools.
Is there a row limit?+
No limit — everything runs in the browser. Large datasets with tens of thousands of rows work fine.