Products SEO & GEO Agent Paid Ads Agent Website Agent Conversion Agent
How it works Pricing FAQ Blog Book a call

Spreadsheet to HTML table: how to convert one for your site

Updated · 7 min read

Want help applying this to your business? Talk it through on a free 30-minute call.

Book a call

Copy, convert or embed: which one fits your table?

Choose by how often the numbers change. A copied or converted table is a snapshot: real text on your page that you redo whenever prices move. An embed is a live window into the spreadsheet itself.

MethodGood forThe catch
Paste into your website builder's table toolShort tables that change a few times a yearYou paste again after every change
A free converter that writes HTML (the code web pages are made of)Any site with an HTML or code blockMerged cells and colors may not survive; your theme restyles it
Excel's Save As Web Page, or Google Sheets' zipped web page downloadHosting a whole page yourselfYou get a full page plus a folder of files, not just a table
Publish the sheet and embed it (Google Sheets, or OneDrive for Excel)Timetables, stock lists, anything updated weeklyIt's public, in a frame styled by Google or Microsoft

On embeds, Google's help page says:

"Any changes you make to the original document will be updated in the published version. The automatic update might take a few minutes." (Google Docs Editors Help: Make Google Docs, Sheets, Slides & Forms public)

Three things make it less simple:

Get the spreadsheet ready first

  1. One header row. A short label over each column, nothing above it.
  2. No merged cells. Repeat the label in each cell, or split the table in two.
  3. Delete what customers shouldn't see. Cost, margin and staff notes go; a converter copies whatever you select.
  4. Write values as customers read them: "$1,250", not internal codes.
  5. Fewer columns. A phone shows only a few. Service, price and one note is often enough.

How to add it in WordPress, Squarespace and Wix

Website builderEasiest routeWatch for
WordPress (block editor)Copy the cells and paste them into a page; the editor turns a pasted table into a Table block, merged cells includedSince version 6.6, "Fixed width table cells" is on by default, making all columns equal; turn it off if one column holds long text
SquarespaceAdd a Code block, set its Mode to HTML, paste the converter's codeMarkdown table syntax "renders without borders or column spacing"; an embedded sheet is an iframe (a frame showing another site's page), which needs the Core, Plus or Advanced plan
WixSave the sheet as CSV (plain text, one row per line), import it into a CMS collection (Wix's built-in database), add a table from Add Elements and connect itWix's embed elements are iframes, so embedded code "won't be responsive" (won't resize for phones); the Wix Harmony editor can't connect a table to a collection
Any other builderA table element, or an HTML or code blockPreview on a phone first

With a converter, the steps are the same everywhere:

  1. Copy the range in Excel or Google Sheets.
  2. Paste it into the converter. TableConvert is free, takes files up to 10 MB and says "your data never leaves your device" because it converts in the browser. Tableizer is a paste box with font and header-color options. HTML Tables takes a CSV upload, so save a Google Sheet as CSV first.
  3. Mark the first row as headers. If your site already styles tables, skip the converter's CSS (the code that sets colors, borders and spacing); Tableizer has a "No CSS" box.
  4. Paste the HTML into your site's HTML or code block, then preview.

A static table needs no paid software. SpreadsheetConverter, an Excel add-in from US$15 a month ($153 a year billed yearly), is built for turning workbooks into web calculators and forms.

Make the table readable on a phone

Let the table scroll sideways inside its own box while the rest of the page stays still. WCAG, the W3C's accessibility guidelines, expects pages to fit a screen 320 pixels wide without sideways scrolling, but lists "data tables (not individual cells)" among the exceptions:

"It is acceptable to provide two-dimensional scrolling for such parts of the content." (W3C: Understanding Success Criterion 1.4.10 Reflow)

How you get that box:

Put the column people scan first, usually the service name, on the left.

Header cells, a caption, and no screenshots

Screen readers, software that reads a page aloud, announce a table one cell at a time with its headers. The W3C's tables tutorial says:

"Accessible tables need HTML markup that indicates header cells and data cells and defines their relationship." (W3C WAI: Tables Tutorial)

Embedding a live sheet: what the public sees

In Google Sheets: File, Share, Publish to web, Embed, choose the one sheet, Publish, then paste the code into your site. Before you do:

For Excel, save the workbook to OneDrive, open onedrive.com, select the file, then More options, Embed, Generate. Microsoft's note:

"Anyone who visits the webpage with this embedded file will be able to view it without signing in." (Microsoft Support: How to add an embedded document or picture into a webpage)

Example

Illustrative cases with invented numbers.

A plumber's price list on WordPress (US dollars)

Twelve services in three columns: service, starting price ($150 to $1,200) and what's included. He pastes the price rows from Google Sheets into a page, switches on the header section and types the three labels into it, turns off fixed-width cells so the long column gets more room, and adds the caption "Standard prices". Prices change twice a year, so re-pasting is fine.

A yoga studio's timetable on Squarespace (Canadian dollars)

Classes change weekly and a drop-in costs $25. The owner publishes only the Timetable tab and embeds it in a Code block; the site is on the Core plan, so the iframe works. Instructor pay lives in a separate file, so nothing private is published.

A cleaning company's rates on Wix (US dollars)

Eight columns are unreadable on a phone. The owner cuts to three (service, starting rate from $120, typical hours), saves a CSV, imports it into a CMS collection and connects a Wix table.

FAQ

Can I paste an Excel table straight into my website editor?

In WordPress's block editor, yes: it becomes a Table block. Other editors may paste plain text, so preview, or use a converter.

Does an embedded Google Sheet update by itself?

Yes, while "Automatically republish when changes are made" is ticked under Published content & settings. Updates can take a few minutes. Untick to freeze it.

Why does my table look different on my site than in the converter?

Your theme applies its own fonts, borders and spacing. WordPress says "The final appearance of the table may vary depending on your theme."

Is it safe to paste customer data into an online converter?

TableConvert says it converts in your browser and stores no files on its servers. Still, keep customer data off any public table.

Different for you?

Keep learning

NextWebsite redesign for conversions: more leads from less trafficPlan a website redesign that turns more visitors into calls and bookings while Google sends fewer clicks, without losing the search traffic you still get.

Ask us one question

One line is enough. We reply by email.

Sources

  1. Google Docs Editors Help: Make Google Docs, Sheets, Slides & Forms public
  2. Google Drive API: Export MIME types for Google Workspace documents
  3. Microsoft Support: Save all or part of a workbook to a static web page
  4. Microsoft Support: How to add an embedded document or picture into a webpage (OneDrive)
  5. WordPress Documentation: Table block
  6. WordPress Gutenberg source: Table block paste rules
  7. WordPress Gutenberg source: Table block header toggle
  8. Squarespace Help: Add custom code to a page with code blocks
  9. Squarespace Help: Markdown cheat sheet
  10. Wix Help: CMS: Displaying Collection Content in a Table
  11. Wix Help: Wix Editor: Embedding a Site or a Widget
  12. W3C WAI: Tables Tutorial
  13. W3C WAI: Tables Tutorial, Caption & Summary
  14. W3C: Understanding WCAG 2.2 Success Criterion 1.4.10 Reflow
  15. W3C: Understanding WCAG 2.2 Success Criterion 1.4.5 Images of Text
  16. MDN Web Docs: overflow-x
  17. Bootstrap 5.3 documentation: Tables
  18. Bootstrap 3.4 documentation: CSS (responsive tables)
  19. TableConvert: Excel to HTML Table Converter
  20. Tableizer: Spreadsheets to HTML Tables Tool
  21. HTML Tables: HTML Table Generator
  22. SpreadsheetConverter: Version 12 pricing