Convert JSON to CSV — Arrays, Nested Objects, Any Shape
Paste a JSON array or upload a .json file and get a clean, spreadsheet-ready CSV in one click. Choose your delimiter and flatten nested keys.
5 of 5 free uses left
Click the button below to convert.
Convert JSON to CSV — Arrays, Nested Objects, Any Shape
Working with API responses, MongoDB exports or analytics payloads almost always means dealing with JSON. But the moment you want to open that data in Excel, Google Sheets, Numbers or hand it to a non-technical colleague, you need CSV. Our JSON to CSV converter turns any well-formed JSON array (or single object) into a clean, RFC 4180-compliant CSV file in your browser.
The converter handles the tricky parts for you. **Nested objects** like `{"address": {"city": "Paris"}}` can be flattened into dot-notation columns (`address.city`) so every leaf value becomes its own column. **Arrays of primitives** like `["admin", "beta"]` are joined with semicolons so they stay in a single cell. **Special characters** — commas inside values, double quotes, line breaks — are properly escaped with quoting and doubled quotes, exactly as Excel and every spreadsheet tool expect.
You can choose your delimiter (comma, semicolon, tab or pipe), toggle the header row on or off, and decide whether to flatten nested objects or keep them as JSON strings inside cells. Loading data is flexible too: paste JSON directly, upload a `.json` file from your computer, or fetch from a URL — handy for pulling straight from a public API.
Everything runs locally in your browser. Your JSON is parsed, transformed and serialized on your device — nothing is uploaded, logged or stored. That makes the tool safe for sensitive payloads like customer exports, internal API responses or anything containing tokens or PII.
How It Works
Paste or Upload JSON
Paste a JSON array, upload a .json file, or fetch from a URL.
Pick Your Options
Choose delimiter (comma/tab/etc), include headers and flatten nested objects.
Copy or Download
Get the CSV instantly. Copy to clipboard or download as data.csv.
Why Use Our Tool?
Flatten Nested Objects
Turn deep JSON like {address:{city}} into dot-notation columns (address.city) automatically.
Multiple Delimiters
Comma, semicolon, tab or pipe — pick what your spreadsheet locale needs.
RFC 4180 Escaping
Commas, quotes and newlines inside values are escaped correctly so the CSV opens cleanly in Excel.
URL Fetch Support
Paste any public JSON URL and the tool fetches the payload for you (CORS permitting).
Header Row Toggle
Include or omit the header row depending on what your downstream tool expects.
100% Local Processing
Parsing and conversion happen in your browser. Your JSON never leaves your device.