Most tutorials that tell you to convert excel to html table online stop at the easy part: paste your cells into a converter and copy the output. Then you paste that HTML into a blog post or an email template and everything falls apart — special characters break the layout, leading zeros vanish from ZIP codes, dates flip into the wrong format, and the table blows out the page on mobile. This guide covers the full copy-paste workflow from Excel or Google Sheets to a clean, valid, responsive HTML table, including everything that typically goes wrong and how to fix it.
Table of Contents
- Excel to HTML Table: The Copy-Paste Workflow
- What Breaks When You Copy Spreadsheet Data to HTML
- Escaping Entities Properly
- Before and After: A Clean Table Snippet
- Making a Responsive HTML Table from a Spreadsheet
- When Markdown Is the Better Intermediate Step
- Try It: Convert Excel to HTML Table in Your Browser
- Frequently Asked Questions
Excel to HTML Table: The Copy-Paste Workflow
The basic workflow is simple and works the same whether your data lives in Microsoft Excel, Google Sheets, or LibreOffice Calc: Master this once and the Excel to HTML table conversion becomes a two-minute job.
- Select the range of cells you want to publish and copy it (
Ctrl+CorCmd+C). - Paste the data into an excel to html converter tool — the paste arrives as tab-separated values, which the tool reads row by row.
- Choose your options: first row as header (
<th>), table border and styling, whether to include a<caption>, and an ID or class for your CSS. - Copy the generated HTML and paste it into your page, then wrap it in a responsive container (shown below).
This is the workflow most converters assume you already know. The rest of this post is about the parts they skip: the silent data corruption that happens between your spreadsheet and your page, and the small fixes that prevent it. Everything below is the missing manual for a clean Excel to HTML table result.
What Breaks When You Copy Spreadsheet Data to HTML
Merged cells collapse
Spreadsheets allow merged cells; HTML tables do not have a one-to-one equivalent without colspan and rowspan attributes. When you copy a range with merged cells into most converters, each merged area collapses into a single cell with empty siblings, shifting your columns out of alignment. The reliable fix is to unmerge the cells in your spreadsheet first, fill the blanks with the repeated value (or leave them intentionally empty), and then copy. If you genuinely need the merged look on the page, apply it in HTML with <td colspan="2"> after generation. Merged cells are the first casualty in any Excel to HTML table workflow — unmerge or span them deliberately.
Special characters corrupt your markup
Product names like Ben & Jerry’s, prices like <$50, and comparisons like 5 > 3 contain the three characters HTML treats specially: &, <, and >. If these land in your HTML unescaped, <$50 starts looking like a malformed tag to the browser and the cell renders empty or the layout breaks. Proper escaping turns them into &, <, and >. A quality converter escapes entities automatically; if you are hand-editing, an html entity encoder converts them reliably without guesswork. This one issue causes most “my table disappeared” complaints. Three innocent characters, one broken layout: the classic Excel to HTML table failure.
Leading zeros vanish
ZIP codes like 00501, product SKUs like 0042, and phone prefixes lose their leading zeros the moment Excel treats them as numbers. If your source column is formatted as a number, the zero is gone before you even copy — no HTML converter can recover it. Format the column as Text in the spreadsheet before copying. In Google Sheets, use Format → Number → Plain text. This is a source problem, not a converter problem, and it is the easiest one to miss. Format as Text before copying, or your Excel to HTML table output will silently eat the zeros.
Dates and times reformat silently
Copying 09/26/2026 from a US-formatted sheet into a converter often yields the underlying serial number or a locale-flipped date like 26/09/2026, depending on the tool. Before copying, lock the format you want: set an explicit date format in the spreadsheet, or convert the column to plain text in YYYY-MM-DD form so nothing downstream can reinterpret it. Dates are the sneakiest Excel to HTML table bug because the corruption looks plausible.
Spreadsheet junk comes along for the ride
Copying directly from Excel into a rich-text editor (or a CMS visual editor) often drags along hidden inline styles, mso- XML namespaces, and fixed widths designed for print. This bloats the markup and fights your site’s CSS. Pasting into a plain-text step first — or using a converter that generates clean HTML from tab-separated values — strips all of it. If you regularly sanitize pasted text, the same habit behind removing duplicate lines while preserving order applies here: clean the data before you structure it. Paste through a plain-text step first and your Excel to HTML table markup stays clean.
Escaping Entities Properly
The HTML spec reserves five characters: & (&), < (<), > (>), " ("), and ' ('). Inside table cells you mostly need the first three. A converter that handles this for you is worth choosing over one that does not, because hand-escaping a 200-row table is where errors hide. As a rule of thumb: if your data contains brand names, math symbols, currency notes, or code fragments, verify escaping in the generated output before publishing. The MDN documentation for the table element is the authoritative reference for which elements and attributes are valid in table markup. Know these five: the escaping half of Excel to HTML table is solved.
Before and After: A Clean Table Snippet
Here is a minimal before/after pair. The “before” is what raw spreadsheet content looks like when pasted without cleanup; the “after” is valid, semantic HTML: Study the pair: this is what a correct Excel to HTML table transformation looks like.
Before — raw pasted data (tab-separated, unescaped)
Product Price Notes Ben & Jerry's <$5 Best > others
After — valid semantic HTML
<table>
<thead><tr><th>Product</th><th>Price</th><th>Notes</th></tr></thead>
<tbody><tr><td>Ben & Jerry's</td><td><$5</td><td>Best > others</td></tr></tbody>
</table>
Notice three things: the header row uses <th> inside <thead> (better for accessibility and for screen readers), every special character is escaped, and there is no inline styling — appearance belongs in your CSS, not in the generated markup. Headers, escaping, structure — the three checks for every Excel to HTML table you ship.
Making a Responsive HTML Table from a Spreadsheet
Wide data tables are the classic mobile-breakage scenario: a 6-column table that looks fine on desktop forces horizontal scrolling on a phone. The simplest robust fix is a wrapper div with horizontal scrolling, which keeps the table intact without distorting it: A table nobody can read on a phone is a failed Excel to HTML table, however valid the markup.
<div class="table-scroll">
<table> ... </table>
</div>
With this CSS in your stylesheet:
.table-scroll { overflow-x: auto; }
.table-scroll table { min-width: 600px; border-collapse: collapse; }
The min-width preserves readable column widths; overflow-x: auto gives touch-friendly scrolling only when the viewport is too narrow. Avoid shrinking font sizes to force a fit — a scrollable table is far more usable than unreadably tiny text. For email developers, note that many email clients strip or ignore this wrapper, so keep email tables narrow (under 600px total) and test in your actual client before sending. That wrapper is the difference between a desktop-only Excel to HTML table and a mobile-friendly one.
When Markdown Is the Better Intermediate Step
If your final destination is a static site generator, a docs platform, or GitHub, consider generating a Markdown table instead of HTML. Markdown tables are plain text, version-control friendly, and convert cleanly to HTML later. An markdown editor with a live preview lets you draft the table in Markdown, check the rendering, and export HTML when you need it. For bloggers who publish comparison tables across many posts, keeping the source data in Markdown (or even in the spreadsheet itself, generating HTML per publish) makes updates far less error-prone than editing HTML cells by hand. Sometimes the smartest Excel to HTML table move is not producing HTML at all.
Try It: Convert Excel to HTML Table in Your Browser
Ready to convert your own data? Use our free HTML table generator: copy any range from Excel or Google Sheets, paste it in, choose header row and styling options, and copy out clean, escaped, valid HTML. It runs entirely in your browser — your pasted data is never uploaded to our servers, which matters when your spreadsheet contains internal pricing or customer lists. If you need to number the rows of your source data first, the add line numbers to text utility pairs well with this workflow. Paste a range and watch a clean Excel to HTML table appear in seconds.
Frequently Asked Questions
How do I paste Excel as an HTML table?
Copy the cell range in Excel, paste it into an excel to html converter, and copy the generated table markup. The paste arrives as tab-separated text, so the tool reads each row and cell automatically. Before copying, format text-like columns (ZIP codes, SKUs) as Text and unmerge any merged cells.
Why does my HTML table lose special characters?
Characters like &, <, and > must be escaped as &, <, and > in HTML. If your converter does not escape them automatically, the browser treats them as markup and the cells render incorrectly or disappear. Always check the generated output for these characters, or run the text through an html entity encoder first.
How do I make an HTML table responsive on mobile?
Wrap the table in a <div> with overflow-x: auto and give the table a min-width so columns stay readable. The wrapper scrolls horizontally on small screens while the table itself keeps its structure. Avoid shrinking the font to force a fit.
Why did my ZIP codes lose their leading zeros?
Excel stored them as numbers, which drops leading zeros before you ever copy. The fix is in the spreadsheet: format the column as Text before copying. No HTML converter can restore zeros that were already removed.
Should I use a table or a list for spreadsheet data in email?
Use a table for genuinely tabular data (prices, specs, schedules) — email clients render basic tables reliably. Keep the total width under 600px and avoid the responsive scroll wrapper, since many email clients ignore it. For single-column data, a simple list is cleaner. Email is the strictest test of an Excel to HTML table — pass it and the web is easy.
Is it safe to paste sensitive spreadsheet data into an online converter?
It depends on the tool. Ours runs entirely in your browser, so pasted cells are never uploaded to our servers. With any other converter, check its privacy policy first — many tools process data server-side even when they do not say so clearly.