HTML Table to Excel
Paste HTML that contains a table, or upload a file up to 200MB, and download its first table as an Excel workbook with numbers and dates stored as real values.
How to use this tool
Paste HTML that contains the table, or upload an .html file, and click Convert & Download .xlsx. The first <table> becomes a one-sheet .xlsx, with every <tr> as a row, header rows included. To pick a specific table on a busy page, right-click it, choose Inspect, select the <table> element and use Copy → Copy outerHTML.
Which cells become numbers
Every cell in HTML is text, so the converter decides what each one should be in Excel. From a pricing table:
| Cell in the page | In the workbook |
|---|---|
25, 1,200 | Numbers (1200), so they sum and sort |
2026-10-01 | A real date, shown as yyyy-mm-dd |
TRUE | A TRUE/FALSE value |
004102 | Text, so the leading zeros stay |
₹4,999, 12% | Text, exactly as shown |
01/10/2026 | Text, because it could be 1 October or January 10 |
To total a price column, add a helper column with =VALUE(SUBSTITUTE(B2,"₹","")), which turns ₹4,999 into 4999 in an Excel set to English number formats; =VALUE(D2) turns 12% into 0.12.
Check the row count
The workbook holds exactly the rows present in the HTML you pasted. A table that the site splits into pages ("Showing 1 to 10 of 240") may contain only the visible page in its HTML, so compare the number of rows you get with the total the site shows. If it offers a "show all" option, use it before copying. Text hidden with CSS, like a label that only appears on phones, is still in the HTML, and it comes through too.
Frequently Asked Questions
When should I pick CSV instead of Excel for a table?
Pick CSV when the data is going into a script, a database import or another tool, since every program reads it and the values arrive exactly as written. Pick Excel when a person will work with it: plain numbers and ISO dates are already typed, so a column can be summed or sorted by date straight away without an import dialog.
Does formatting from the original table (colors, bold, borders) carry over?
No. Only the text of each cell is kept, in the same rows and columns. Colours, bold, borders, links and column widths are not copied, so the workbook opens with Excel's default column widths; double-click a column's right edge to fit it.
The page has several tables. Which one ends up in the workbook?
Only the first <table> in the pasted HTML, and a table nested inside another table’s cell counts as part of that outer table. To get a different one, copy just that table’s markup (in DevTools, right-click the <table> element and choose Copy outerHTML) and paste it on its own.
Related Tools
Related Blog Posts
Extract Meta Tags and Tables From HTML (to CSV or Excel)
How to check a page's title, description, canonical and social tags from its source, the JavaScript-rendering trap that makes View Source lie, and how to pull a table with merged cells into a spreadsheet.
Read moreHow to Convert JSON to Excel, CSV, XML and YAML (and Back)
What actually happens to your data when JSON becomes a spreadsheet, XML, or YAML: missing keys, nested values, leading zeros, and the XML array problem, with real converter output.
Read moreConverting CSV and XML to Excel Without Losing Data
Why double-clicking a CSV mangles PIN codes, long IDs and ₹ signs, what a careful CSV-to-Excel conversion does instead, and how XML records map to spreadsheet columns.
Read more