Skip to content
JSON to CSV

Free online JSON to CSV converter

Convert JSON to CSV in your browser

JSON to CSV is a free, browser-based converter that turns a JSON array or NDJSON into a spreadsheet-ready CSV file. It flattens nested objects and arrays into columns, supports comma, semicolon, tab, and pipe delimiters, and converts up to 20 files at once. There is no signup and no upload — your data is processed entirely in your browser and never leaves your device.

  • 100% free
  • No upload
  • No signup
  • Works offline
  • Excel-ready

Accepts a JSON array, a single object, or NDJSON (one JSON object per line). You can also drop a file anywhere on this panel.

Advanced options

How to convert JSON to CSV

Three steps, entirely in your browser — your JSON never leaves your device.

  1. Paste JSON or add your files

    Paste a JSON array, a single object, or NDJSON into the box, or bring in up to 20 .json files (25 MB each) — drag them onto the panel, browse for them, or copy them in a file manager and press ⌘V / Ctrl+V anywhere on the page. Conversion starts the moment valid JSON is detected.

  2. Shape the columns

    Pick a delimiter (comma, semicolon, tab, or pipe) and decide how nested objects and arrays map to columns — flatten them with dot notation, join them into one cell, or keep them as JSON.

  3. Copy or download the CSV

    Preview the result as a table, then press Copy CSV to put the whole thing on your clipboard, or Download CSV for a UTF-8 file. Converting several files at once? Grab them all as a single ZIP.

Technical specifications

Input formatsJSON array, single JSON object, NDJSON / JSON Lines
Output formatCSV (RFC 4180), UTF-8, optional BOM for Excel
DelimitersComma, semicolon, tab, or pipe
Nested dataFlatten to dot-notation columns, join, or keep as JSON
Batch limitUp to 20 files, 25 MB each — download all as one ZIP
Processing location100% in your browser — no upload, works offline
PriceFree — no signup, no watermark, no row limit

Frequently asked questions

How do I convert JSON to CSV?
Paste your JSON into the box above or drop a .json file onto it. The converter reads the array of objects, turns each object into a row and each key into a column, and shows the CSV instantly. Click Download CSV or Copy CSV to save the result. Everything happens in your browser, so there is nothing to install and no file is uploaded.
Can I paste a file instead of picking one?
Yes — copy a .json, .ndjson, .jsonl, or .txt file in Finder or File Explorer and press ⌘V (Ctrl+V on Windows and Linux) anywhere on this page; the converter picks it up without any click on the upload box. Several files copied together all load in one go, and each joins the top of the queue so the newest conversion is the one you see. Because the clipboard rarely passes a usable file name along, pasted files are listed as pasted-1.json, pasted-2.json, and so on. Anything that is not a JSON or text file — a screenshot, for instance — is quietly ignored, and pasting JSON text itself still works straight into the input box.
Is this JSON to CSV converter free?
Yes. It is completely free with no signup, no watermark, no row cap, and no upload. The tool is funded by unobtrusive ads and runs entirely in your browser.
How is nested JSON converted to CSV columns?
Nested objects are flattened using dot notation, so {"address": {"city": "London"}} becomes a column named address.city. You can switch nested objects and arrays to a single JSON cell instead if you would rather keep the structure intact in one column.
How are JSON arrays handled?
You choose. Arrays can expand into indexed columns (tags.0, tags.1), join into one cell with a separator you set (for example "tag1; tag2"), or stay as raw JSON in a single cell. Pick whichever fits how you plan to use the spreadsheet.
Can I open the CSV in Excel or Google Sheets?
Yes. Keep the UTF-8 BOM option on so Excel reads accented characters correctly, and pick the semicolon delimiter if your regional Excel settings expect it. The output follows the RFC 4180 CSV standard, so Google Sheets, Numbers, and every database import tool read it without changes.
Does it support NDJSON or JSON Lines?
Yes. If the input is one JSON object per line (NDJSON / JSON Lines, common in log and export files), the converter detects it automatically and treats each line as a row — no need to wrap the lines in an array first.
My JSON wraps the records in a key like “data”. Will that work?
Yes. When the array of records sits under a top-level key such as {"data": […]} or {"results": […]}, the tool auto-detects the largest record array and offers a "Rows come from" selector so you can point it at the right key.
Is my data private?
Yes. The conversion runs locally with JavaScript in your own browser tab. Your JSON is never sent to a server, logged, or stored, and the tool keeps working offline once the page has loaded.
How large a file can it handle?
Each file can be up to 25 MB and you can convert up to 20 files at once. Because the work happens on your device, the practical limit is your available memory rather than an upload quota — most multi-megabyte JSON exports convert in well under a second.

About this tool

JSON to CSV is a free converter for developers, analysts, and anyone who needs to move data out of an API response or export and into a spreadsheet or database. Paste JSON, get CSV — without writing a script, installing a package, or handing your data to a server.

The tricky part of JSON-to-CSV is that JSON is a tree and CSV is a flat grid. This tool walks every record, collects the full set of keys as columns, and gives you control over how nested structures collapse: dot-notation columns for objects (user.address.city), indexed columns or a joined cell for arrays, and a JSON fallback when you want to keep a branch intact. Output is quoted per the RFC 4180 standard, so commas, quotes, and newlines inside values never break the columns. If you want the reasoning behind those choices, the guide on converting nested JSON to CSV walks through each strategy and when to use it.

Because everything runs client-side, nothing is uploaded and nothing is stored. You can convert sensitive exports, disconnect from the network, and keep working — the page is fully functional offline once it has loaded.

Opening the result in Microsoft Excel? The JSON to Excel converter is the same tool pre-configured for Excel — UTF-8 BOM, Windows line endings, and formula-safe cells out of the box. Going the other way, the CSV to JSON converter turns a spreadsheet export back into an array of objects or NDJSON, rebuilding nested objects from the same dot-notation column names.

Your data never leaves your browser

Conversion runs locally in JavaScript using your browser's own JSON parser. We do not upload, store, or analyse your data — no records, keys, or values are sent anywhere. The tool keeps working even if you disconnect from the internet after the page loads.