How does nested object flattening work?

Nested objects are flattened using dot notation by default. For example, {user: {name: 'Alice', address: {city: 'NYC'}}} becomes columns user.name and user.address.city. Arrays are indexed like items[0].name, items[1].name. This preserves the hierarchical relationship while creating flat CSV rows.

Which delimiter should I use?

Comma (,) is the standard for most applications and English locales. Semicolon (;) is common in European countries where comma is used as decimal separator. Tab (\t) creates TSV files which are useful when your data contains many commas. Choose based on your target application's import requirements.

Can I convert large JSON files?

Yes, there's no strict file size limit, but very large files (10MB+) may slow down your browser. For typical use cases — API responses up to 10,000 rows, configuration files, database exports — it handles them instantly. If you need to convert huge datasets (100K+ rows), consider using command-line tools like jq or Python's pandas library.

Does it handle special characters in values?

Absolutely. Values containing commas are wrapped in double quotes. Quotes inside values are escaped by doubling them ("). Line breaks within values are preserved and the value is quoted. Empty values become empty cells. This follows RFC 4180 CSV standard ensuring compatibility with Excel, Google Sheets, and all major spreadsheet applications.

What JSON structures are supported?

It supports arrays of objects (most common), single objects, and mixed structures. Each object becomes one row in the CSV. All unique keys across all objects become columns. Missing values become empty cells. Nested objects and arrays are flattened automatically. Primitive arrays ([1,2,3]) become a single row with value column.

Is my data sent to a server?

No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device — we don't have servers to send it to. You can even disconnect from the internet after the page loads and it will still work perfectly. This makes it safe for converting sensitive data like customer lists, financial records, or API credentials.

Can I use this for Excel or Google Sheets?

Yes! The downloaded .csv file opens directly in Excel, Google Sheets, LibreOffice Calc, Apple Numbers, and virtually any spreadsheet application. Just click Download and open the file — no formatting or import wizard needed. You can also copy the CSV text and paste it directly into a spreadsheet cell range.

Does it work on mobile?

Yes, but the experience is better on desktop. On mobile, the input/output panels stack vertically, and you can still preview and download results. The table view adapts to small screens with horizontal scrolling. For best results when working with large datasets, use landscape mode on tablets.

Tools

Delimiter

Input

1

Output

Converted CSV will appear here...

0 lines|0 B

JSON to CSV — Instant Batch Data Export Online

JSON to CSV converter. Convert JSON arrays or objects to CSV format instantly with automatic flattening of nested structures using dot notation. Supports custom delimiters (comma, semicolon, tab), header options, and handles complex nested data including objects and arrays. Download results as .csv files compatible with Excel, Google Sheets, and any spreadsheet application. All processing runs locally in your browser — no server uploads required.

Features

✓Instant JSON to CSV conversion — paste your data and it converts automatically as you type
✓Automatic flattening of nested objects using dot notation (e.g., user.address.city)
✓Support for complex nested structures including objects, arrays, and mixed types
✓Customizable CSV delimiters — comma (,), semicolon (;), or tab (\t) for different regional standards
✓Toggle headers on/off — include column names as the first row or export data only
✓Table preview with syntax highlighting — see your CSV data in a clean spreadsheet-like grid before downloading
✓Download as .csv file — compatible with Excel, Google Sheets, LibreOffice Calc, and any spreadsheet application
✓Drag-and-drop file upload or click to browse — supports .json files up to 10MB
✓Copy to clipboard with one click — paste directly into Excel or Google Sheets without saving
✓Real-time validation with precise error location — highlights the exact line when JSON is invalid
✓Handles edge cases — special characters, commas in values, quotes, and line breaks are properly escaped
✓Entirely client-side — zero data transmission, works offline after initial load, perfect for sensitive data

How to Use

1Paste your JSON data into the left panel. It can be an array of objects, a single object, or any valid JSON structure.
2Watch as nested objects are automatically flattened using dot notation (user.name, user.address.city).
3Choose your preferred delimiter: comma for standard CSV, semicolon for European formats, or tab for TSV files.
4Toggle 'Include Headers' to add or remove the column header row based on your target application's requirements.
5Preview the converted CSV in the right panel as both a formatted table and raw text.
6Click Download to save as a .csv file that opens directly in Excel, Google Sheets, or Numbers.

Frequently Asked Questions

Related Tools

JSON Formatter — Beautify, Validate & Minify JSON Online

JSON formatter, validator, and beautifier. Format, minify, pretty-print, and syntax-highlight JSON data instantly. Features include key sorting, custom indentation (2/4 spaces or tab), line numbers, tree view, error highlighting with line/column position, drag-and-drop file upload, one-click copy/download. All processing runs locally in your browser — no server uploads.

YAML to JSON — Docker, K8s & CI/CD Config Converter

YAML to JSON and JSON to YAML converter. Transform YAML configuration files (Docker Compose, Kubernetes, CI/CD pipelines) to JSON format with real-time validation, syntax error detection, and precise line/column position. Supports YAML 1.2 features including anchors, aliases, merge keys, multi-line strings, and custom tags. Features include bidirectional conversion, customizable indentation (2/4 spaces), line numbers, drag-and-drop file upload (.yaml/.yml), one-click copy/download. All processing runs locally in your browser — no server uploads, perfect for sensitive config files.

Base64 Encode/Decode — Image & String Converter Online

Base64 encoder and decoder. Encode text to Base64 or decode Base64 back to readable text with real-time auto-detection. Supports UTF-8 characters including emojis, Chinese, and other non-Latin scripts. Features include drag-and-drop file upload, one-click copy, and download results as text files. All processing runs locally in your browser — your data never leaves your device.