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.
| Method | Good for | The catch |
|---|---|---|
| Paste into your website builder's table tool | Short tables that change a few times a year | You 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 block | Merged cells and colors may not survive; your theme restyles it |
| Excel's Save As Web Page, or Google Sheets' zipped web page download | Hosting a whole page yourself | You 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 weekly | It'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:
- Merged cells. The W3C, which sets the web's accessibility standards, notes that table structure "is often lost when converting from one format to another".
- Formulas. Visitors get results only. Google says viewers of a published sheet see "the values of cells, but can't view or edit formulas".
- Other tabs. Google lets you publish "the entire spreadsheet or individual sheets". Pick the one tab you mean to show.
Get the spreadsheet ready first
- One header row. A short label over each column, nothing above it.
- No merged cells. Repeat the label in each cell, or split the table in two.
- Delete what customers shouldn't see. Cost, margin and staff notes go; a converter copies whatever you select.
- Write values as customers read them: "$1,250", not internal codes.
- 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 builder | Easiest route | Watch 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 included | Since version 6.6, "Fixed width table cells" is on by default, making all columns equal; turn it off if one column holds long text |
| Squarespace | Add a Code block, set its Mode to HTML, paste the converter's code | Markdown 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 |
| Wix | Save 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 it | Wix'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 builder | A table element, or an HTML or code block | Preview on a phone first |
With a converter, the steps are the same everywhere:
- Copy the range in Excel or Google Sheets.
- 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.
- 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.
- 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:
- Converter or hand-written code: wrap the table in a container whose CSS sets overflow-x: auto. MDN's CSS reference says browsers then show scroll bars only when the content overflows.
- Bootstrap sites (a popular design toolkit): add the table-responsive class. In Bootstrap 5.3, the current release, it scrolls "across all viewports"; table-responsive-md and similar scroll only below a set width. The "under 768px" rule you may read elsewhere is Bootstrap 3's.
- Website builders: themes differ, so check on a real phone. If columns are crushed, cut columns.
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)
- Header row. In WordPress, switch on "Header section" in the Table block's settings. It adds a new empty top row: type the labels there and delete the pasted label row. In a converter, tick the header option. The code then uses th (header) cells, not td (data) cells, for that row.
- Caption. A one-line title such as "Standard prices, 2026". The W3C says "A caption functions like a heading for a table." WordPress's toolbar has a caption button.
- No picture of the spreadsheet. WCAG says that when the technology can produce the look, "text is used to convey information rather than images of text". A screenshot can't be read aloud, and people who need larger text or other colors can't change it.
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:
- Google's warning: "Be careful when publishing private or sensitive info."
- On a work or school account, your administrator may have turned publishing off.
- Setting headers to false in the embed code hides row numbers and column letters.
- Deleting the code from your site isn't enough: "To remove a file from the web, you must stop publishing it." That's under Published content & settings.
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?
- The whole site has to work for screen readers and keyboards: ADA website compliance.
- You're choosing or leaving a website builder: Wix, Squarespace or WordPress for SEO.
- The page with the big table loads slowly: Core Web Vitals and website speed.
- Visitors read your prices but don't call: Website not getting leads.
- You'd rather have the pages built and kept current for you: Website Agent.