HTML to Excel converter
Turn the tables on a web page into an Excel spreadsheet. Paste a table you copied, or drop a saved page, and each table becomes its own sheet.
Drop an HTML file here
A saved web page (.html, .htm or .mhtml), up to 100 MB. It stays on your computer.
- No sign-up
- No content uploaded
- Every table on the page
Web tables, ready to sort and total.
Your file stays on your computer
The HTML is read and the spreadsheet is built in your browser. Its contents are never sent to Mammoth or anyone else.
No footnote marks in the numbers
Marks such as [1] and hidden text are left out, so 15,292 [14] becomes a number you can add up.
Merged cells filled in
A cell that spans two rows fills both, so every row can be sorted and filtered on its own.
How to convert HTML to Excel
Each table on the page becomes a sheet. Its header row becomes the first row, and each row of the table becomes a row in Excel.
- 1
Add the table
Copy a table from a web page and paste it, or drop a page you saved as .html or .mhtml.
- 2
Pick the table
The largest table opens first. Choose another from the list if the page has more than one.
- 3
Download
Save every table in one Excel file, or just the one you picked.
Other ways to do it
Python's pandas library reads web tables too, with read_html. The difference is what comes out the other end.
Python with pandas
A script you run yourself
- Footnote marks removedNo
- Two-row headers joinedNo
- Every table at onceYes
- No code to writeNo
- This page
This converter
A spreadsheet in one step
- Footnote marks removedYes
- Two-row headers joinedYes
- Every table at onceYes
- No code to writeYes
How to convert HTML to Excel in Python
The pandas library reads every table on a page with read_html, and writes one to Excel. Here is the whole script.
Need a CSV instead? The HTML to CSV converter reads the same tables. For a table in a Word document, use the Word to Excel converter.
import pandas as pd
tables = pd.read_html("page.html")
print(len(tables), "tables")
tables[1].to_excel("table.xlsx", index=False)Pick the table by its number in the list. A table with a two-row header, as many Wikipedia tables have, stops to_excel with NotImplementedError, and footnote marks such as [12] stay in the cells.
Your file stays private
The converter runs inside this page. Your HTML is read and turned into a spreadsheet on your computer, and its contents are never sent to Mammoth. We record only what kind of data it was, such as a price list, and its common column names, never a value.
Once the page has loaded, it works with your internet switched off.
Copying the same table every week?
Mammoth can take it from there. Save each week's table as Excel in a folder and Mammoth adds it to one table, ready to filter, total and download.
Weekly rates
| Week 45 | Nov 03 | Euro | 0.8612 | |
| Week 45 | Nov 03 | British pound | 0.7598 | |
| Week 46 | Nov 10 | Euro | 0.8641 | |
| Week 47 | Nov 17 | Euro | 0.8597 | |
| Week 47 | Nov 17 | Japanese yen | 154.21 |
Illustration. Every new file in the folder is added to the same table.