Awesome Tables is a web application that allows you to turn Google spreadsheet data into easy to filter tables, maps, cards, and more. The Awesome Table documentation will help you create your first table step by step. You might want to look at the example templates on their site first to get an idea of what this application can do!
Once you’ve created your Awesome Table, you can either let people view it on the Awesome Table site or embed it into your Google Site with Insert>Gadget – then search the public gadgets for Awesome Table.
Here is an example table view made by copying the spreadsheet of all the Google Expeditions available to teachers and students.
Here is an example of the Geocode template which creates a Google Map from Spreadsheet Data – this one is on some Famous Iowans.
Here is an example of the Cards template – the Google sheet pulled in all the tweets with our #ghaea hashtag, then Awesome Tables makes it not only sortable and clickable but easy on the eyes!