Free JSON to CSV Converter — Convert JSON Online

Paste your JSON and get a clean CSV instantly. Handles nested objects, custom delimiters, and live preview — perfect for developers and analysts.

Free JSON to CSV Converter — Convert JSON Online

Home › Developer Tools › JSON to CSV Converter

Turn JSON Into Spreadsheet-Ready CSV

Paste JSON or upload a file — get clean CSV with nested objects flattened, ready for Excel or Google Sheets.

Invalid JSON

0 rows 0 columns

100% private

Conversion happens in your browser. Your data is never uploaded to any server.

No signup

Paste, convert, download — no accounts, no waiting, no watermarks.

Free forever

Convert as many files as you need. No row limits, no paywalls.

How to use the JSON to CSV converter

  1. 1
    Paste or upload your JSON

    Paste an array of objects (or a single object) into the box, or upload a .json file straight from your computer.

  2. 2
    Pick a delimiter

    Comma is the default. Choose semicolon if your Excel uses European number formats, or tab/pipe for other tools.

  3. 3
    Preview and download

    Hit “Convert to CSV” to see a live preview table with flattened columns, then download the file or copy it to your clipboard.

Features

Flattens nested objects

Nested keys like address.city become their own CSV columns automatically, so hierarchical API responses turn into flat, spreadsheet-friendly tables.

Custom delimiters

Export with comma, semicolon, tab, or pipe. The semicolon option is a lifesaver for European Excel, where commas inside numbers would break imports.

File upload

Working with a big export? Upload the .json file directly instead of pasting — the file is read locally and never leaves your machine.

Live preview table

See the first rows and every column header before you download, so you can spot problems with the data before it reaches your spreadsheet.

One-click download and copy

Save the result as a .csv file or copy it straight to your clipboard for pasting into Google Sheets, Excel, or a database import.

Clear error messages

On invalid JSON you get the exact line and column of the problem, plus a snippet with a marker — not just “parse error”.

Frequently asked questions

How are nested objects handled?
Nested objects are flattened with dot notation: {“address”: {“city”: “Austin”}} becomes a column named “address.city”. This keeps every value in its own column so nothing is lost when you open the CSV in Excel.
What happens to arrays inside the JSON?
Arrays of simple values (like [“red”, “blue”]) are joined into one cell with “; ” between items. Arrays of objects are stored as compact JSON text in a single cell, since a CSV cell cannot hold a table inside a table.
Which delimiter should I choose?
Use comma for US Excel and Google Sheets. Use semicolon if your Windows region uses commas as decimal separators (common in Europe) — otherwise Excel will split your numbers into extra columns. Tab and pipe are useful for database imports and log-style data.
My JSON is invalid — how do I fix it?
The error box shows the exact line and column where parsing failed, plus a snippet with a caret marker. The most common problems are trailing commas after the last item, single quotes instead of double quotes, and unquoted keys. Paste your JSON into the JSON Formatter & Validator tool for a full diagnosis.
Can I convert a single JSON object, not an array?
Yes. A single object like {“name”: “Ava”} is treated as one row with each key as a column. An array of objects becomes one row per object, which is the usual case for API exports.
How are quotes and commas inside values handled?
Any value containing the delimiter, a quote, or a line break is wrapped in double quotes, and internal quotes are doubled — exactly as the CSV standard (RFC 4180) requires. Excel and Google Sheets will open these files correctly.
Is my data uploaded anywhere?
No. Parsing, flattening, and CSV generation all run in JavaScript in your browser. Your API keys, customer records, or export data never touch our servers.
Scroll to Top