Steegle logo

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

Example Google Sheet to embed from

Google Sheet

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

Springboard Intranet
for Google Workspace

We provide a well-designed and well-structured intranet to enable your employees to: start work with the right tools; find people with appropriate skills; collaborate with the their teams; access authorized resources; thank and recognize heroic colleagues and coworkers.

Steegle Springboard Intranet for Google Workspace

Steegle People for Google Workspace Logo

Steegle People
for Google Workspace

Searchable staff directory for Google Workspace, with real-time search results, that automatically generates org charts to show your organisation structure - Steegle People.

Steegle People

Steegle Share for Google Drive Logo

Steegle Share
for Google Drive

If the standard Google Drive Folder embed does not give you everything you need, take a look at the Steegle Share for Google Drive that offers search, sorting, download links and more...

Steegle Share

Steegle News Gadget for Google Sites Logo

Steegle News
for Google Sites

Display headlines, snippets and metadata linked to your news articles and blog pages on your Google Site and filter by tags added to the news gadget. See the Steegle News Gadget.

Steegle News

Steegle Heroes
for Google Workspace

Employee recognition system: Steegle Heroes allows you to thank and recognise your colleagues, coworkers and employees spotlight a hero as an Employee of the month.

Steegle Heroes