Converter Tools

TSV to JSON Converter

Convert TSV to JSON and JSON back to TSV in your browser. Header row support, type detection, indent and line-ending options. No upload, no signup.

Convert

TSV and JSON in either direction

Headers

First row is the header

On: emit an array of objects keyed by the first row. Off: emit an array of arrays preserving the raw cells.

Types

Detect numbers, booleans, and null

Cells like 42, -1.5, true, false, and null become typed JSON. Off keeps every cell as a string.

Indent

TSV input

Conversions run entirely in your browser. Nothing you paste is sent to a server.

JSON output

JSON ready3 rows4 columns288 B

[
  {
    "name": "Ada Lovelace",
    "role": "Engineer",
    "age": 36,
    "active": true
  },
  {
    "name": "Alan Turing",
    "role": "Researcher",
    "age": 41,
    "active": true
  },
  {
    "name": "Grace Hopper",
    "role": "Admiral",
    "age": 85,
    "active": false
  }
]

What is TSV and when should I convert it to JSON?

TSV stands for tab-separated values. It is the format Excel and Google Sheets emit when you copy a range to the clipboard, and the default export from many ad platforms, analytics dashboards, and scientific datasets (think NCBI, IMDb, or Bioconductor). JSON is the format most APIs, document databases (MongoDB, Firestore, DynamoDB), and front-end apps prefer. Converting from TSV to JSON turns a flat tabular paste into structured records you can query, filter, or send over the network.

Tips for clean conversions

Copy a range from a spreadsheet and paste straight in. The clipboard already uses tab and newline, which is exactly what TSV expects.
Leave Detect numbers, booleans, and null on for typical data so 42, true, false, and null become real JSON types. Turn it off if you have IDs with leading zeros or codes that look numeric but must stay as strings.
If your TSV has cells with embedded tabs or line breaks, wrap those cells in double quotes. The parser understands the same quoting rules as RFC 4180 CSV, so "A\tB" is one cell that contains a tab.
When converting JSON to TSV, prefer an array of objects so the first object's keys (plus any extra keys seen later) drive the column headers automatically.

How to use

Pick a direction: TSV to JSON or JSON to TSV. The default is TSV to JSON.
For TSV to JSON, set whether the first row is a header, whether to detect numbers, booleans, and null, and how much to indent the JSON output.
For JSON to TSV, choose whether to include the header row, pick the line ending (LF or CRLF), and set the policies for tabs and newlines inside cells.
Paste your data into the input. The conversion runs as you type. Use Load sample to see worked examples or Clear to start over.
Use Copy to copy the result, Download to save a .json or .tsv file, or Swap direction to feed the current output back in as the next input.

About this tool

TSV to JSON Converter turns tab-separated values into JSON and JSON back into TSV, all in your browser. The TSV parser is forgiving about line endings (CRLF, LF, and lone CR are all normalized) and understands both pure TSV with no quoting and spreadsheet-style TSV that uses double quotes to wrap cells containing tabs, quotes, or line breaks, so a range pasted straight out of Excel or Google Sheets converts correctly. The JSON output can be an array of objects keyed by the first row or an array of arrays preserving the raw cells; turn on type detection to coerce numeric cells like 42 and -1.5, the booleans true and false, and the literal null into real JSON types, or leave it off to keep every cell as a string. The reverse direction accepts an array of objects (keys become the header row, in first-sighting order), an array of arrays (each inner array becomes a row), or an array of primitives (each item becomes a single column), and lets you pick a line ending (LF for Unix tools, CRLF for Windows and Excel) plus explicit policies for embedded tabs and newlines because TSV (IANA text/tab-separated-values) does not define quoting and the safe choice depends on the downstream consumer. Stats show the row count, column count, and output size, with a warning when rows have inconsistent column counts so ragged data does not slip through. Useful for moving spreadsheet exports into APIs, document databases, or front-end apps, and for round-tripping JSON datasets back into a paste-friendly tabular format. Everything runs locally; the text you paste here is never uploaded.

Free to use. Works in your browser. No signup, no login.

Related tools

TSV to JSON Converter

How to use

About this tool

You may also like

CSV to JSON Converter

TSV to CSV Converter

JSON to CSV Converter

Markdown Table to JSON Converter

HTML Table to JSON Converter

JSON Formatter