Convert Excel to HTML
Publishing a sheet means answering one question the spreadsheet never had to: what does a formula look like on a web page. The answer is its value, because nothing on the page will recalculate. The first sheet becomes a table, the cell formatting comes across as markup, and everything interactive about a workbook is left behind.
Use this without the search next time. Prathom Workbench puts Prathom's tools in your toolbar.
Add to Chrome — freeDrop your XLSX file here, or click to browse
Up to 50 MB. Deleted automatically after 30 minutes.
What it does
- The first sheet becomes a table element
- Formulas are published as their computed values
- Cell formatting is carried as markup rather than discarded
How to use Excel to HTML
- 1
Upload the workbook
An .xlsx from any application. Move the sheet you want to publish to the front, since the first is the one exported.
- 2
The sheet becomes a table
Rows and cells map directly. Merged cells become spans, so a header spanning three columns still spans three columns.
- 3
Trim the styling if the page has its own
The output carries the workbook's formatting. On a site with its own table styles, stripping it gives a more consistent result.
How it works
The workbook is opened and its first sheet is walked cell by cell. Each row becomes a table row and each cell a table cell, with merged regions emitted as row and column spans so the visual grouping survives.
Formulas contribute their cached computed values. A browser has no calculation engine, so a published formula would be inert text; the number is what is useful.
What a web page cannot carry
Sheets beyond the first, live calculation, sorting and filtering, charts, and anything that depended on interacting with the workbook. What is left is a static table, which is exactly right for publishing a result and wrong for handing someone a model.
The formatting decision
The conversion carries the workbook's formatting into the markup, which is the correct default: pasted into an empty page it looks like the sheet did. On a site with its own table styling that formatting fights the design, and stripping it is the usual next step. There is no single right answer, so the output keeps the information and lets you remove it.
When CSV is the better intermediate
If you want a table with your own markup and classes, converting to CSV first and generating the HTML from that gives complete control over the output. Go directly to HTML when you want the sheet to look like the sheet.
The first sheet, and only the first
A workbook is frequently several sheets and an HTML table is one table, so the conversion takes the first sheet and leaves the rest. Nothing warns you, because from the file's point of view nothing went wrong.
This catches people out most often with workbooks where the first sheet is a cover page, an index, or a set of notes — the actual data being on sheet two. The result is a technically perfect table of the wrong thing.
If the sheet you want is not first, move it there before converting, or export it on its own. Both take a moment in any spreadsheet application and remove the question entirely.
Formulas arrive as their answers
Every formula in the sheet is exported as the value it last calculated, because a web page has no calculation engine behind it. That is the only sensible behavior and it is worth stating, because the table on the page will never change again.
If the numbers depend on something that moves — a rate, a date, a total drawn from another sheet — the published table is a photograph of one moment. Refreshing the page will not update it; only converting again will.
Examples
A results table for a report page
The summary sheet publishes cleanly and the merged header cells survive as column spans. The other two sheets are not in the output, which is the thing to check before assuming the page is complete.
A sheet full of live formulas
The page shows the numbers as they stood at conversion. Nothing recalculates in a browser, so republish whenever the workbook changes rather than expecting the table to follow it.
Frequently asked questions
Do the formulas still work in the HTML?
No, and nothing could make them. A web page has no calculation engine, so each formula is published as the value it had at the moment of conversion. The table is a snapshot. If the underlying data changes regularly, the practical approach is to re-export and republish rather than to look for a live link, which would need an application rather than a static page.
Which sheet is exported?
The first one in the workbook. An HTML table is a single table, and there is no obvious way to render several sheets into one without inventing a layout you did not ask for. If the sheet you want is not first, move it to the front of the workbook before converting, which takes a drag and produces exactly the right output.
Can I control how the table looks?
The output carries the workbook's own formatting as markup, which is useful when the page has no table styles and unhelpful when it does. If your site already styles tables, stripping the inline formatting after conversion gives a table that matches everything else on the page. Converting to CSV and building the markup from that is the other route when you want structure only.