This past spring, I was having a conversation with Mia Zamora, Alan Levine, and Keegan Long Wheeler about the NetNarr course. Alan was putting together a table for a website that looked really slick, and when I asked what tool he was using, he said Awesome Tables. Four months later, I’m obsessed.
I am particularly susceptible to the charm of Awesome Tables, because I subscribe to the Tom Woodward school of using Google Sheets for everything. Awesome Tables adds a second sheet to a google spreadsheet. This second sheet has cells containing html, css, and js code, all of which format your data into an interactive table. Here’s the table that my Projects page is running:
Here’s the Google spreadsheet driving it. You can see the data on the first sheet and the code on the second.
I’m excited about this stuff for a couple of reasons:
- You can use the second sheet to work through basic website programming with real data and see the results by refreshing the table. I could see using this in a class to teach some basic web coding.
- There are about a dozen pretty nice templates built so it’s easy to quickly turn a spreadsheet into a decent looking database.
There are other ways to build similar tables with bootstrap or even raw html and css, but Awesome Tables is fairly easy to use and embed. The connection between the data and the output is fairly intuitive and easy to manipulate.
By way of example of what you can do quickly and easily, here are a couple of Awesome Tables that I’ve been working on in the last couple of weeks: