Home / Tools / JSON to CSV

JSON to CSV Converter

Turn a JSON array from an API or a log into a CSV spreadsheet — columns collected from every row, values properly quoted — in one paste.

Runs 100% in your browser No upload — files never leave your device Free · No sign-up
1Paste your JSON array
2Set your options
3Get your results

See it in action

[{"name":"Ana","age":31},{"name":"Bo","age":28,"city":"Oslo"}] → name,age,city Ana,31, Bo,28,Oslo

Every key becomes a column; missing keys stay honestly blank. Made with this tool.

Limits

Honest limits: Input must be a JSON array of objects; a single object or nested arrays will not convert directly (nested objects are written as JSON text inside their cell). Keys that appear in only some rows become columns with blanks where they are missing — that is faithful, not a bug.

How to use it

1Paste or type your text

Put the text you want to work on into the input box. It stays in this tab — nothing is sent anywhere.

2No settings needed

The columns are the union of every object's keys, in first-seen order. Paste the array, convert, and the CSV is ready to copy or download.

3Run it

Click the run button and the result appears in the output box below, ready to copy or save.

4Copy or download

Copy the result with one click, or download it as a plain text file for later.

About this tool

APIs speak JSON and humans read spreadsheets, so this conversion is a daily bridge: the API response becomes rows a manager can filter, the log export becomes something support can sort. Doing it faithfully matters — every key across every object must become a column, commas and quotes inside values must be escaped the CSV way, and nested values must not silently vanish. This converter follows those rules and runs locally, because the JSON being converted is so often business data that should not tour the internet first.

Everything runs locally in your browser. Your text is processed with JavaScript in this tab only — it is never uploaded, logged or stored, so you can safely use it on drafts, client copy, code snippets and data you would not paste into a stranger's server. There is no sign-up, no daily limit and no paywall counter ticking down: run it as many times as you need, on any device.

Frequently asked questions

Why did some cells come out blank?

Because that row's object did not have that key. CSV is a rectangle — every column exists in every row — so missing keys land as empty cells. If a key is missing from most rows, the data itself is telling you it is optional or comes from a different record type mixed into the array.

How are nested objects and arrays handled?

They are written into their cell as compact JSON text (for example {"a":1}) rather than being dropped or flattened unpredictably. If you need nested fields as their own columns, flatten the JSON first in your pipeline, then convert.

Is this tool free to use?

Yes — free, with no sign-up and no daily limit. Your text is processed in your browser, so there is no server cost and nothing to meter.

Is my text sent to a server?

No. Everything happens with JavaScript inside this browser tab. Your text is never uploaded, logged or stored — paste drafts, client copy or data freely.

How much text can I paste?

Plenty — everyday documents, articles and data files are fine. Extremely large pastes (many megabytes) depend on your device's memory, and the browser may slow down while it works.

Does it work on my phone?

Yes, in any modern mobile browser. For very long texts a bigger screen is more comfortable, but the processing itself works the same everywhere.

Related tools

Want more free tools?

Free tools that all run locally in your browser — no uploads, no fees.

Browse all tools