Smarterware

Exhibit Transforms Your Spreadsheet into an Interactive Web Page

Turn a boring old spreadsheet into an interactive web-based map, timeline, or table with some simple HTML using the free, open source Exhibit project. Exhibit takes data sets up to about 500 rows, plots locations on a Google Map, dates on an interactive timeline, and displays images and links in a tabular or thumbnail view. The viewer can sort, search, and filter data in any Exhibit view without reloading the page. You can make Exhibit do all this with a single HTML file and a spreadsheet--no hardcore programming required.

To try it out, yesterday I threw together my first Exhibit visualization called Broadway Shows I've Seen in the Past 17 Years. Why? Well, I'm looking to get rid of the stack of Playbills gathering on my shelf, but I want to remember what shows I saw and when. So I photographed each Playbill cover (see this Flickr set), entered information about each show into this Google spreadsheet, and plugged the two into Exhibit using HTML and CSS ripped off from other Exhibit examples. Play with it for yourself here, or take a tour of of what it produced below.

Read the rest »