Use Google Sheets in Sites
Google Sheets dynamically brings data into Google Sites for powerful insights.
🔥Get Awesome Google Sites Templates!
Google Sheets dynamically brings data into Google Sites for powerful insights.
There are several methods available for embedding your Google Sheets on a Google Sites website.
The benefit of this method is that Sheets can be private, restricted or shared only in your Workspace domain. Users without view or edit permissions will see a screen which prompts them to login or request access from the document owner. Here's how to add your Google Spreadsheet to your website:
In edit mode on your Google Site select Insert > Sheets
Select your Sheet from Google Drive
The only setting available is to select the default tab displayed on load
Inserting a Google Sheet on Google Sites can sometimes look clunky. Customization settings are limited. This way of inserting a Google Sheet allows for adding parameters which will change the look of your embedded view. For instance, you can remove the frameborder and headers for a cleaner look to your iframe widget. You can also remove the appearance of multiple tabs that appear by default.
To publish a Google Sheet and receive an iframe code snipper, go to File > Share > Publish to Web.
Here are the available parameters to add on your published sheet URL:
rm=minimal
rm=full
rm=embedded
rm=demo
rm=(render mode)
ui=2 (select the interface version)
chrome=false (full screen mode)
frameborder=(size of border)
q=(Whatever) Search Query
gid=24 (Which sheet you want to display)
widget=false
single=true
range=A2:AA26
Output=html format=(export spreadsheet)
format=xlsx
format=csv
widget=false
width=(width)
height=(height)
viewer?
start=
channel=
ibd=
client=
Example Code with no frame, bounding box, headers, sheets tabs or scrollbars (vertical and horizontal)
<iframe overflow="hidden" scrolling="no" frameBorder="0" width="100%" style="overflow:hidden;border:0;" border="0" height="100%" src="https://docs.google.com/spreadsheets/d/e/2PACX-1vTGkYXLTU6FW1aoqUxaOAWwDbp1A2BFYqDKxDajQ72T_XTa92PkwtmYgArQL4Nx5I0eCVUU2EKIqOo8/pubhtml?widget=false&headers=false&chrome=false&rm=minimal;frameborder=0"></iframe>