1. Home
  2. Spreadsheets & Data
  3. HTML Table to CSV

HTML Table to CSV

Turn tables copied from web pages or HTML code into CSV or Excel.

Runs in your browser · No upload

Your text and files are processed only in this browser and never uploaded. No script is run.

How to use

  1. Select a table on a web page with the mouse, copy it (Ctrl+C), and paste it (Ctrl+V) into the box above. The formatting and merged-cell information come along.
  2. If there are several tables, tick the ones you want in the Tables found list and use the preview button to check each.
  3. Choose how to handle merged cells, line breaks inside cells and the header. For columns that should be numbers, such as prices, tick them under Clean as numbers.
  4. Click Save CSV, Save XLSX, Save JSON or Open in workbench.
  5. You can also paste HTML source code or drop an .html file; the tool finds each <table> the same way. Text copied from Excel or Google Sheets (tab-separated) is read as one table.

Options

Option What it does
Merged cells: Repeat value Fills every cell covered by rowspan or colspan with the same value. Best for sorting, filtering and pivots
Merged cells: First cell only Puts the value in the first cell of the merged area and leaves the rest empty, keeping the original look
Line breaks: To spaces Joins <br>, paragraph ends and source line breaks into single spaces
Line breaks: Keep Keeps the lines split by <br>, <p>, <li> and similar as line breaks inside the cell
Header Auto treats the first row as the header when every cell is a <th> or sits in <thead>. Otherwise columns are named Col 1, Col 2 …
Clean as numbers Removes currency signs, % and thousands commas from the chosen columns so they become numbers

How merged cells are expanded

In an HTML table a rowspan occupies cell positions in the rows below it. The tool places each row’s cells into free columns using the same layout rules a browser uses, then fills the merged ranges so every row has the same length.

When the header spans two or more rows, the parts are joined top to bottom per column. In the sample, Jan and Feb under Sales become the columns Sales Jan and Sales Feb. The table below is the sample after number cleaning.

Branch Sales Jan Sales Feb
Seoul 1200000 1350000
Seoul 980000 1010000
Busan 850000 -12.5

With “First cell only”, the branch cell in the second row would be empty instead.

Number cleaning rules

  • 1,234원 → 1234, ₩3,000 → 3000, -12.5% → -12.5, (1,200) → -1200
  • If the result still does not look like a number (12abc, dates), the original value is kept. A percentage only loses its sign; it is not divided by 100.
  • Header cells are left alone. When number cleaning is used, an XLSX download stores number-like values as number cells.

Why pasting unknown HTML is safe here

Pasted HTML is only parsed with the browser’s DOMParser. Scripts do not run, the parsed document is never attached to the page, and cell values are read as plain text (textContent). <script> and <style> are removed before reading. In the CSV download, values starting with = or @, which Excel could run as formulas, get a leading '. Input up to 5 MB is supported.

Related tools: Excel & CSV Workbench, HTML to Markdown, XML to CSV Converter, JSON to CSV Converter

Your text and files are processed only in this browser and are never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.