JSON Array to CSV Converter
Turn a JSON array of objects into CSV with configurable delimiters, dot-notation flattening, and download support in your browser.
Convert a JSON array of objects to CSV
APIs and log exporters often return a JSON array of homogeneous objects. This converter turns that array into spreadsheet-ready CSV with optional dot-notation flattening for nested fields, configurable delimiters (comma, semicolon, tab, or pipe), and row counts before you download. Processing is local; your JSON never leaves the tab.
How to use this tool
- Paste a JSON array such as
[{"id":1,"name":"Ada"}]. - Choose flatten or explode mode for nested arrays.
- Pick a delimiter suited to Excel or Google Sheets regional settings.
- Copy or download the CSV output.
Related tools: CSV to JSON, JSON to CSV Flat Nested, and NDJSON to CSV.
Frequently Asked Questions
What is the difference between flatten and explode?
Flatten keeps nested objects as dotted column names and stores arrays as JSON strings. Explode duplicates rows so each array element gets its own line where possible.
Why use semicolon delimiters?
European Excel locales expect semicolon-separated files. Matching the delimiter to your spreadsheet locale prevents columns from merging into one cell.
Does the tool accept a single JSON object?
No. The input must be an array. Wrap a lone object as a one-element array if needed.
Related Tools
Sort Digits
Concrete Driveway Cost Calculator
Prime Checker
Reading Speed Calculator
Periodic Compound Interest Calculator
Password Entropy Calculator
Among Us Impostor Odds Calculator
Twitch Name Generator
Angle of Refraction Calculator
Connect the Dots Generator
INI to Base64 Converter
Convert Binary To Ascii
Mars Sign Calculator
Increment Calendar Date
Sperm Analysis Calculator
Bathroom Mirror Size
Plant Spacing Calculator
Jpeg To Bitmap Converter
Add and Subtract Polynomials Calculator
Lightning Distance Calculator