How is this different from CSV?

The delimiter, and more importantly TSV has no agreed quoting rule — a field containing a tab or a newline cannot be represented. When you need escaping, go through tsv-to-csv first (it adds quotes around fields containing commas, quotes or newlines) and treat the result as CSV.

Why are all values strings?

Same reason as CSV: the source carries no type information, and leaving values alone is what keeps `007` from becoming `7` or a long identifier from losing precision. Convert downstream where you need numbers or booleans.

TSV to JSON

Parse TSV data and output JSON arrays for downstream processing.

Back to tools

Tool Panel

Processed locally

About TSV to JSON

Turns TSV into a JSON array with the header row as keys.

1
Splits columns on tabs and rows on newlines, treats the first row as the header, and keeps every value a string — the same rule as the CSV page, no type inference.
2
Short rows are padded with empty strings, and a file with only a header row yields an empty array rather than one empty object.
3
Best for content copied straight out of a spreadsheet: Excel, Numbers and database clients all put tab-separated text on the clipboard.

Related tools

View all

Data Conversion

CSV to JSON

Convert CSV table data into JSON arrays and objects.

Data Conversion

CSV to YAML

Transform CSV rows into YAML for configuration and data exchange.

Data Conversion

CSV to TSV

Convert comma-separated CSV into tab-separated TSV format.

Data Conversion

JSON to CSV

Export JSON arrays into CSV format for spreadsheets and BI tools.

Data Conversion

JSON to YAML

Convert JSON documents to YAML with clean, readable output.

Data Conversion

JSON to XML

Transform JSON structures into XML format for system integration.

Data Conversion

JSON to TSV

Convert JSON arrays into TSV for tab-based data workflows.

Data Conversion

JSON to Markdown Table

Generate Markdown tables directly from JSON array data.

Data Conversion