TSV to Table Converter Online — Free Tab-Separated Values

Paste TSV — typically copied from Excel, Google Sheets, or a database export — and render a sortable, filterable HTML table. Export as TSV, CSV, or JSON.

First row is header

Input TSV

Paste TSV above or click Load Sample to render a table.

What is a TSV to Table converter?

A TSV to table converter takes tab-separated values — the format you get when you copy a range out of Excel, Google Sheets, or Numbers — and renders it as a sortable, filterable HTML table. It saves you opening a spreadsheet just to scan a few hundred rows.

Tab-separated values are the unsung hero of the data world: simpler than CSV (no quoting drama for commas in addresses), faster to type out by hand, and the default clipboard format from every spreadsheet app. This tool turns TSV into a styled table so you can sort, filter, and export to JSON or CSV.

How to convert TSV to a table — 4 steps

Paste TSV. Drop tab-separated text into the input — typically copied straight from a spreadsheet selection.
Toggle header. Switch off "first row is header" if your first row is data.
Sort and filter. Click any column to sort. Type in the filter to narrow rows live.
Export. Copy as TSV, CSV, or JSON.

Sample input and output

id	product	category	price
101	Widget A	Hardware	29.99
102	Gizmo Pro	Electronics	199.00
103	Thingamajig	Electronics	89.99

renders to a 3-row table with columns id, product, category, price. Click any header to sort, and type in the filter for a substring match across cells.

Sortable Columns

Click headers to sort ascending or descending. Locale-aware numeric ordering means 9 sorts before 10.

Live Filter

Substring match across every cell. Filter "Hardware" to keep only hardware rows in real time.

Multi-Export

Copy as TSV, CSV, or JSON. The export reflects current sort and filter — only what you see ships out.

Common use cases

check_circlePasting an Excel range to share as JSON without saving a file
check_circleReviewing TSV exports from psql --tsv or BigQuery query results
check_circleCleaning up tabular text scraped from a website or PDF
check_circleConverting between TSV → CSV when target system rejects tabs
check_circleAuditing a TSV export of database table dump for sanity
check_circleFiltering large TSV down to interesting rows before sharing
check_circleQuick comparison between two spreadsheet snapshots
check_circleConverting Excel pivot output (TSV on copy) into JSON for code

TSV vs CSV — when to use which

CSV (comma-separated values) is the canonical exchange format and what most archives, databases, and APIs default to — but it forces quoting whenever a value contains a comma, newline, or quote. TSV (tab-separated values) sidesteps that because tabs almost never appear in real data; the result is a simpler, more reliable parse. The catch is that TSV files don't survive copy-paste through some terminals (which expand tabs to spaces). Use CSV when you need a single-byte delimiter that survives every channel; use TSV when you control both ends of the pipe and want quoting-free parsing.

Need to do more with TSV?

Convert and clean tabular data with the rest of the OpenFormatter toolkit.

CSV to Table JSON to Table CSV to JSON

Frequently Asked Questions

What's the difference vs CSV?

TSV uses a tab character between fields instead of a comma. Tabs are unlikely to appear inside data values, so TSV avoids most quoting hassles. CSV is more common for archives and spreadsheet downloads; TSV is the default when you copy a range out of Excel or Google Sheets and paste into a text editor.

Can I paste from Excel?

Yes — that is the primary use case. Selecting a range in Excel, Google Sheets, Numbers, or LibreOffice and pressing Ctrl+C puts tab-separated text on the clipboard. Paste it here and you get a sortable, filterable preview without a spreadsheet open.

How are quoted fields handled?

Fields wrapped in double quotes can contain tabs, newlines, and embedded quotes (escaped as ""). Most TSV producers do not quote since tabs rarely occur in values, but the parser still handles them correctly when present.

Why use TSV instead of CSV?

TSV is friendlier for data containing commas (financial figures, addresses, prose). It also round-trips cleanly through Excel's clipboard. CSV remains better when you need a single-byte delimiter that cannot appear in source code or terminals (some terminals interpret tabs).

Can I export as CSV?

Yes — Copy as CSV serialises the current sorted/filtered rows with comma delimiters, RFC 4180 quoting, and CRLF-safe newlines. Useful for sending the data to a system that requires CSV.

Does it auto-detect the delimiter?

No — this tool is TSV-only by design (always splits on tab). For comma, semicolon, or pipe input, use the CSV to Table tool instead, which auto-detects the delimiter.

Is the data sent anywhere?

No. Parsing, sorting, filtering, and copying all run in JavaScript inside your browser. No request leaves the page when you load a sample, paste, sort, or filter.

How big a file can it handle?

Tens of thousands of rows render fine in modern browsers but the DOM gets sluggish past 50,000 rows. For very large datasets, filter or chunk before pasting, or use a streaming tool like xsv on the command line.