WebToolsPlanet
Converter Tools

HTML to TSV Converter

Paste HTML containing one or more <table> elements and get clean tab-separated values you can paste straight into a spreadsheet.

Last updated: May 25, 2026

Client-Side Processing
Input Data Stays on Device
Instant Local Execution
Something wrong with this tool? Report it

Find this tool useful? Support the project to keep it free!

Buy me a coffee

What is HTML to TSV Converter?

TSV (Tab-Separated Values) is a plain-text data format where each row is a line and each column is separated by a tab character. It is the format spreadsheet applications (Excel, Google Sheets, Numbers) recognise natively when you paste text from the clipboard, which makes it a convenient way to move tabular data between sources.

This converter parses HTML with the browser's built-in DOM parser, walks every cell in the chosen `<table>`, extracts its text content, and joins the cells with tab characters and the rows with newlines. Cell text is trimmed, and any embedded tab, carriage return, or newline characters are collapsed into single spaces — TSV has no in-cell escaping mechanism, so those characters would otherwise corrupt the column count downstream.

You can convert the first table only (the common case when scraping a single data table) or all tables at once (separated by a blank line). Row, column, and table counts are shown for quick QA, and the result can be copied to the clipboard or downloaded as a .tsv file ready for Excel or Google Sheets.

How to Use HTML to TSV Converter

1

Paste HTML containing one or more <table> elements into the input panel.

2

Choose First Table to extract only the first one, or All Tables to convert each into its own TSV block.

3

Review the row, column, and table counts to confirm the extraction.

4

Copy the TSV to the clipboard or download it as a .tsv file.

5

Paste the result into Excel, Google Sheets, or any tool that accepts tab-separated values.

Common Use Cases

  • Scraping a table from a Wikipedia article into a spreadsheet.
  • Converting an HTML data table from a CMS preview into rows you can paste into Excel.
  • Migrating tabular content from a legacy web page into a Google Sheet.
  • Generating TSV input for command-line tools (cut, awk, csvkit) from HTML.
  • Extracting multiple report tables from a single HTML export.

Example Input and Output

A small HTML table with header and three rows becomes a TSV ready to paste into a spreadsheet.

HTML input
<table>
  <tr><th>Name</th><th>City</th></tr>
  <tr><td>Alice</td><td>London</td></tr>
  <tr><td>Bob</td><td>Paris</td></tr>
</table>
TSV output
Name	City
Alice	London
Bob	Paris

Privacy

All conversion happens locally in your browser. No HTML or TSV is sent to a server.

Cell text only

Only the text content of each cell is extracted. Nested HTML (images, links, styles) is stripped, and only the visible text remains.

Pair with TSV converters

Need TSV in another format? After this tool, run the output through TSV to CSV, TSV to JSON, or TSV to XML to reshape the data.

Frequently Asked Questions

Why TSV instead of CSV?

TSV is what most spreadsheets parse natively when you paste text. There is no quoting to think about — tabs separate columns, newlines separate rows. It is simpler than CSV for clipboard workflows.

What happens to tabs inside a cell?

Embedded tab, carriage return, and newline characters are collapsed into single spaces. TSV has no in-cell escaping, so leaving them in place would break the column count.

Can I convert multiple tables at once?

Yes — choose All Tables. Each table's TSV is emitted as a separate block with a blank line between them.

What if there is no <table> in the HTML?

The tool shows an error explaining no tables were found. Only data inside HTML <table> elements is extracted; lists and divs are ignored.

Does this tool send my HTML anywhere?

No. Parsing and conversion run entirely in your browser. Nothing is uploaded.

Related Tools