Excel Table in an Email Newsletter — Convert to HTML First

You have a table in Excel — pricing, schedule, feature comparison, stats — and you want it in your email newsletter. Copy-pasting from Excel into your email platform looks fine in the editor. Then you send a test and it is a mess: columns misaligned, formatting stripped, some clients showing plain text, others showing broken borders.

The fix is converting your Excel table to HTML before pasting it into your email. HTML tables are what email clients actually understand. This guide shows how to do it free in under two minutes using a browser-based converter, and which email platforms accept the result.

Why Copy-Paste From Excel Breaks in Email

When you copy cells from Excel and paste them into an email editor, one of two things usually happens:

The editor pastes as a table — but it is using the editor's internal table format, which may rely on CSS classes, external stylesheets, or table attributes that get stripped when the email renders in Gmail, Outlook, or Apple Mail. The result looks correct in the drag-and-drop editor, but breaks in the actual email client.

The editor pastes as plain text — columns separated by spaces or tabs. All alignment and structure is gone.

Email clients are not browsers. They do not load external CSS files. Many of them (especially Outlook on Windows) strip or ignore CSS that is not inlined directly on each HTML element. This is a decades-old limitation of email rendering that even modern email clients still carry.

HTML tables with inline CSS bypass all of this. Instead of relying on a stylesheet, every style property is written directly on the element where it applies — style="background-color: #f9f9f9; padding: 10px;" directly on the td tag, for example. This syntax survives the rendering process in every major email client.

Convert Your Excel Table to HTML in 60 Seconds

The Excel to HTML converter reads your Excel file and outputs a complete table with inline CSS on every element. Here is the process:

1. Open your Excel file and make sure the table data is clean — column headers in row 1, data in subsequent rows, no merged cells if you can avoid them
2. Save the file
3. Open the converter and drag your file onto it
4. Select the sheet containing your table if the workbook has multiple sheets
5. Choose a table style — Striped works well in most newsletter contexts: clean, readable, professional
6. Click HTML Code to see the markup
7. Click Copy HTML

You now have inline-CSS HTML table code on your clipboard, ready to paste into your email platform's HTML editor.

Sell Custom Apparel — We Handle Printing & Free Shipping

Pasting Into Your Email Platform — Platform by Platform

ConvertKit — In the email editor, add a Custom HTML block (click the + button, choose Custom HTML). Paste your table code into the block. Click Save. Preview in multiple clients before sending.

Beehiiv — Switch to the HTML editor view (look for the brackets icon or "Code" option in the editor toolbar). Place your cursor where you want the table, paste the HTML. Switch back to visual view to confirm it renders correctly.

Klaviyo — In the email template editor, add an HTML block. Open the block's source editor and paste your table code. Preview the email to check rendering across clients.

Mailchimp — In the drag-and-drop editor, add a Code block. In the code block editor, paste your HTML table. Mailchimp does allow inline styles and basic table HTML, so this approach works reliably.

Substack — Substack's editor has limited HTML support. You cannot insert arbitrary HTML into a Substack post. A workaround is to take a screenshot of the Excel table and embed it as an image, or link to a page where the table is displayed. This is a Substack limitation, not a converter limitation.

ActiveCampaign, HubSpot, Campaign Monitor — All support HTML blocks. The pattern is the same: find the HTML or Code block option, paste your table, preview before sending.

Why Inline CSS Is the Correct Format for Email

External stylesheets (link rel="stylesheet" href="...") are ignored by most email clients. Style blocks in the head are stripped by Gmail and some others. Only inline styles — written directly on each element — are reliably preserved across email clients.

The converter's output handles this for you. Every style property that controls the table's appearance is applied inline on the element it affects. When Gmail strips the head section of your email's HTML before displaying it to the recipient, the table still looks correct because the styles are embedded on the elements themselves.

This is also why copying a styled table from a website does not work in email — web pages rely on external stylesheets that email clients never load.

One thing to keep in mind: Outlook on Windows uses Microsoft Word's HTML rendering engine, not a browser engine. Word has limited CSS support even for inline styles. Properties like border-radius, box-shadow, and CSS gradients do not work in Outlook. The converter's table styles stick to basic properties — colors, borders, padding, font sizes — that work across all clients including Outlook.

Tips for Tables That Look Good in Every Inbox

Keep column counts reasonable — email viewports are typically 600px wide. A table with more than 5-6 columns will overflow on mobile. If you have a wide table, consider splitting it into multiple simpler tables or summarizing the data differently for email.

Avoid merged cells — email clients handle merged cells inconsistently. A table where each row has the same number of cells renders the most reliably. If your Excel table uses merged header cells for visual grouping, restructure it to use separate rows with clear labels instead.

Use Striped or Bordered styles for data-heavy tables — plain tables without visual separation are hard to read in an email context where the reader cannot zoom in or scroll. Striped rows or visible borders make the structure immediately clear.

Test in multiple clients before sending — if you are sending to a large list, test your HTML email in Gmail (web and mobile), Outlook, and Apple Mail at minimum. Most major ESPs (email service providers) offer built-in inbox preview tools. Litmus and Email on Acid are third-party options if your ESP does not include previewing.

Consider the table's purpose — a feature comparison table or pricing grid works well in email. A 50-row data export does not. If the table is primarily for reference, consider linking to a web page where readers can view it in a proper browser context instead.

Frequently Asked Questions

Will the table look the same in dark mode email clients?

Dark mode in email clients inverts or adjusts colors automatically, and behavior varies by client. The converter's Dark style is designed for dark backgrounds, but when email clients apply their own dark mode transform, even light-background tables may be adjusted. For maximum consistency, test your specific table style in dark mode before sending to your list.

Can I add links inside table cells?

Not directly through the converter — it outputs the cell values from your Excel file. If you need hyperlinks in specific cells, you can add them manually to the HTML code after copying it from the converter. Locate the td element for the relevant cell and wrap the text in a standard anchor tag with an href attribute.

My table is too wide for mobile. What should I do?

Wide tables are a common email challenge. Options: reduce the number of columns by combining data or abbreviating labels; use a smaller font size (reduce the font-size inline style on td elements); or consider an image of the table instead — images scale predictably on mobile, though they have accessibility trade-offs.

What is the difference between this and the Mailchimp-specific guide?

The Mailchimp guide covers using the converter specifically with Mailchimp campaigns and discusses Mailchimp-specific block types and settings. This guide covers the broader email newsletter context — multiple platforms, the reasoning behind inline CSS, and tips for making tables readable across all inboxes.