JSON to CSV Converter
Convert a JSON array into a CSV you can open in Excel or Google Sheets, with headers taken from every key that appears.
A JSON to CSV converter flattens an array of objects into spreadsheet rows, using the union of every key as the header row. Values containing commas, quotes or newlines are escaped so the file opens cleanly in Excel and Google Sheets.
Runs entirely in your browser · no signup · nothing is uploaded · updated 2026-09-02
How to use it
- 1.Paste a JSON array of objects.
- 2.Pick the delimiter your spreadsheet expects.
- 3.Copy the CSV, or paste it straight into a sheet.
Frequently asked questions
What JSON shape does this expect?
An array of flat objects, which is what almost every API returns for a list. A single object is treated as a one-row table.
What happens to nested objects and arrays?
They are stringified into one cell. CSV has no way to express nesting, so flatten the data before converting if you need the inner values in their own columns.
Why do some rows have empty cells?
The header row is the union of every key across all objects. Any object missing a key gets an empty cell there, which is the correct flat representation.
How do I open the CSV in Excel without mangling it?
Use Data then From Text/CSV rather than double-clicking, and set the encoding to UTF-8. Double-clicking often guesses the delimiter and encoding wrongly.
Are quotes and commas escaped properly?
Yes. Any value containing a comma, quote or newline is wrapped in double quotes with internal quotes doubled, per RFC 4180.
Should I use a comma or a semicolon?
Comma for anything programmatic. Semicolon if the file will be opened in a spreadsheet set to a locale that uses a comma as the decimal separator.
Is my JSON sent to a server?
No. Parsing and conversion happen in your browser with no network request.
How do I do this in a script?
In Python, pandas.read_json then to_csv is one line each. In Node, the json2csv package or a short reduce over Object.keys does the same.
The guide behind this tool
3 min readCSV to JSON: converting without corrupting data
Why CSV parsing is harder than splitting on commas, what nesting does to a conversion, and the type coercion that quietly destroys zip codes and IDs.
3 min readWhy your JSON won't parse, and how to find the character
The five things that make JSON invalid, how to read a parser error into a line and column, and what JSON does not allow that every other format does.
Tools that pair with this one
DeveloperRegex Tester
Test a JavaScript regular expression against sample text, see every match with its position and capture groups, and get real errors for invalid patterns.
DeveloperBase64 Encode / Decode
Encode text to base64 or decode it back, with full UTF-8 support and automatic handling of base64url input. Runs entirely in your browser.
DeveloperWildcard Mask Calculator
Convert a CIDR prefix or subnet into the wildcard mask Cisco ACLs and OSPF network statements expect, with the subnet mask and address range alongside it.
DeveloperDiff Checker
Paste two versions of a text and see every added and removed line highlighted, computed in your browser with no upload.
Built something?
RankCert is a weekly launch board where products rank on domain control we verify ourselves - not upvotes. Listing is free and the link is dofollow whether or not you display our badge.