JSON to CSV Converter
Paste any JSON array of objects to generate clean CSV text ready to open in Microsoft Excel, Google Sheets, or database pipelines.
Step-by-Step Instructions
Paste or Upload JSON
Paste a JSON Array of Objects (`[{}, {}]`) into the editor or upload a .json file.
Configure Flattening & Delimiters
Choose delimiter (Comma, Semicolon, Tab) and choose how to handle nested objects (dot notation e.g., `user.address.city` or stringified JSON).
Set Quoting Rules
Choose automatic quoting (quotes only when cells contain delimiters/newlines) or force quotes on all text fields.
Copy or Download CSV File
Instantly preview formatted tabular data and download as an Excel-compatible .csv file.
Key Features & Capabilities
- Automatic flattening of nested JSON objects into dot notation columns (`address.street`, `address.zip`)
- Handling of array fields (converted to comma-joined strings or individual indexed columns)
- RFC 4180 compliant CSV generator with automatic quote escaping (`""`) for special characters
- UTF-8 BOM (Byte Order Mark) injection ensuring seamless compatibility with Microsoft Excel
Frequently Asked Questions
How does the JSON to CSV converter handle nested JSON objects and arrays?
Nested objects are automatically flattened using dot notation: an object `{"user": {"name": "Alice", "city": "Boston"}}` generates CSV column headers `user.name` and `user.city`. Array values are converted into semicolon-separated or comma-separated lists within a single quoted CSV cell.
Why does Microsoft Excel sometimes scramble UTF-8 CSV characters, and how is it fixed?
When opening CSV files, Microsoft Excel defaults to legacy ANSI encoding unless a **UTF-8 Byte Order Mark (BOM: `0xEF, 0xBB, 0xBF`)** is present at the beginning of the file. Our exporter automatically injects the UTF-8 BOM, ensuring international characters, accents, and symbols open correctly in Excel.
What happens if JSON objects have inconsistent or missing keys across rows?
Our parser scans all JSON objects in the array to construct a unified master header list. If a specific row is missing a key that exists in other rows, the converter outputs an empty cell (`,,`), maintaining column alignment across all records.
What is the maximum JSON file size that can be converted to CSV?
Because processing runs client-side using streaming memory buffers, the converter can effortlessly handle JSON files containing tens of thousands of records (up to 50MB+) directly in your browser without data leaving your computer.
Related Utilities
Discover complementary online tools in the same workflow.
CSV to JSON Converter
Easily convert CSV data to clean JSON format. Turn tabular spreadsheets into structured JSON.
JSON Formatter & Validator
Format, beautify, minify, validate, and view JSON data online with instant syntax highlighting and error detection.
Base64 Encoder & Decoder
Encode text or binary data into Base64 format or decode Base64 back into raw string format.
YAML to JSON Converter
Convert YAML configuration files into structured JSON for APIs and modern web tooling.
JWT Parser & Token Debugger
Decode JWT tokens to view header, payload claims, and expiration status without sending secrets anywhere.
Hash Generator (SHA-256, SHA-512, MD5)
Generate cryptographically secure SHA-256, SHA-512, SHA-384, and SHA-1 hashes for any text.