Google Sites Help
Steegle

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

Share via Twitter
Share via Google+
Share via LinkedIn
Share via Facebook

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 spreadsheet title at the top

Example Google Sheet to embed from

Google Sheet

Embedded Ranges from the Google Sheet

A Range

A Single Cell

Keep up-to-date

Join the New Google Sites Update Group to get email notifications .

Newsletter

Subscribe to our newsletter for emails about all things Steegle