JSON to CSV
Convert JSON records into CSV columns in your browser.
Paste JSON or choose a UTF-8 JSON file.
CSV result
No output yet
All rows are included. Downloads use UTF-8 with CRLF record separators. The preview displays line and paragraph separators as line breaks.
How to convert JSON to CSV
- Add your JSON
Paste an array of records or choose a UTF-8 JSON file from your device.
- Choose your columns
Flatten nested objects or keep them as JSON cells. Choose the separator your spreadsheet expects.
- Convert and save
Convert to CSV, inspect the output, then copy it or download the file.
Files stay on your device
File reading and conversion run in this browser tab. Your JSON is not uploaded, logged or saved by the tool.
Reset clears the input and output. It does not delete downloaded files or clear your clipboard.
Learn moreFrequently asked questions
Are my files uploaded?
File reading and conversion run in this browser tab. Your JSON is not uploaded, logged or saved by the tool.
Which JSON shapes can I convert?
An array of objects becomes one row per object. A single object becomes one row. An array of strings, numbers, booleans, nulls or arrays becomes a single column named value. A single scalar also becomes one row in that column.
Arrays that mix objects with other values need to be made consistent first. Empty arrays and objects with no fields produce an error. If your records are inside a property such as data, paste that property's array to convert its items into rows. JSON Lines, comments, duplicate keys and trailing commas are not accepted.
How are nested JSON objects flattened?
Flattening joins keys with dots. For example, {"address":{"city":"Toronto"}} becomes a column named address.city. Headers follow the order their fields first appear across all records.
A dot inside a key becomes \., a backslash becomes \\, and an empty key becomes \e. These escapes keep different paths distinct. Arrays and empty nested objects stay as JSON text in one cell. Choose Keep as JSON cells to retain nested objects and original top-level key names.
Will my values change in the CSV?
Strings are decoded, and numbers keep their original text, including long IDs, decimals and exponents. Commas, quotes and line breaks receive CSV quoting. Nested JSON cells keep their source spelling. Unpaired Unicode surrogates are shown as escape sequences because UTF-8 cannot encode them.
CSV does not preserve JSON types. Null and the string "null" both become null. Missing fields and empty strings both become empty cells. Spreadsheet protection adds an apostrophe to formula-like cells and headers, with a count shown after conversion. Turn it off when exact cell text is required.
How do I open the CSV in Excel or another spreadsheet?
Download the CSV and import it with UTF-8 encoding and the separator you selected. Choose text columns for IDs, dates and numbers that must keep their spelling. A spreadsheet can otherwise remove leading zeros or round long numbers even though the CSV contains the original text.
Protect spreadsheet cells reduces formula interpretation by adding apostrophes. Import behavior varies by application. Review the import settings before opening data from an untrusted source.
Can I convert a large JSON file?
There is no configured file or row limit. The browser must hold the input, parsed values and CSV in memory. Browser memory, string or nesting limits can cause an error. Cancel stops the worker and keeps your input ready to retry.
Files must contain valid UTF-8 JSON. The file extension does not determine how its contents are read. Copying may change line endings to match your operating system. Download the file to preserve the exact output bytes.