Awesome Table was an add-on that made sharing information from a spreadsheet very easy in the old Google Sites. Guess what? You are able to insert an Awesome Table in the New Google Sites! This is a dynamic way to share spreadsheet data - even data that changes often - and make it searchable for visitors to your website.
Make your spreadsheet of data:
Look like this on your website:
Step 1: Set up your spreadsheet
Make your spreadsheet of data:
Look like this on your website:
Step 1: Set up your spreadsheet
Here are their directions for setting up the spreadsheet:
The basics - create your spreadsheet, making sure each column has a header at the top. Add a second header row that sets up the filters and keywords - these tell Awesome Table how to display your spreadsheet.
Step 2: Connect the Aweome Table service with your Google Account
Once you set your spreadsheet up, you will need to log into this site with your Google Account:
Step 3: Build an Awesome Table view using their web app
Here are their directions in how to build a view to use on your website:
Basically you are identifying the spreadsheet, sheet and data range to use for the website.
Step 4: Add the link to your new Google Site
Here is how to add it to a webpage on your site:
Finally, you are sharing your spreadsheet and then using the URL to embed the link on your site. Google Sites converts it into a widget, giving you a look at the live data.
Submitted by:
Melinda Waffle
Calhoun ISD
REMC 12E
Comments
Post a Comment