Input JSON

Loading editor…

CSV

Output initialises when this pane is visible.

What is a JSON to CSV converter?

Turn JSON arrays of objects into spreadsheet-ready CSV.

A JSON to CSV converter flattens structured JSON — usually an array of objects — into comma-separated values you can open in Excel, Google Sheets, or data tools. Each object becomes a row; keys become column headers.

Nested values are safely encoded inside cells, and special characters (commas, quotes, newlines) are quoted per RFC 4180. This is useful when analysts need tabular exports from API payloads or when you want a quick look at record counts and field coverage.

Conversion runs entirely in your browser. Paste production data without uploading it to a third-party service.

How to use

Everything you need to know, one click away.

Quick start get going in seconds
  1. Paste or import JSON in the left pane — the status bar tells you instantly if it's valid.
  2. Click Convert — CSV output appears on the right in real time.
  3. Copy or Download the result from the output toolbar.
CSV output what gets generated
  • Array of objects → a table with a header row and one data row per object.
  • Nested values are safely JSON-encoded inside their cell.
  • Special characters (commas, quotes, newlines) are properly quoted per RFC 4180.
  • Single object or scalar is normalised into a single-row table.
Tips & troubleshooting common questions
  • If JSON is invalid, conversion pauses — the status bar shows exactly what's wrong.
  • Use the search box to find keys or values in large JSON documents.
  • Load JSON from any CORS-enabled URL using From URL in the input toolbar.
  • Everything runs locally — nothing is ever uploaded.

Features

Everything this converter can do — all processed locally in your browser.

Live CSV preview

The CSV output updates as you type. Paste your JSON and the spreadsheet-ready result is instantly visible on the right — no button clicking needed.

RFC 4180 compliant output

Generated CSV follows the RFC 4180 standard. Special characters are properly escaped, nested values are JSON-encoded, and every edge case is handled correctly.

Import from file or URL

Open a .json file from your computer, drag and drop it onto the editor, or fetch JSON directly from any CORS-enabled URL.

Copy or download

Copy the CSV output to your clipboard in one click, or download it as a .csv file — ready to open in Excel, Google Sheets, or any data tool.

100% private, works offline

All conversion happens entirely in your browser. Your JSON never leaves your device, and once loaded the tool works without any network connection.

FAQ

Common questions about the JSON to CSV converter.

Is my JSON data safe?

Yes, completely. Conversion runs entirely inside your browser using JavaScript. Your data is never sent to any server and never stored anywhere outside your own device. You can even disconnect from the internet after the page loads and it will still work.

What JSON structure works best for CSV?

An array of objects with consistent keys produces the cleanest output — each object becomes one row and the keys become column headers. A single object is converted to a one-row table. Scalar roots (a plain string or number) produce a single-cell CSV.

What happens to nested objects and arrays?

Nested values that can't be represented as a flat cell are JSON-encoded and placed inside the cell as a string. This keeps the CSV valid and machine-readable while preserving all the original data.

Does it work offline?

Yes. Once the page has loaded and its assets are cached, all features work without a network connection. The only time the network is used is to load the editor on first visit, and optionally when you use "Load from URL".

Can I open the downloaded CSV in Excel or Google Sheets?

Yes. The output follows RFC 4180 which is understood by Excel, Google Sheets, LibreOffice Calc, and virtually every other spreadsheet tool. Just download the .csv file and open it directly.

Other tools

Load JSON from URL

The URL must allow CORS. Plain JSON only.

Paste JSON

Clipboard access denied. Paste your JSON below.