Flatten nested JSON to CSV without expanding arrays
An API response can be useful in a spreadsheet without turning every nested list into extra rows. These synthetic examples show exactly how the downloaded converter represents each value.
Start with an array of objects
Each object becomes one CSV row. Nested object paths become column names, so a team name appears under /team/name. A code supplied as a JSON string stays a string in the CSV text; your spreadsheet still needs a text column to preserve leading zeros.
JSON input
[
{"name":"Alice","team":{"name":"Sales"},"code":"001"},
{"name":"Bob","team":{"name":"Support"},"code":"002"}
]CSV result
/name,/team/name,/code Alice,Sales,001 Bob,Support,002
The downloaded CSV also includes a UTF-8 BOM. This text example omits that invisible marker.
Arrays stay in one cell
The array below is stored as a JSON string in one CSV cell. It is quoted according to CSV rules. An explicit null becomes the text null; a missing field becomes an empty cell. The converter does not multiply rows to expand an array.
JSON input
[
{"name":"Alice","tags":["red","blue"],"note":null},
{"name":"Bob"}
]CSV result
/name,/tags,/note Alice,"[""red"",""blue""]",null Bob,,
The downloaded CSV also includes a UTF-8 BOM. This text example omits that invisible marker.
Check formulas and long identifiers
Formula protection is on by default. Values starting with =, +, -, or @ receive an apostrophe in the exported CSV. Negative numbers can therefore become text. Review this setting before using the result.
Long integer identifiers should be strings in the original JSON. A number that has already lost precision during JSON parsing cannot be reconstructed by the converter.
Use the supported input shape
The input must be a UTF-8 JSON array containing objects. A single object, an array of numbers, an empty array and malformed JSON are outside this tool's supported input shape. The limits are 5 MB, 10,000 rows, 200 columns and 40 levels of nesting.
After purchase, extract the ZIP and open index.html in current desktop Chrome or Edge. The interface starts in English and has a Korean option. The examples on this page are fixed documentation; this page does not accept your files.