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.
Select the sheet you wish to embed and customise it with the settings below.
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 tile or page looks.
Only available if your View is Framed.
The settings below are only available if your view is Embedded.
Use the table options to format your Sheet
Select Paging - adds paging to your page if you have too many rows to fit the screen size
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.