JSON to CSV
Convert JSON into CSV.
Convert JSON into CSV.
How to use JSON to CSV
- Paste a JSON array of objects into the input
- Let it build CSV columns from every object's keys
- Copy or download the spreadsheet-ready .csv file
About JSON to CSV
Paste a JSON array of objects and this tool turns it into clean, spreadsheet-ready CSV in one click. Whether you call it converting, transforming, changing, or exporting JSON to CSV, the behavior is the same: each object becomes a row, and the header row is built from the union of every key that appears across your objects, in the order they first show up. Objects that are missing a key simply leave that cell blank, so partial or mismatched records still line up in the right columns.
Values are escaped to the RFC 4180 standard, so any field containing a comma, double quote, or line break is wrapped in quotes and its inner quotes are doubled. That keeps the CSV importing cleanly into Excel, Google Sheets, and most databases without cells splitting or shifting. Nested objects and arrays are written as their JSON string inside the cell, null and missing values become empty cells, and numbers and booleans are written as plain text. A live row and column count updates as you paste, so you can sanity-check the shape before you export. When it looks right, use Copy to grab the CSV or Download .csv to save a file.
It's a JSON-to-CSV converter, so it moves in that one direction; for the opposite job you'd reach for a separate CSV to JSON tool. Everything runs in your browser with plain JavaScript — no sign-up, no watermarks, and no limits — and your JSON is never uploaded to a server, which keeps it safe for private or sensitive data.
Frequently asked questions
- How do I convert JSON to CSV?
- Paste your JSON array of objects into the box and the CSV appears instantly below. Then click Copy to put it on your clipboard or Download .csv to save a file. There are no steps to configure and nothing to upload.
- Is this JSON to CSV converter free?
- Yes, it's 100% free with no sign-up, no watermarks, and no usage limits. You can convert as many files as you want.
- Is my data uploaded to a server?
- No. All conversion happens locally in your browser using JavaScript. Your JSON never leaves your device and nothing is sent to any server, which makes it safe for sensitive or private data.
- What JSON format does it expect?
- Paste a JSON array of objects, for example [{"name":"Ada","age":30}, {"name":"Grace","age":40}]. A single object also works and becomes a one-row CSV. Each object becomes a row and each unique key becomes a column.
- How does it handle commas, quotes, and line breaks in values?
- It follows the standard CSV rules (RFC 4180): any value containing a comma, double quote, or newline is wrapped in double quotes, and internal double quotes are doubled. This keeps your data intact and importable into Excel, Google Sheets, and databases.
- What happens if my objects have different keys?
- The header row is the union of all keys across every object, in the order they first appear. If an object is missing a key, that cell is left empty, so mismatched or partial records still convert cleanly.
- How are nested objects and null values handled?
- Nested objects and arrays are converted to their JSON string representation inside the cell, and null or missing values become empty cells. Numbers and booleans are written as plain text.
- Will the CSV open correctly in Excel or Google Sheets?
- Yes. Because every value is escaped to the RFC 4180 standard, fields that contain commas, quotes, or line breaks stay inside a single cell when you open or import the file into Excel, Google Sheets, or Numbers. Nothing shifts into the wrong column.
- Can this convert CSV to JSON instead?
- This tool works in one direction: JSON to CSV. To go the other way and turn a CSV or spreadsheet back into JSON, you'd use a dedicated CSV to JSON converter rather than this page.
- Is there a limit on how large my JSON can be?
- There's no hard size cap. Since the conversion runs entirely in your browser, the only real limit is your device's available memory. Large arrays still convert in seconds because nothing is uploaded or queued on a server.
- Do I need to install anything or create an account?
- No. There's nothing to install and no account to create. It's a single web page that runs in your browser, so you can paste your JSON and convert it straight away.