Free · Instant · Runs in your browser
Paste your JSON, get an instant preview table, and download a ready-to-use CSV — handles nested objects, arrays, and mismatched fields automatically.
A JSON to CSV converter takes structured JSON data — an array of records, an API response, an exported database table — and rewrites it as a comma-separated values (CSV) file, the flat, row-and-column format that Excel, Google Sheets, and virtually every data-analysis tool understands natively. JSON is great for applications talking to each other; CSV is what people actually open to read, sort, filter, and chart.
This converter runs entirely in your browser. Nothing you paste or upload is ever sent to a server, logged, or stored — safe to use even with private API responses or proprietary data exports.
Paste your JSON — either a single object or an array of objects — into the box above and press Convert to CSV. The tool collects every unique field name across all your objects to build the column headers, writes one row per object, and shows you a live preview table before you download the finished file.
Yes — a CSV file opens directly in Excel, Google Sheets, Numbers, and every major spreadsheet program, which is exactly why converting JSON to CSV is the standard path from an API or JSON export into a spreadsheet. Download the CSV from this page, then double-click it or drag it into an already-open spreadsheet.
CSV is a flat, two-dimensional grid, so nested JSON objects need to be flattened first. This tool converts nested keys into dot notation columns automatically.
Arrays of simple values (like a list of tags) are joined into one cell with a semicolon separator. Arrays of objects — which are really sub-tables — are kept as a compact JSON string in their cell, since a single spreadsheet cell can't represent a nested table.
This is common with real-world data — some records have an optional field, others don't. This converter collects the union of every field found across all your objects and uses that as the complete column list. Any record missing a particular field just gets an empty cell there, so nothing breaks and no data is silently dropped.
Paste an array of JSON objects into a converter, and it collects every unique key across all objects to form the CSV column headers, then writes one row per object with each value placed under its matching column. Paste your JSON into the box above, press Convert, and download the resulting CSV file directly.
Yes. A CSV file opens directly in Excel, Google Sheets, and Numbers, so converting JSON to CSV is the standard way to get JSON data into a spreadsheet. Just download the CSV and open it with your spreadsheet program of choice, or drag it directly into an already-open spreadsheet.
Since CSV is a flat, two-dimensional format, nested JSON objects are flattened into dot-notation columns — for example, a nested city field under an address object becomes a column named address.city. Arrays of simple values are joined with a separator into a single cell, and arrays of objects are preserved as a JSON string, since a single cell can't represent a full sub-table.
The converter collects the union of every field found across all objects, using it as the full set of CSV columns. Any object missing a particular field simply gets an empty cell in that column, so no data is lost and the CSV stays a valid rectangular table.
With this tool, yes — the conversion happens entirely in your browser using JavaScript. Your JSON is never uploaded to a server, logged, or stored, so it's safe to use with private or proprietary data.