JSON to CSV

JSON to CSV takes a JSON array of objects (or a single object) that you paste in and turns it into comma-separated rows. It scans every object for its keys, uses the combined set as the header row, and fills missing values with blanks so the columns line up. The conversion runs entirely in your browser using the built-in JSON parser, and values that contain commas, quotes, or line breaks are automatically wrapped in quotes so the CSV stays valid.

Upload JSON file

Click or drag & drop · .json, .txt

JSON Input

How was this tool?

Your feedback helps us improve JSON to CSV.

Why use JSON to CSV?

This JSON to CSV converter is built for the common case of turning a list of records into a flat table. You paste JSON into the JSON Input box and click Convert to CSV. Under the hood it parses the text, wraps a single object in an array if needed, then walks every object to gather the full set of keys. That combined key set becomes the header row, which means records that don't all carry the same fields still slot into consistent columns, with blanks where a value is absent. The output appears immediately in a CSV Output area beneath the button. Because the whole operation uses the browser's own JSON parser and a small conversion routine, there is no network round-trip for the core task. Values are made CSV-safe as they are written: anything holding a comma, a double quote, or a line break is enclosed in double quotes with inner quotes doubled, and empty or null values are rendered as blank cells. One thing worth knowing is that values are converted to plain text, so a nested object or array inside a field is stringified rather than expanded into its own columns. The tool is aimed at flat, tabular JSON. When you are happy with the result, Copy CSV places the text on your clipboard and Download .csv saves it as a file named data.csv, ready to open in a spreadsheet. The Clear button wipes both the input and output so you can convert a fresh batch. If the input can't be parsed, an Invalid JSON message appears with the parser's reason, so you can fix a stray comma or missing bracket and try again. There is no signup and no file size dialog to work through; it is a paste-convert-copy loop.

Key benefits

Runs completely in your browser using the native JSON parser, so the JSON you paste is never sent to a server
Merges the keys from every object into a single header row, so records with different fields still align into the same columns
Escapes any value containing a comma, double quote, or newline by quoting it and doubling inner quotes, keeping the CSV valid for spreadsheets
Fills in blank cells for missing keys instead of shifting columns, so rows stay consistent
Gives you both a Copy CSV button and a Download .csv button that saves the output as data.csv

Features

Accepts either a JSON array of objects or a single JSON object (the object is treated as one row)
Header row is the union of all keys across every object, in first-seen order
RFC-style value escaping: commas, quotes, and newlines trigger double-quote wrapping
null and undefined values are written as empty cells
Inline Invalid JSON error that shows the parser message when input cannot be read
One-click Copy CSV to clipboard and Download .csv (saved as data.csv)

Popular use cases

Turning an API response, saved as a JSON array, into a CSV you can open in a spreadsheet
Flattening a mix of records that don't all share the same fields into one aligned table
Quickly extracting a JSON export into columns for a report, filter, or pivot
Converting a single JSON config or record object into a two-row CSV header plus values

How to use JSON to CSV

1
Paste your JSON
Drop a JSON array like [{"name":"Alice","age":30}] or a single JSON object into the JSON Input box. The placeholder shows the expected shape.
2
Click Convert to CSV
Press the Convert to CSV button. The tool reads every object, builds one header row from all the keys it finds, and prints the rows below in the CSV Output area. If the JSON is malformed, an Invalid JSON message tells you what went wrong.
3
Copy or download the result
Use Copy CSV to put the text on your clipboard, or click Download .csv to save it as data.csv. Hit Clear to empty both boxes and start over.
4
Or upload a JSON file
Instead of pasting, use the upload area above the JSON Input box to drop or select a .json or .txt file. The file's contents load into the box and convert to CSV automatically.

Frequently asked questions

Does my JSON get uploaded anywhere?

No. The conversion happens locally in your browser with JavaScript's built-in JSON parser. Nothing you paste or upload is sent to a server.

What JSON shape does it expect?

An array of objects works best, for example [{"name":"Alice"},{"name":"Bob"}]. A single object is also accepted and becomes one data row. The keys of the objects become the CSV column headers.

What happens if my objects have different keys?

The tool collects every key it sees across all objects and uses that combined set as the header. Any object missing one of those keys gets an empty cell in that column, so the rows stay aligned.

How are commas and quotes inside values handled?

If a value contains a comma, a double quote, or a newline, the tool wraps it in double quotes and doubles any inner quotes. This keeps the field from breaking the CSV structure.

Can I convert a file instead of pasting?

Yes. Use the file upload area above the JSON Input box to drop or select a .json or .txt file, and its contents load into the box and convert automatically. There is no multi-file batch mode; files are processed one at a time.

Why did I get an Invalid JSON error?

The text you pasted or uploaded could not be parsed as JSON. Check for trailing commas, single quotes instead of double quotes, or unclosed brackets. The message after Invalid JSON is the parser's own explanation of the problem.

Last reviewed: July 2026

How was this tool?

Related tools