JSON to CSV
Convert JSON arrays and objects into CSV with flattening, custom delimiters, and quote control
Interactive tool
JSON input
No JSON to convert
Paste a JSON array or object to generate CSV instantly
What is a JSON to CSV Converter?
A JSON to CSV converter takes structured JSON data and produces flat tabular CSV suitable for spreadsheets, databases, and analytics tools. It handles nested objects through key flattening, configurable delimiters, optional header rows, and bulletproof quoting for fields containing commas, newlines, or quotes.
How to Use This JSON to CSV Converter
- 1Paste your JSON array or object into the input area
- 2Choose delimiter: comma, semicolon, tab, or pipe
- 3Pick line endings (LF for Unix, CRLF for Windows/Excel)
- 4Toggle header row, quote-all, and nested-object flattening
- 5Copy the CSV or download the file directly
Key features
Nested Object Flattening
Dot-path keys turn deeply nested JSON into clean spreadsheet columns
Multiple Delimiters
Comma, semicolon, tab, and pipe support major locales and tools
Header Row Toggle
Generate with or without a header row to match the consumer
Quote-All Mode
Wrap every value in quotes for strict CSV consumers and ambiguous locales
CRLF or LF
Excel-friendly CRLF or Unix-friendly LF line endings on demand
Live Conversion
Output recalculates as you tweak input or options
Direct Download
Save as .csv with one click: no roundtrip through clipboard
100% Private
Conversion runs in your browser. Nothing is uploaded
Why Convert JSON to CSV?
JSON is great for APIs and configuration. CSV is great for spreadsheets, BI tools, ETL pipelines, and bulk imports. A reliable converter bridges the two without spinning up a script: paste API output, get a CSV ready for Excel, Google Sheets, Postgres COPY, or your data warehouse loader.
Common use cases
- Exporting API responses for spreadsheet analysis
- Preparing bulk imports for databases and CRMs
- Generating reports from log payloads
- Migrating data between systems with mismatched formats
- Sharing structured data with non-technical stakeholders
- Loading JSON datasets into BI tools that expect CSV
- Quick conversion during data debugging
- Building deterministic snapshots for diffing
How Nested Flattening Works
When flattening is enabled, nested keys are joined with a dot. {"address": {"city": "Paris"}} becomes the column "address.city". Arrays of primitives are joined with commas; arrays of objects are flattened by index (tags.0, tags.1). This produces predictable, reversible column names for downstream tooling.
CSV Quoting and Escaping
Values containing the delimiter, double quotes, or newlines are wrapped in double quotes, with internal double quotes doubled (RFC 4180). Quote-all mode wraps every value, which is safer for some loaders but produces larger files. Choose based on the consumer.
Tips & best practices
Use CRLF for Excel
Excel on Windows handles CRLF line endings most reliably. Use LF for Unix-based tools and editors
Pick a delimiter your data does not contain
If your data is full of commas, switch to tab or pipe delimiter to reduce quoting noise
Quote-all for strict consumers
Some loaders fail on ambiguous numbers. Quote-all forces every field to be a string, which is safer for some pipelines
Verify column count
The stats show row and column counts. Compare against the source JSON to catch unexpected nested structure
Disable flattening for arrays of primitives
When you want the array values joined as a single comma-separated cell, leave flatten on. It already handles primitive arrays inline
Privacy & security
This JSON to CSV converter runs entirely in your web browser. Your data is never uploaded to any server, stored in any database, or transmitted anywhere. All conversion happens locally on your device.
Related tools
- JSON Formatter & Validator
Format, validate, and beautify JSON data instantly in your browser
Developer Tools
- Base64 Encoder & Decoder
Encode and decode Base64 strings instantly in your browser
Developer Tools
- UUID & ULID Generator
Generate UUID v4, UUID v7, and ULID identifiers instantly
Developer Tools
- CSV to JSON
Convert CSV data into JSON arrays with header detection, type inference, and configurable delimiters
Developer Tools
- Hash Generator
Generate MD5, SHA-1, SHA-256, SHA-384, and SHA-512 hashes instantly
Developer Tools
- Password Strength Checker
Check password strength with detailed analysis, entropy calculation, and security recommendations
Developer Tools
Frequently Asked Questions
What JSON shapes are supported?
The converter accepts a JSON array of objects (the most common case), a single object (becomes one row), or arrays of mixed primitives. Top-level primitives or arrays of arrays are not directly representable as CSV without a clear schema.
How are nested objects converted?
When "Flatten nested" is enabled, nested keys are joined with a dot. {"address": {"city": "Paris"}} becomes a column named "address.city". Arrays of primitives are joined with commas. Arrays of objects are flattened by index (tags.0, tags.1, etc).
Why do some fields appear empty in the CSV?
When records have different keys, the union of all keys forms the columns. Records without a particular key produce empty cells in that column. This is standard CSV behavior and matches what spreadsheets expect.
Should I use comma or semicolon delimiter?
Comma is the universal default. Use semicolon for European locales where commas appear in numbers. Use tab for TSV files. Use pipe when your data already contains commas, semicolons, and tabs.
Why does Excel show all data in one column?
Excel uses the system locale to choose a default delimiter, which may not be comma. Open the CSV via Data → From Text/CSV in Excel, or save with semicolon delimiter for many European installs. Alternatively, use the Tab delimiter and rename to .tsv.
Is my data uploaded anywhere?
No. The converter runs entirely in your browser using the Papa Parse library. JSON data is never uploaded, stored, or transmitted to any server.