How does it handle merged cells?

Merged cells are the genuinely awkward case in any HTML-to-CSV conversion because CSV has no concept of cells spanning multiple rows or columns. Tools handle this in different ways — some duplicate the value across all the cells the rowspan or colspan would have covered, which preserves the data at the cost of inflating the output. Others leave the spanned positions empty, which preserves the original structure but makes downstream analysis harder. Worth testing the converter against your specific tables before trusting it for important data.

Does it handle multiple tables?

Yes, and most real-world pages have several. The tool gives you a few ways to handle this — extract every table as a separate CSV file, target one specific table by its position on the page or by its id attribute, or concatenate them all into a single output with a separator row between sections. Wikipedia articles, financial reports, and government data pages are the typical case where you want to grab one specific table out of a page that has six.

What about HTML in cells?

Real tables often contain links, images, inline formatting, and small pieces of nested markup. The default behavior strips everything down to plain text content, which keeps the CSV clean and importable. Some tools optionally preserve link URLs as an additional column or surface alt text from images, which is worth opting into when those bits actually matter for your analysis. For a one-off extraction the plain-text default is almost always what you want.

Will it handle nested tables?

Nested tables are uncommon in modern markup but they do show up — usually in older email templates from before CSS layouts replaced table-based design, or in complex government documents. Different tools handle the nesting differently, with most either ignoring the inner table entirely or flattening its content as text inside the parent cell. Either way, complex nested tables tend to need manual cleanup before the CSV is genuinely usable.

What encoding does the CSV use?

UTF-8 is the universal default and handles Unicode characters cleanly — accented Latin, emoji, Chinese, Japanese, Korean, Arabic, anything. Some tools also offer UTF-8 with a byte order mark, which Excel needs to detect Unicode reliably on Windows. If you see garbled characters after import, the encoding mismatch between input and output is usually the cause, and forcing the BOM variant usually fixes it.

Can I extract from a URL?

Some converters fetch a URL directly, parse the returned HTML, and extract any tables they find. The catch is that browser-only tools can only fetch URLs that allow cross-origin requests, which most sites don't, so URL-based extraction usually requires a server-side component. The more reliable approach is to view the source of the target page, copy the HTML, and paste it into a converter that operates on direct input — that works regardless of the source site's CORS policy.

Is the data sent to a server?

Browser-only converters that operate on pasted HTML keep everything local — the parsing happens through the browser's DOMParser API and never touches the network. Converters that fetch URLs do send the URL upstream, though typically not the resulting HTML content. For confidential reports and internal data, the paste-direct flow with a browser-side tool is the safer choice.

HTML Table to CSV

Paste an HTML table and extract the data as CSV, TSV, or JSON. Free HTML table extractor and converter with instant download.

Unit Converters Data / JSON

Instant results

Output Format

HTML Table Input

CSV Output

How to Use HTML Table to CSV

Paste HTML or upload

Drop an HTML file or paste the markup directly into the input area. The source can be a saved web page, a copy of view-source from your browser, an HTML email body, or a document export from a reporting tool. The converter doesn't care where the HTML came from as long as it contains <table> elements — anything else in the surrounding markup gets ignored.

Select table (if multiple)

Most real pages contain more than one table — a summary up top, a detailed breakdown below, occasionally a footnote table. The converter lists every table it finds, and you can pick the one you want by its position on the page (first, second, third) or by its id or class attribute when those are present. For Wikipedia data tables specifically, picking by id is much more reliable than positional indexing.

Configure extraction

The configuration handles the cases where simple text extraction isn't enough. Toggle whether the header row should be included as the first CSV row or skipped, choose how to handle cells with rowspan or colspan (duplicate the value across the spanned cells, or leave them empty), and decide whether HTML inside cells should collapse to plain text or preserve link URLs as additional columns.

Download CSV

The converter produces a CSV file with proper RFC 4180 escaping that opens cleanly in Excel, Google Sheets, pandas, or any database import tool. Worth a quick scan of the output before pushing it through your downstream pipeline — merged cells and unusual character encodings are the usual sources of subtle data corruption that's much easier to fix at this stage than after import.

When to Use HTML Table to CSV

Web data extraction

Wikipedia tables, government statistics pages, and company reports often contain exactly the dataset you need but lock it inside HTML markup. Pulling that into a CSV gets it into Excel, pandas, or a database where you can actually work with it. Researchers, data journalists doing competitive analysis, and analysts who need to pull a one-off comparison out of a public site all do this regularly.

HTML email/document tables

Invoices, monthly reports, and data exports often arrive as HTML — either inside an email or as a downloadable HTML file from a reporting system. Spreadsheet software handles those poorly when pasted directly, but a clean CSV opens cleanly. The tool handles the markup-to-CSV step so you can focus on the data rather than fighting Excel's import wizard.

Reporting tool exports

Some legacy reporting tools only export HTML, leaving you to convert it before doing any further analysis. The tool fits naturally into that workflow as the second step — paste the HTML, get CSV, send it to whatever pipeline expects tabular data. Especially useful when integrating older internal tools into modern data pipelines that expect CSV or JSON inputs.

Documentation conversion

Migrating documentation between systems sometimes means turning HTML tables in old docs into CSV for re-import into a new format. The conversion preserves the data structure even when the surrounding markup is being thrown out. Documentation teams running content migrations across tools tend to encounter this exact case.

HTML Table to CSV Examples

Standard table

Input

<table><tr><th>Name</th><th>Age</th></tr><tr><td>Alice</td><td>30</td></tr></table>

Output

Name,Age\nAlice,30

The minimal case. Header cells (<th>) become the first CSV row, each subsequent <tr> becomes a row of values, and <td> contents become individual cells. Output is comma-separated and newline-delimited, which is what every spreadsheet tool expects by default.

Multi-table page

Input

Page with 3 tables

Output

Three separate CSVs (one per table) by default, or all combined with a separator row if you prefer. Configurable.

Most real pages have more than one table — a stats summary, a detailed breakdown, a footnote table. The tool can extract a specific table by index or ID when you only want one, or batch them all when you want to keep them together.

Cells with HTML

Input

<td><a href='example.com'>Alice</a></td>

Output

Configurable: just 'Alice' (text only) or 'Alice (link: example.com)' if you want the URL preserved as part of the cell value.

Real-world tables often have links, images, or inline formatting in cells. The default behavior strips to plain text so the CSV stays clean, but you can usually opt into preserving link URLs or other metadata as extra columns when that information actually matters for your downstream analysis.

Tips & Best Practices for HTML Table to CSV

1.Inspect the table's HTML structure before extracting. Merged cells (rowspan and colspan), nested tables, and missing closing tags all trip up automated tools. A quick look at the source tells you whether you'll need cleanup or whether the conversion will work cleanly.
2.Plan for some manual cleanup on complex tables. The tool gives you a solid starting point, but oddly structured tables — especially government data with merged header rows — usually need a human pass before the CSV is genuinely usable.
3.Mind the encoding. UTF-8 in, UTF-8 out is the safest path. If the source HTML uses an older encoding (Windows-1252 is still common in legacy reports), you may see garbled accented characters and need to convert encoding upstream.
4.Tables embedded in PDFs need a PDF-specific tool first. Extracting the HTML from a PDF (or using a dedicated PDF table extractor) gets you HTML or CSV directly. The HTML table tool only operates on HTML input.
5.Check decimal and thousand separators before importing. International datasets often write 1,234.56 as 1.234,56, and the tool generally won't convert between conventions. Spreadsheet software then misreads the numbers as text or interprets them with the wrong locale.
6.For repeated extraction, write a script. Manual conversion is fine for a one-off, but if you're pulling the same table weekly, Python with BeautifulSoup and pandas does the same job in fewer keystrokes than even the fastest GUI workflow.

Frequently Asked Questions

It walks through HTML markup, finds the <table> elements, and produces CSV output that any spreadsheet tool can open. Header cells (<th>) become the first row, data cells (<td>) become subsequent rows, and the structural relationship between rows and cells is preserved. Output follows RFC 4180 conventions, which means values containing commas, quotes, or newlines get wrapped in double quotes with internal quotes doubled — the same escaping rules Excel and Google Sheets expect.

HTML Table to CSV

How to Use HTML Table to CSV

Paste HTML or upload

Select table (if multiple)

Configure extraction

Download CSV

When to Use HTML Table to CSV

Web data extraction

HTML email/document tables

Reporting tool exports

Documentation conversion

HTML Table to CSV Examples

Standard table

Multi-table page

Cells with HTML

Tips & Best Practices for HTML Table to CSV

Frequently Asked Questions

Related Tools

CSV to SQL Converter

TSV to CSV Converter

Text to Table Converter

Oven Temperature Converter

Temperature Converter

Length Converter