JSON to CSV Converter
JSON to CSV turns an array of objects into a flat, spreadsheet-ready table. Each object becomes a row and every key across the data becomes a column, so you can open API responses or exported records in Excel, Google Sheets or Numbers. Nested values are preserved as JSON text and you can pick a comma, semicolon, tab or pipe delimiter.
How to convert JSON to CSV
- Paste your JSON into the input box, or click 'Load sample' to see the shape it expects.
- Use an array of flat objects for the cleanest result.
- Open the Delimiter menu and choose comma, semicolon, tab or pipe.
- Read the CSV output below.
- Click Copy, or Download to save it as a .csv file.
Examples
Array of objects
[{"name":"Ada","age":36},{"name":"Linus","age":54}]name,age Ada,36 Linus,54
Rows with different keys
[{"name":"Ada","role":"Eng"},{"name":"Linus"}]name,role Ada,Eng Linus,
Nested array kept as JSON text
[{"id":1,"tags":["a","b"]}]id,tags 1,"[""a"",""b""]"
Frequently asked questions
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser using JavaScript, so your JSON never leaves your device and nothing is stored on a server.
What JSON shape works best?
An array of flat objects. Each object becomes one row and each key becomes a column. A single object converts to a one-row CSV, and an array of plain values becomes a single 'value' column.
How are nested objects and arrays handled?
A value that is itself an object or array is written into the cell as JSON text, wrapped in quotes and escaped so the file stays valid. This keeps the table rectangular while preserving the original structure.
What if my objects have different keys?
The converter builds the header from the union of every key it sees, in first-seen order. Rows that are missing a key simply get an empty cell in that column, so no data is dropped.
Can I use a semicolon, tab or pipe delimiter?
Yes. The Delimiter menu offers comma, semicolon, tab and pipe. Semicolon is common in locales where the comma is a decimal separator, and tab produces a TSV file.
How are commas and quotes inside a value handled?
Any value that contains the delimiter, a quote or a line break is automatically wrapped in double quotes, and embedded quotes are doubled. That follows normal CSV rules so spreadsheets read it back correctly.
Does the output open in Excel and Google Sheets?
Yes. Download the .csv file and open it directly, or paste the text into a new sheet. The header row lands in row one and each object fills the rows beneath it.
Is there a size limit?
There is no fixed cap. Because it runs locally, the limit is your device memory, and large arrays convert almost instantly.
Learn more
- JSON to CSV examples
Common JSON shapes and the exact CSV they produce, including heterogeneous rows, nested data and custom delimiters.
Related tools
CSV to JSON
Convert CSV to JSON online. Turn spreadsheet rows into clean JSON objects or arrays, with smart number and boolean typing. Free tier plus API.
JSON Formatter
Format, validate and minify JSON online. Pretty-print with custom indentation, sort keys and catch syntax errors. Runs in your browser.
Air Fryer Converter
Convert any conventional oven recipe to air fryer settings. Lower the temperature by 25 F and cut the cook time by about 20 percent automatically.
Baker's Percentage Calculator
Turn a bread formula into grams with baker's percentages. Flour is 100 percent, enter water, salt and yeast percents to get weights and hydration.
Baking Pan Converter
Swap one baking pan for another and scale the batter to fit. Compares pan areas for round, square and rectangular pans and gives a batter scale factor.
Binary to Decimal
Convert binary to decimal online. Paste any binary number, with or without spaces, and get the exact base-10 value instantly. Runs in your browser.