What happens when you convert HTML to XLSX
- Each table in the HTML becomes its own sheet, named Table 1, Table 2 and so on. Numbers are stored as numbers, and cells that span several rows or columns stay merged.
- Text outside tables, such as headings and paragraphs, is left out, because a spreadsheet only holds the tables. An HTML with no tables gives a clear message rather than an empty file.
- The file is read by SheetJS running in your browser; nothing is uploaded.
How to convert HTML to XLSX online
- Press "Choose HTML files" and select one or more files, or drag them onto the box. You can add files of any size your device can hold in memory.
- There are no settings to choose: the converter keeps everything the target format can hold.
- Press "Convert to XLSX". The spreadsheet library, about 900 KB, loads the first time and then workbooks convert in a moment.
- Save each XLSX with its download button. Close the tab and every trace of the files is gone from memory.
Why convert HTML to XLSX?
HTML files usually come from web pages, emails and documents meant to be read in a browser. People convert them to XLSX because XLSX is what Excel, Google Sheets and most business tools expect, and it keeps every sheet and formula.
In short, HTML is good at what it was made for, and XLSX is the more practical choice when the file has to open, upload or print somewhere else. HTML opens in every web browser, while XLSX opens in Excel, Google Sheets, Numbers and LibreOffice Calc.
How to convert HTML to XLSX on Windows, Mac, iPhone and Android
On Windows
Open this page in Chrome, Edge or Firefox, drag your HTML files in from File Explorer, and press Convert. Each XLSX is saved to your Downloads folder.
On a Mac
Safari, Chrome and Firefox all work. Drag the HTML files from Finder onto the drop zone and the XLSX files land in Downloads.
On iPhone and iPad
Open the page in Safari and tap Choose HTML files. You can pick from Photos or from the Files app. The converted XLSX appears in Files, in the Downloads folder.
On Android
Open the page in Chrome, tap Choose HTML files and pick them from Files or your gallery. The XLSX is saved to the Download folder, where any file manager can find it.
Best settings for HTML to XLSX
There are no settings: every table is read with its rows and columns as they are, and numbers are stored as numbers.
Each table has its own sheet, in the order the tables appear in the HTML. Rename the sheets in your spreadsheet program if Table 1, Table 2 are not clear enough.
HTML vs XLSX: the differences
| HTML | XLSX | |
|---|---|---|
| Full name | HyperText Markup Language | Excel workbook |
| Type | document | spreadsheet |
| Created by | Tim Berners-Lee | Microsoft |
| First released | 1993 | 2007 |
| Compression | Lossless | Lossless |
| What it holds | text with tags for headings, lists, links, tables and images | several sheets with values, formulas, formatting and charts |
| In a browser | opens in every web browser | opens in Excel, Google Sheets, Numbers and LibreOffice Calc |
| Common uses | web pages, emails and documents meant to be read in a browser | business spreadsheets, reports and anything shared with Excel users |
| MIME type | text/html | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
About HTML and XLSX files
What is an HTML file?
HTML is the language of web pages. A converted document saved as HTML keeps its headings, lists, tables and links and opens in any browser.
What is an XLSX file?
XLSX has been the default Excel format since Office 2007. Inside it is a ZIP archive of XML files, one per sheet, plus styles and shared text.
HTML to XLSX not working? Common problems
- "No tables were found in this file." The HTML has no tables, only text; there is nothing to put into cells.
- Some numbers are text. Numbers written with spaces or currency signs stay text; format the column as a number in your spreadsheet program.
- A page saved from a website has no tables. Many sites draw their tables with scripts; open the page in a browser and save it with File, Save Page As once it has loaded.
Convert HTML to XLSX from the command line
Python's pandas library reads the tables of a page; this writes the first one (it needs lxml, and openpyxl for XLSX):
python3 -c "import pandas as pd; pd.read_html('input.html')[0].to_excel('output.xlsx', index=False)"The converter on this page does the same job in your browser, without installing anything.
HTML to XLSX converter FAQ
Will I lose quality converting HTML to XLSX?
The values in the tables are kept exactly. Text outside the tables is not, and neither is their styling, because a spreadsheet holds values.
Why is the XLSX a different size from the HTML?
Usually smaller than the HTML, because only the tables are kept.
Are my HTML files uploaded anywhere?
No. The conversion runs inside this browser tab using the open-source SheetJS library, so your files stay on your device. You can disconnect from the internet after the page and converter engine have loaded and it still works.
Can I convert several HTML files to XLSX at once?
Yes. Select or drop as many files as you like; they are converted one after another and each gets its own download button.
How do I open an XLSX file?
XLSX opens in Excel, Google Sheets, Numbers and LibreOffice Calc. XLSX is common for business spreadsheets, reports and anything shared with Excel users.
Is this HTML to XLSX converter free?
Yes. There is no sign-up, no watermark and no limit on how many files you convert. The site is paid for by advertising, and because conversions run on your device there is no server cost per file.
Can I convert HTML to XLSX on my phone?
Yes. The converter works in Safari on iPhone and iPad and in Chrome on Android. Converted files are saved to the Downloads folder.