Skip to content
T
Tools.Town
Free Online Tools for Everyone
id,name\n1,Alice

JSON to CSV Converter

100% Free

Convert JSON arrays into CSV — RFC 4180 escaping, configurable delimiter, optional flatten of nested objects, instant download.

Real-time
Client-Side
RFC 4180
Delimiter
CSV output 
Paste JSON above to convert to CSV…

Embed This Tool

Easy to Embed

Add JSON to CSV Converter to your website or blog in seconds.

  • Responsive design
  • Lightweight & fast
  • No backend required
  • Always up-to-date 
<iframe
  src="https://tools.town/embed/json-to-csv/"
  width="100%"
  height="600"
  style="border:none; border-radius:12px;"
  loading="lazy"
  title="JSON to CSV Converter">
</iframe>

Share This Tool

Share Instantly

Share JSON to CSV Converter with anyone — no login required.

  • Shareable link
  • No login required
  • Works on any device
  • No account needed

Share via

Advertisement

How to Use

  1. 1 Paste a JSON array of objects (or click 'Load sample')
  2. 2 Pick a delimiter — comma, semicolon, tab, or pipe
  3. 3 Optionally enable 'Flatten nested' to expand objects to dot-notation columns
  4. 4 Optionally toggle 'No header' to skip the column-name row
  5. 5 Copy the CSV or download as a .csv file

Features

  • RFC 4180 escaping (commas, quotes, embedded newlines)
  • Header detection from union of all object keys
  • Four delimiter options
  • Flatten nested objects into dot-notation columns
  • Auto-handles array-of-primitives (single 'value' column)
  • Direct .csv download with one click

Why it Matters

Spreadsheets eat CSV; APIs spit JSON. Converting between them is one of the most common data-shuffling tasks in any analyst's day. A reliable, escape-correct converter that handles edge cases (commas in names, multi-line cells, nested objects) saves you from Excel mangling your data.

★★★★★

Use Cases

Excel Import

Convert API JSON to a CSV your boss can open in Excel

Data Migration

Export NoSQL JSON to a CSV for SQL bulk-import

API → BI Tool

Feed JSON API output into Tableau / Looker via CSV

Frequently Asked Questions

What happens to nested objects?
By default they're JSON-stringified into the cell. Toggle 'Flatten nested' to expand them into dot-notation columns (e.g. `meta.id`, `meta.name`).
How do you handle commas in names?
RFC 4180: cells containing the delimiter, double quote, or newline get wrapped in double quotes; embedded quotes are doubled. Excel and Google Sheets parse this correctly.
What if my JSON is a single object, not an array?
The converter wraps it in a single-row CSV. The row's keys become the header; the values become the row.
Why does my CSV open as one column in Excel?
Excel auto-detects delimiter based on locale. In some EU locales, Excel expects semicolons. Switch the delimiter to ';' and re-export.
📖

Want to understand the math?

Browse all guides →
How to Use JSON to CSV
json

How to Use JSON to CSV — Complete Guide

Learn how to convert JSON arrays to spreadsheet-ready CSV using the free JSON to CSV tool on Tools.Town — flatten nested objects, pick columns, download instantly.

7 May 2026

5 min read

Related Tools You Might Like

CSV to JSON Converter

Parse CSV (RFC 4180) into structured JSON — quoted fields, embedded newlines, auto-typing for numbers/booleans, instant download.

JSON to XML Converter

Convert JSON to well-formed XML — configurable root element, repeated elements for arrays, escaped special chars, optional XML declaration.

XML Formatter

Pretty-print or minify XML — handles XML declarations, comments, CDATA, self-closing tags, and HTML void elements.

JSON Formatter

Beautify, minify, and sort-key JSON in real time. Surfaces parse errors with line + column. 100% client-side.

JSON Validator

Validate JSON in real time with structural diagnostics — node count, max depth, type counts, and precise parse-error location.

Browse more free tools
More Data Tools All categories