Data

JSON to CSV

Details

How to use JSON to CSV

What the tool does, how to run it, and what to expect from the result.

How to convert JSON to CSV

To convert JSON to CSV, paste your JSON into the input. The tool reads the keys to build a header row, then writes one CSV row per object, producing a table you can open in a spreadsheet or import elsewhere.

Conversion happens locally in your browser, so your JSON never leaves your device. Once converted, copy the CSV or download it as a file, handy for getting API data, exports, or config records into a spreadsheet quickly.

  • Paste a flat object or array of flat objects
  • The tool derives the CSV header from the keys
  • Each object becomes one CSV row
  • Copy or download the CSV result

What JSON structures are supported

This converter supports flat JSON: a single object, or an array of objects where each value is a simple scalar like a string, number, or boolean. That covers most tabular data people actually need to move into a spreadsheet.

Nested arrays and nested objects are not flattened in this version. Flattening nested structures requires opinionated choices about how to name and split columns, so the tool clearly rejects nested input rather than producing confusing output. Flatten your JSON first if you need nested data in CSV.

Tips

Getting a better result out of JSON to CSV

Specific settings and thresholds, not general advice.

  • Flat rows only. One object, or an array of objects whose values are all strings, numbers, booleans or null. A nested object or array is rejected with a message naming the field that caused it.
  • The header row is the union of every key across every row, so a row missing a key is not an error: the cell is left empty.
  • Null becomes an empty cell, which is indistinguishable from a missing value in CSV. If the difference matters to your consumer, replace nulls with a sentinel before converting.
  • Any value containing a quote, a comma, a newline, a semicolon, a tab or a pipe is wrapped in quotes on the way out, with internal quotes doubled, which is the standard CSV escaping rule.
  • The output is always comma-separated, regardless of what you might have wanted. Excel in a European locale may read a comma CSV as a single column, in which case open it via the import dialog rather than double-clicking the file.
Limits

What JSON to CSV does not do

The honest boundary, so you do not lose time finding it yourself.

  • No nested structures. Objects and arrays inside a row are rejected rather than flattened.
  • Comma output only. There is no semicolon, tab or pipe option.
  • No type formatting: numbers, booleans and dates are written exactly as they serialize.
  • No control over column order, which follows the order the keys were first seen.
Reference

Terms used on this page

Short, plain-language definitions for the formats and settings above.

At a glance

Who JSON to CSV is for

A quick way to understand who this helps, what it solves, and where it connects next.

Best fit

Operators, analysts, marketers, and developers moving flat data between lightweight tools.

Ideal for

Quick conversions from flat JSON rows into CSV when you do not need spreadsheet-heavy tooling.

FAQ

Common questions

Short answers for the questions people usually have before trying a utility like this.

Is the JSON to CSV converter free?

Yes. This JSON to CSV tool is completely free to use with no signup or account required.

Does it upload my JSON?

No. The conversion runs entirely in your browser on your own device, so your JSON is never uploaded to a server and stays private.

Does it support nested arrays or objects?

No. This version supports flat rows only and clearly rejects nested structures, since flattening requires opinionated column choices.

Can I open the result in Excel or Google Sheets?

Yes. The output is standard CSV with a header row, so it opens directly in Excel, Google Sheets, or any spreadsheet app.

Can I download the CSV right away?

Yes. The converted CSV is ready to copy or download as soon as the conversion runs.

Why does it reject my nested JSON?

Because there is no correct way to flatten it that everyone agrees on. Should a nested object become dotted column names, or JSON-in-a-cell, or exploded into multiple rows? Every answer is right for some case and wrong for others. Rather than guessing on your behalf, the tool refuses and names the field, so you can flatten it the way your destination expects.

What happens when rows have different keys?

The header is the union of all keys across all rows, in the order they were first encountered. A row that does not have one of those keys gets an empty cell for it. That means a ragged array of objects converts without error, and the gaps are visible in the output.

How are commas inside values handled?

The cell is wrapped in double quotes, and any double quote already inside the value is doubled. This is the standard CSV escaping rule and it is what every spreadsheet and CSV parser expects, so a value containing a comma, a newline or a quote survives the round trip.

Why does Excel open my CSV as one column?

Because your Excel is running in a locale that expects the semicolon as the list separator, and this tool always emits commas. The fix is on the Excel side: use Data then From Text/CSV and set the delimiter explicitly, rather than double-clicking the file and letting the locale decide.

How are nulls and booleans written?

A null becomes an empty cell. A boolean becomes the literal text true or false. Neither is quoted unless it needs escaping. If your consumer distinguishes an empty string from a null, CSV cannot carry that distinction, and you will need to substitute a sentinel value before converting.

Is my JSON uploaded?

No. It is parsed and converted in the page, so a payload with real customer data in it never leaves the tab.

Recommendations

You Might Also Like

Nearby tools from the catalog that fit the same job or workflow.

Cleanor app

Do it all on your device

Cleanor puts these tools in one app: compress and convert images, video, and audio, work with PDFs, and scan text right on your device. Plus free up storage and clear inbox clutter with Email Cleaner. Start with a free trial.

  • iPhone
  • Android
  • Macsoon
  • Windowssoon