Conversion

TSV to JSON

Convert tab-separated values to JSON. Paste directly from Excel or Google Sheets — the first row is used as keys.

TSV Input

JSON Output

[
  {
    "id": "1",
    "name": "Alice",
    "email": "alice@example.com",
    "city": "New York"
  },
  {
    "id": "2",
    "name": "Bob",
    "email": "bob@example.com",
    "city": "London"
  },
  {
    "id": "3",
    "name": "Charlie",
    "email": "charlie@example.com",
    "city": "Tokyo"
  }
]

TSV Format

TSV (Tab-Separated Values) uses a tab character (\t) as delimiter instead of a comma. The first row is treated as column headers and becomes the object keys in JSON output.

From Excel / Google Sheets

Select a range of cells in Excel or Google Sheets and copy (Ctrl+C / Cmd+C). The clipboard content is automatically tab-separated — paste it directly into the input panel.

vs CSV

TSV avoids the quoting complexity of CSV because tab characters rarely appear in data. However, if your data contains tab characters, use CSV with a comma delimiter instead. See also: CSV to JSON and JSON Formatter.