HTML to XLSX Converter

A surprising amount of useful data reaches people as HTML. Sports results, price lists, timetables, exchange rates and statistics are published as tables on web pages; banking portals, booking systems and older business software export reports as .html files; some email programs save messages with tables as HTML. Reading them in a browser is easy. Working with the numbers is not, because a web page cannot sort, filter or sum a column.

Copying a table into Excel by hand rarely goes well. Selections stop at the screen edge, cells merge into one, links and icons come along, and the formatting fights with the spreadsheet's own. Converting the saved HTML file avoids all of that: the table's own structure decides the rows and columns, and you get a clean grid in a workbook.

The list above shows every format the Data Converter accepts and can produce. HTML is one of several inputs, so the same tool also handles CSV, JSON and XML files when they come along with the page.

HTML marks up tables with dedicated elements for rows, header cells and data cells, as described in the HTML Living Standard. The converter follows those elements, which is what makes the result reliable: a row in the page becomes a row in the sheet, and a cell that spans two columns stays in the right place. The points below explain what to expect.

Pages built for people often add things a spreadsheet does not need: a caption above the table, a totals row at the bottom, footnote markers next to figures, or a second header row grouping the columns. These come through as rows like any other. They are easy to spot at the top and bottom of each table in the workbook, and deleting them takes a few seconds before you start filtering or building charts.

Some modern sites load their tables with scripts after the page opens. If you save such a page as HTML only, the file may contain an empty frame instead of the data. Wait until the table is fully visible, then save it again, choosing Webpage, Complete if your browser offers it. If the file still has no table, the site is drawing the grid without HTML table elements, and an export button on the site, often labeled CSV, is the better route.

Large reports with thousands of rows convert in one go, and up to 20 HTML files can go into one batch. Each file becomes its own workbook. If the data is already in CSV form, CSV to XLSX is the direct route; to turn a workbook into a printable report, use XLSX to PDF. The Data Converter lists every other format pair.

A saved page can hold more than you expect, such as hidden tables used for layout or tracking. If the workbook contains a few tiny tables with one or two cells, they came from the page's layout and can be deleted. The table you were after is usually the largest one, and its rows appear in the same order as on the screen.