Embedding a Google Sheet
Create a web page from the content of a Google Sheet, including the ability to directly embed any columns - making it easy to summarise content from a larger sheet - so users only see the data that they need to.
Open Page Settings > Page Type and choose Google Drive. Select the sheet you wish to embed and customise it with the settings below. TIP: The picker will show you all file types in Drive, to narrow down to just Sheets click the down arrow and choose Filetype: Spreadsheets.
The default is All Sheets, this will show all your sheets (tabs) within the selected Spreadsheet. Alternatively you can choose which Sheet (tab) you wish to embed.
The default is Framed which will show your sheet in a frame exactly as it is in Google Sheets, you can then choose to show it in Read Only or Edit Mode (see below).
If you want to create a web page from the selected Sheet, change the View to Embedded. This will take the content of your Sheet and store it as html on the site, you can use the settings below to change the way your page looks.
Only available if your View is Framed.
- Read Only - shows the sheet without any top menu, users can choose Switch to Edit mode (if they have access) via the Page Menu
- Edit - shows the sheet with all menus (you can uncheck Show Menus to remove these)
The settings below are only available if your view is Embedded.
- Preserve Formatting - use the Google Sheet formatting, eg cell and font colors; font formats and sizes
Use the table options to format your Sheet
- Bordered - add a border to your embedded sheet
- Condensed - condense the rows in the sheet
- Full Width - make the sheet full width
- Striped - add a stripe to every other row for ease of viewing
- Hover - add a stripe when the viewer hovers over each row
- Sort - make each column sortable - viewers can click on the column headers to sort by that column
- Filter - add a filter box at the top of the sheet so viewers can filter the data
- Paging - adds paging to your page if you have too many rows to fit the screen size
- Responsive - adds a hover showing the columns that don't fit the screen width
Select which columns to display from the chosen Sheet. OverDRIVE allows you to only display the content that is relevant, it's a great way to share key content from a large spreadsheet without having to hide or protect columns in a Sheet.
If you have checked Sort from the Tables section above you can choose a sort order for your embedded sheet. Click the Arrow to change between Descending and Ascending.
You can freeze the first 1 - 4 rows of your sheet and the last 1 - 4 rows; you can also freeze the first 1 - 4 columns. The last row of the Header freeze will be the "header" for sorting purposes.
Choose to allow users to select which columns they wish to see and add front end functionality including the ability to copy to clipboard, print the sheet or save as a pdf.