TSV to JSON Converter

Paste tab-separated values and convert them to a JSON array of objects.

🔒 100% private — runs entirely in your browser

or try sample data

What is TSV to JSON?

TSV to JSON converts tab-separated values into a JSON array of objects. The first row provides the headers (object keys), and each subsequent row becomes an object in the array.

TSV is commonly used for data exported from spreadsheets, databases, and command-line tools. Unlike CSV, tabs rarely appear in data values, so TSV files typically need less quoting and escaping.

The converter auto-detects numbers, booleans, and null values so your JSON output has proper types. All processing runs in your browser — your data stays on your machine.

TSV to JSON — Common Use Cases

Basic TSV conversion

name	age	city
Alice	30	New York
Bob	25	London // Converts to:
[ { "name": "Alice", "age": 30, "city": "New York" }, { "name": "Bob", "age": 25, "city": "London" }
]

Tab characters separate columns. Numbers are auto-detected when "Auto-detect types" is enabled.

Spreadsheet export

// Copy data from a spreadsheet and paste directly.
// Spreadsheet apps use tabs when copying to clipboard,
// so your data will be tab-separated automatically.

Tip: Select cells in Excel or Google Sheets, copy (Ctrl+C), and paste directly into the input.

TSV Parsing Gotchas

Tabs vs spaces

TSV uses actual tab characters (\t), not spaces. If your data uses spaces for alignment, it's not valid TSV. Use the CSV converter with a space or comma delimiter instead.

Missing values

Empty cells between tabs (e.g., Alice\t\tNew York) become empty strings in the JSON output. The tool preserves the column positions correctly.

Frequently Asked Questions

How do I convert TSV to JSON?

Paste your tab-separated data and click "Convert to JSON". The first row becomes the keys, and each subsequent row becomes a JSON object.

What is TSV format?

TSV (Tab-Separated Values) uses tab characters to delimit columns. It's simpler than CSV because tabs rarely appear in data, reducing the need for quoting.

Can I paste directly from Excel?

Yes. When you copy cells from Excel or Google Sheets, the clipboard uses tab-separated format. Just paste it in and convert.

Is my data safe?

Yes. All processing happens in your browser. No data is sent to any server.