Two simple rows
[{"name":"Ada","team":"Data"},{"name":"Grace","team":"Platform"}]Two CSV rows with name and team columns
JSON to CSV Converter
Paste a JSON object or array, flatten nested fields into dot-notation columns, preview the rows, and copy or download the CSV without uploading your data.
Private browser converter
JSON input to CSV preview
Paste one object or an array of objects. Nested objects become dot-notation columns, while arrays stay together inside one CSV cell.
1. Add JSON
0 B of 5 MB
2. Choose CSV settings
Safe defaults for spreadsheet exports
How to use the JSON to CSV Converter
- Paste one JSON object or an array containing only objects, or choose a JSON file up to 5 MB.
- Choose comma, semicolon, or tab output. Keep spreadsheet formula escaping on for untrusted data.
- Press Convert JSON, then check the row count, column count, dot-notation headers, blank cells, and preview.
- Copy the CSV or download it. Add a UTF-8 BOM only when your spreadsheet app needs help reading non-English characters.
What people use it for
Turn a small API response into spreadsheet rows without uploading it.
Flatten nested customer, product, or event objects into dot-notation columns.
Preview irregular JSON records before copying them into a data-cleaning workflow.
Create comma, semicolon, or tab-separated exports with spreadsheet formula protection.
Quick examples
Nested profile
[{"id":1,"profile":{"city":"Brisbane"}}]Columns named id and profile.city
Spreadsheet-safe cell
[{"label":"=2+2"}]The exported label starts with an apostrophe when protection is on
Need the guide or a nearby tool?
Need a slower walkthrough, a related converter, or the full library? These links keep you close to the task you started.
- How to use the JSON to CSV ConverterSee slower examples, input meanings, formula notes, result limits, and mistakes to avoid.
- Developer ToolsBrowse related calculators and utilities in the same category.
- Tool and utility guidesFind more guides that use real tool inputs, examples, mistakes, and result notes.
- All free toolsSearch every live tool, converter, calculator, AI helper, and browser utility.
Frequently asked questions
Plain-language answers about accepted JSON shapes, nested columns, CSV quoting, spreadsheet safety, file encoding, and browser privacy.
When should I use the JSON to CSV Converter?
Use it when your task matches one of these common needs: Turn a small API response into spreadsheet rows without uploading it. Flatten nested customer, product, or event objects into dot-notation columns. It works best when you already know valid JSON containing one object or an array of objects, plus the delimiter and export-safety settings you need.
What is the JSON to CSV Converter doing with my inputs?
In plain language: The tool parses one JSON object or an array of objects, recursively flattens nested objects into dot-notation columns, keeps arrays together as JSON cells, preserves first-seen column order, and applies CSV quoting rules. Spreadsheet-safe mode prefixes cells that start with =, +, -, or @. The examples on the page are there so you can compare your inputs with a converted JSON example before copying the answer.
What do the main JSON to CSV Converter inputs mean?
JSON input: One object becomes one CSV row. An array of objects becomes multiple rows. Primitive roots and arrays containing non-object items are rejected. Delimiter: Comma makes standard CSV, semicolon can help in comma-decimal locales, and tab makes tab-separated output. Escape spreadsheet formulas: When on, cells starting with =, +, -, or @ after optional whitespace get an apostrophe prefix before export. UTF-8 BOM: An optional invisible marker that can help some spreadsheet apps recognise non-English characters.
How should I read the JSON to CSV Converter answer?
Read the output next to your original input. If the tool changes format, units, encoding, spacing, or capitalization, compare a small sample before copying the whole result into another app.
What should I double-check before trusting the answer?
The input must be valid JSON with an object at the top level or an array containing only objects. The browser limit is 5 MB, arrays stay inside one cell, and dot-notation field collisions must be renamed before conversion. Also check nested dot-notation headers, serialized array cells, missing fields, the chosen delimiter, and whether formula escaping changes a value you expected to remain numeric.
How are nested JSON objects converted?
Nested object keys become dot-notation columns. For example, profile.city becomes one column. Empty objects stay as {} so the field is not silently lost.
What happens to arrays inside a JSON object?
An array stays together as compact JSON inside one CSV cell. The converter does not create extra rows from array items because that could change the meaning of the original record.
How are commas, quotes, and line breaks escaped?
A field containing the selected delimiter, a double quote, or a line break is wrapped in double quotes. Any double quote inside that field is doubled, following the common CSV format described by RFC 4180.
Why does spreadsheet-safe mode add an apostrophe?
Spreadsheet programs may treat cells beginning with =, +, -, or @ as formulas. The apostrophe asks the spreadsheet to treat the cell as text. Keep this on for exports containing data you did not write yourself.
Why is a column blank in some rows?
The converter uses the union of first-seen fields across every object. If one object does not contain a field that another object has, its CSV cell is left blank.
Does the site save what I enter?
No. Parsing, flattening, previewing, copying, and downloading run in your browser tab. Access Free Tools does not receive your JSON or generated CSV, and the input and output areas are masked from Microsoft Clarity.