DataHub Tools JSON to CSV

JSON to CSV Converter

Local-first

Convert JSON arrays to CSV locally in your browser for spreadsheets, BI tools, imports, and data cleanup.

How this tool actually works

The converter parses strict JSON, flattens nested object fields, merges discovered columns, and quotes every CSV field while doubling embedded quotes. It is best suited to trusted object arrays with stable field names.

  • Flatten nested object fields
  • Quote and escape CSV fields
  • Download comma-separated rows

How to use it

  1. Paste a JSON array of records from a trusted source.
  2. Review columns, nulls, newlines, quotes, and nested paths.
  3. Check cells beginning with =, +, -, or @ before opening in spreadsheet software.
  4. Download only after confirming encoding and downstream import rules.

Quick example

Example input

[{"name":"Ada","note":"Line 1, \"quoted\"","formula":"=1+1"}]

Expected result

"name","note","formula"
"Ada","Line 1, \"\"quoted\"\"","=1+1"

Quoting is not spreadsheet formula neutralization. Untrusted cells beginning with formula characters can remain dangerous when the CSV is opened.

Best use cases

  • Export trusted API records to a spreadsheet-ready draft.
  • Flatten simple nested records for BI import.
  • Inspect CSV quoting for commas, quotes, and newlines.

References and scope

RFC 4180 documents a common CSV format, but spreadsheet applications add their own formula behavior. CWE-1236 describes the resulting injection risk.

Sources checked July 24, 2026. Specifications and platform behavior can change; verify the sources before formal use.

Known limitations

  • Literal dot keys can collide with flattened object paths.
  • Primitive arrays and empty nested structures do not map reliably.
  • The file uses LF line endings and does not add a spreadsheet-specific formula prefix.

FAQ

Which JSON shape works best?

An array of objects with consistent, non-conflicting fields.

Are commas and quotes escaped?

Yes. Every field is quoted and embedded double quotes are doubled.

Is the CSV safe for untrusted input?

Not automatically. Formula-like cells require a policy appropriate to the receiving spreadsheet.

Are nested objects supported?

They are flattened with dot-separated paths; arrays and empty structures need manual review.

Related Tools

CSV to JSON Convert CSV rows into clean JSON arrays in your browser. CSVJSON CSV to Markdown Convert CSV or TSV data into a GitHub-style Markdown table. CSVMarkdown Markdown to CSV Convert Markdown tables into CSV rows for spreadsheets. MarkdownCSV JSON to Markdown Convert JSON arrays into Markdown tables locally. JSONMarkdown Markdown to JSON Convert Markdown tables into JSON arrays for data cleanup. MarkdownJSON HTML to Markdown Convert common HTML headings, links, lists, code, and tables into Markdown. HTMLMarkdown Markdown to HTML Convert Markdown headings, lists, links, code blocks, and tables into HTML. MarkdownHTML YAML to JSON Convert YAML config into formatted JSON in your browser. YAMLJSON JSON to YAML Convert JSON objects and arrays into readable YAML. JSONYAML

Related tool guides

JSON Tools A focused set of local-first JSON tools for formatting, validation, comparison, schema generation, and conversion to CSV, YAML, Markdown, XML, SQL, and HTML tables. CSV and Table Tools Local-first CSV, Excel, Markdown table, HTML table, YAML, SQL, and LaTeX conversion tools for data cleanup, publishing, and documentation workflows.