How to use
- 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.
- If there are several tables, tick the ones you want in the Tables found list and use the preview button to check each.
- 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.
- Click Save CSV, Save XLSX, Save JSON or Open in workbench.
- You can also paste HTML source code or drop an
.htmlfile; 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.