How to Convert JSON to CSV Online — Free, No Installation
Convert JSON arrays to CSV spreadsheets in your browser. Handles nested objects, arrays, mixed schemas, and exports ready-to-open Excel, Numbers, or Google Sheets files.
The common scenario
Your API returns JSON. Your boss wants a spreadsheet. The JSON to CSV converter bridges that gap in one click. Paste the response, get a download-ready CSV file that opens cleanly in Excel, Numbers, LibreOffice, or Google Sheets.
What the converter handles
- Flat arrays of objects — the standard case; each object becomes a row, each key becomes a column
- Nested objects — flattens with dot notation (
user.namebecomes a column) - Arrays inside rows — joined with semicolons or pipe-delimited
- Mixed schemas — different objects with different keys; missing values become empty cells
- Special characters — commas, quotes, and newlines inside values are properly escaped per RFC 4180
CSV gotchas to know
- Excel and locale — some European Excel installs expect semicolon as the delimiter; the converter lets you pick
- BOM — Excel needs a UTF-8 byte-order-mark to show emoji and non-ASCII correctly; the tool adds one when you select Excel mode
- Numbers as strings — if a column contains a leading zero (zip codes, phone numbers), Excel strips it; the converter offers text-mode export that preserves leading zeros
- Dates — ISO format (
2026-04-16) is safest; Excel will auto-interpret
Converting the other direction
Going CSV → JSON is common when importing spreadsheet data into APIs, databases, or config files. Use CSV to JSON.
Working with the JSON first
If your JSON is unformatted or broken, run it through JSON formatter first to validate and visualize structure. For drilling into deeply nested JSON to pick what becomes columns, use JSON viewer to inspect the tree, then flatten the subtree you want.
Privacy-preserving
All conversion runs in your browser. The JSON never leaves your device — which matters when you're exporting user data, analytics, or internal operational records.
When to use a database instead
If your JSON is more than ~50,000 rows, spreadsheets start to struggle and relational databases win. Import into Postgres or SQLite (both open CSV natively) for real querying and analysis.
Featured Tools
Try these free tools directly in your browser — no sign-up required.
JSON to CSV Converter
Convert JSON arrays to CSV format instantly. Transform nested JSON data into spreadsheet-ready CSV files with automatic header detection.
CSV to JSON
Convert CSV files and data to JSON format instantly. Supports custom delimiters, header row detection, and pretty-printed or minified output.
JSON Formatter
Format, beautify, and validate JSON instantly. Paste raw JSON and get a clean, indented, human-readable output with syntax error detection.
JSON Viewer
View JSON as an interactive collapsible tree. Paste JSON and explore nested objects and arrays visually. Click nodes to expand or collapse. Search within the tree.