Insert a range of a Google Sheet - new Google Sites
Insert only a select range or even a single cell from a Google Sheet using the htmlembed URL in a new Google Site
Instructions
How to structure the Google Sheets /htmlembed URL
You can use the htmlembed URL to display just a range from a Google Sheet - here's how to structure the URL
https://docs.google.com/spreadsheets/d/SpreadsheedID/htmlembed?single=true&gid=SheetID&range=D15:E15&widget=false&chrome=false&headers=false
SpreadsheedID should be the long letters, numbers and characters you get in the normal URL
htmlembed is for sheets you have not published: use pubhtml instead if you have chosen to publish the sheet (if you want the public to see it it's the best way
single never been sure what it does, but we think it helps with only showing a single sheet instead of multiple sheets
SheetID is the sheet number you get in the normal URL after the ?gid= (this is not the sheet name you have specified but the automatic number that Google Sheets provides)
range lets you specify the range of cells you want to display
widget lets you choose whether to display the sheet tabs at the bottom
chrome lets you choose whether to display the spreadsheet title at the top
headers lets you choose whether to display the column letters and row numbers
Example Google Sheet to embed from
Embedded Ranges from the Google Sheet
A Range
A Single Cell
Feedback
Please let us know if this article helped or if you know of of any improvements.
Keep up-to-date
Join the Sites Update Group on the Google Sites Classic Comparison to get email notifications about New Google Sites updates.
Newsletter
Subscribe to our newsletter for emails about all things Steegle