How to Convert JSON to CSV

JSON is great for code and APIs, but CSV is the language spreadsheets speak. You'll reach for this conversion whenever you want to open structured data in Excel, Google Sheets, or Numbers — to filter it, chart it, or share it with someone non-technical.

Common cases: turning an API response into a report, exporting records from a tool that only gives you JSON, prepping a list for a bulk upload that expects CSV, or simply eyeballing nested data in a flat grid. Because the converter also goes the other way, it's just as handy for pulling a CSV export back into JSON for a script.

Give the tool a JSON array of objects, like [{...}, {...}], not a single object or a bare value. Each object is one row.

Your objects don't all need identical keys. The converter collects every key it sees across all rows and uses that union as the header, so missing fields simply come out as empty cells. Values that are themselves arrays or objects are written back as JSON text inside the cell, so nothing is silently dropped.

Don't worry about commas, quotation marks, or line breaks inside your values — the tool wraps and escapes those fields automatically following RFC 4180, so your CSV opens correctly in any spreadsheet. For the reverse direction, make sure your CSV's first row is the header, since those names become the JSON keys.

Yes. The conversion runs entirely in your browser using local JavaScript — your JSON or CSV is never uploaded to a server, and nothing is logged or stored. The on-page hint says it plainly: everything runs privately in your browser, nothing is uploaded.

That makes it safe for data you can't paste into random websites, like customer records, internal exports, or anything with personal information. There's no account to create and no usage cap, so you can convert as much as you want, as often as you want. Once the page has loaded, it even keeps working if your connection drops.

'Invalid JSON' — there's a syntax slip somewhere. The usual culprits are a trailing comma after the last item, a missing bracket or brace, or single quotes where JSON needs double quotes. Paste the JSON into a formatter first if you're unsure.

'JSON must be an array of objects' or 'Every item in the array must be an object' — you've pasted a single object or a list of plain values. Wrap your objects in square brackets so the top level is an array, e.g. [{ "a": 1 }].

Empty result — an empty array ([]) produces no CSV, which is expected. Add at least one object to see output.

Going CSV to JSON and getting odd keys? Check that the very first line of your CSV holds the column names, because that row is treated as the header.