JSON to CSV Converter
Paste a JSON array and instantly get a CSV file. Control delimiter, headers, and nested object handling. Also converts CSV back to JSON.
How to use JSON to CSV Converter
The JSON to CSV Converter transforms JSON arrays of objects into comma-separated values files that can be opened directly in Excel, Google Sheets or any data-analysis tool. It automatically infers column headers from object keys, handles nested properties via dot-notation flattening, and lets you customise the delimiter, quote character and line endings — making it the fastest way to get JSON API data into a spreadsheet.
- Paste your JSON array (an array of objects) into the input field, or upload a .json file.
- The tool inspects the first object to infer column headers — review and reorder them in the column picker.
- Choose your output delimiter: comma (CSV), tab (TSV), semicolon or pipe.
- Select line endings: CRLF (Windows) or LF (Unix/Mac).
- Toggle whether to include the header row and whether to quote all fields or only fields containing the delimiter.
- Click Convert and download the .csv file or copy the output.
Your data never leaves your device — 100% private processing.
Handling nested JSON objects
Real-world API responses often contain nested objects and arrays. The converter flattens one level of nesting by joining parent and child keys with a dot: {"user": {"name": "Alice"}} becomes the column user.name. Arrays within objects are serialised as JSON strings in a single cell, preserving the data while maintaining the flat structure required by CSV. For deeply nested data, consider restructuring the JSON before converting or using a dedicated ETL tool.
CSV format variations and gotchas
Despite the name, "comma-separated values" files do not always use commas. European locales where commas serve as decimal separators typically use semicolons instead. RFC 4180 defines a minimal CSV standard but is not universally observed — some tools expect double-quotes only around fields containing the delimiter, while others quote all fields. Field values containing newlines must be quoted, and embedded quotes are escaped by doubling them ("He said ""hello""."). Choosing the right dialect for your target application avoids import errors.
| Dialect | Delimiter | Quote char | Common use |
|---|---|---|---|
| RFC 4180 CSV | , | " | Excel (US), Google Sheets |
| TSV | Tab | None | Unix tools, R, Python pandas |
| Semicolon CSV | ; | " | Excel (European locales) |
| Pipe-delimited | | | " | Database exports, EDI |
Glossary
- CSV
- Comma-Separated Values — a plain-text format representing tabular data with one record per line.
- TSV
- Tab-Separated Values — a CSV variant using tab characters as delimiters, common in data science.
- Flattening
- Converting nested JSON objects into a flat key-value structure by joining key names with a separator.
- RFC 4180
- An informational IETF memo defining the most common CSV format with double-quote field enclosure.
- Delimiter
- The character (comma, tab, semicolon, pipe) used to separate fields within a CSV record.
Related reading
Frequently Asked Questions
Get weekly tool tips & updates
New tools, power-user tips, and productivity hacks — delivered free every Friday.
No spam, ever. Unsubscribe with one click.
Why use JSON to CSV Converter?
- No installation — use directly from any browser
- Handles large inputs without crashing or timeouts
- Syntax highlighting and formatted output for readability
- Copy to clipboard shortcut for fast workflow integration
Common use cases
- Validate and format JSON responses from APIs
- Encode/decode Base64 strings during debugging
- Generate UUIDs for database seeds or test data
- Minify CSS or JavaScript before deployment
- Diff two code snippets to spot regressions
Related Developer Tools
JSON Formatter & Validator
Format, validate, and minify JSON instantly. Includes syntax highlighting, error detection, and a collapsible tree view — free, private, in-browser.
Base64 Encoder & Decoder
Encode text or files to Base64, or decode Base64 strings back to text. Fast, free, and runs entirely in your browser.
URL Encoder / Decoder
Encode and decode URLs and URL components online. Convert special characters to percent-encoding and back instantly — free, private, and fast.
Regex Tester
Test and debug regular expressions online. See live matches, capture groups, and replace output. Free, private, instant.
HTML Encoder / Decoder
Encode and decode HTML entities online. Escape <, >, &, and quote characters for safe HTML display. Free, instant, and private — runs in your browser.
Hash Generator
Generate MD5, SHA-1, SHA-256, SHA-384, and SHA-512 hashes online. Hash text or files privately in your browser.
Explore all Developer Tools.