Here’s a working test of Sheetsee by Jessica Lord, a utility which allows a Google spreadsheet to be used as the data source for a D3 visualization. You can find complete information about Sheetsee here: https://github.com/jlord/sheetsee.js/ and here: http://jlord.us/sheetsee-3/.
Jessica has made some simple tutorials here:
Likewise, she has some nice demos:
Ok, down to business. Suppose I have a Google spreadsheet — in this case, I have some Lat/Long data for a bunch of locations associated with ID numbers:
Here’s the HTML I used in this WordPress page to achieve this. I’ve included this as an image to avoid character formatting problems (view-source to get text):
Incidentally, an alternative approach would be to host the visualization elsewhere and include it through an iFrame. I’ve done that below, with the same visualization hosted at http://flong.com/temp/misc/sheetsee/golan.html. You’ll note that the behavior and appearance are worse in the locally-stored version (above); this seems to be the result of conflicts with the WordPress CSS. (In the iFrame version below, it’s possible to see the nice Leaflet hover-overs.)
So why not just use the iFrame version? Well, it requires you to have a host somewhere else, and keep it maintained.