TSV to JSON
Convert to
Tools for this file
Your files never leave your device.
The first row becomes the keys, and each row after it becomes one object. Plain numbers become JSON numbers; everything else stays a string.
Questions about TSV to JSON
How does TSV to JSON work?
TSV to JSON reads your tab-separated table and writes an array of objects, one per row, with the first row as the keys. Plain numbers become JSON numbers, while text, dates and codes such as 007 stay strings exactly as written. Empty rows are left out and empty cells become empty strings.
Which values become numbers?
Plain decimal numbers such as 12, -4 or 0.75, with up to 15 digits before the point. Values with leading zeros, a plus sign, thousands separators, currency symbols or percent signs stay strings, and so do true and false.
What if a row has more cells than the header?
The extra cells still get keys, named after their column position, such as column5. A row with fewer cells than the header gets null for the values it is missing.
Is the output one long line?
No. It is pretty-printed with two-space indentation and one key per line, so it is easy to read and compare. The file is UTF-8.