GEEDITOR / TSV → JSON
About this conversion · TSV → JSON
Prepare TSV data as JSON for an importer or script. Match the destination’s expected delimiter, row structure and treatment of identifiers before exporting the full dataset.
CSV values are read as text here. For example, 0012 stays a text value in the converter, but spreadsheet software can reinterpret it when you open the result. Import identifier columns as text and compare them with the original.
CSV input must use commas; TSV input must use tabs. Quote a field containing a delimiter or line break, and double embedded quotes. There is no delimiter picker or automatic semicolon conversion; export a correctly delimited file first.
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 qty
0012 2
0013 5Output
[
[
"id",
"qty"
],
[
"0012",
"2"
],
[
"0013",
"5"
]
]How to convert
- Click “Choose files” and select the original TSV file. Start with one file when comparing settings.
- Check that the output selector shows JSON. 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 JSON result and compare row counts, headers, empty cells, dates and identifiers with the TSV source. Preserve codes such as 00123 as text in the receiving application; do not assume its automatic type detection is correct.