About
Show a Google Sheet on your screens: sales figures, appointments, schedules and more, always up to date. Publish the sheet to the web and show it with our Website plugin, or just a range of cells. For text from a sheet in your own design, use Dynamic Text.
Get Started
Show a sheet on a slide
- In Google Sheets, choose File → Publish to web
- Copy the public link
- In the Play editor, add the Website plugin and paste the link
Show only some cells
- In Publish to web, choose one sheet instead of Entire document
- Add
&range=A1:B2(your range) to the end of the link, for example:
https://docs.google.com/spreadsheets/d/e/2PACX-1vRs4_Mn9efvvzTMYSB6is2IhURXp45aeDGImPHixMuJ0OkQ1OvwuHhPB2MjHHVneYMGZ4U_a-GzE4vG/pubhtml?gid=0&single=true&range=A1:B2Show an Excel sheet from Microsoft 365
- In Excel online, choose File → Share → Embed and click Generate
- Copy the address inside
src=""of the code, and paste it in the Website plugin
Show sheet data in your own design
Use Dynamic Text to show a cell, a range or the whole sheet as text you style yourself, like a menu with prices. On the Pro and Ultimate plans.
Options
Click the Website plugin on the slide to see these.
| Option | What it does |
|---|---|
| Alignment and Cropping | Fit to canvas, align left, center, right, top, middle or bottom, and lock |
| Website | The address of the page to show |
| HTML code | Paste an HTML snippet instead. Where to find widgets |
| Pre-load website | Starts loading 15 seconds early so it’s ready. Turn it off for pages with an intro animation or autoplay video |
| Enable scrolling | Off by default (no scroll bar). Turn on to let people scroll on a touch screen |
| Refresh periodically | Reloads while the slide shows, besides each time the slide starts |
| Refresh Interval Seconds | Seconds between reloads |
| Zoom | Makes the page fit better |
| Positioning | Place it pixel by pixel |
| Sizing | Set its size in pixels |
| Add Script | Add scripts, for example to log in or click. See Website Scripting |
FAQ
Can I change how the table looks?
Google doesn’t offer that. Use Dynamic Text for your own design, or a service like Awesome Table.
