GEEDITOR / JSON → NDJSON
About this conversion · JSON → NDJSON
Prepare JSON data as NDJSON for an importer or script. Match the destination’s expected delimiter, row structure and treatment of identifiers before exporting the full dataset.
Use an array of objects or an array of row arrays. Object keys become columns; missing values become empty cells. Nested objects and arrays become JSON text inside a cell, not extra columns. Normalize a deeply nested structure before importing it as a flat table.
JSON output is an array of row arrays, including the header row; it is not automatically an array of keyed objects. NDJSON output places one row array on each line. Confirm that the receiving program expects this structure.
Worked example
Input
[
{
"id": "0012",
"name": "A, B",
"meta": {
"size": "M"
}
},
{
"id": "0013",
"name": "C"
}
]Output
["id","name","meta"]
["0012","A, B","{\"size\":\"M\"}"]
["0013","C",""]How to convert
- Click “Choose files” and select the original JSON file. Start with one file when comparing settings.
- Check that the output selector shows NDJSON. The instructions here describe this choice; changing the output can change which settings apply.
- Click “Convert files”, then save the result from its file row. “Download all” puts completed files into a ZIP; it does not combine their contents.
- Open the NDJSON result and compare row counts, headers, empty cells, dates and identifiers with the JSON source. Preserve codes such as 00123 as text in the receiving application; do not assume its automatic type detection is correct.