Skip to content

vanemaster-zz/sheetsee.js

 
 

Repository files navigation

Hi!

Sheetsee.js is a javascript library mashup that allows you to fill a website with content from a Google Spreadsheet. The web content and visualizations will update with every auto save by Google. That's cool. No pushing or uploading changes.

It was created and is the intregal part of my Code for America project, See Penny Work. This is a tool-kit for cities to easily visualize budgets and manage the data through a Google Spreadsheet (open data!). Check out the illustrated readme for that project to get a sense of the potential.

Because it was created for my CfA project, it's really customized to that project's needs but I hope to be generalizing it soon. There is all kinds of stuff you can do once you have data in a Google Spreadsheet. I'm also using it on my own website here.

diagram

Set it and forget it.

Once you've hooked up your spreadsheet and your website through sheetsee.js, all you'll need to interact with is the spreadsheet. Think of it as a super simple CMS.

You can view a working sample of the bits in action at jllord.github.com/sheetsee.js/

The bits

It all starts with tabletop.js. With that you can pile on any other library to style and visualize your data.

You can feed d3.js the data it needs to make charts.

You can feed leaflet.js the data it needs to make maps.

Use mustache.js to create templates for the data in your spreadsheet.

More on how to set it up

For now, check out the readme for my CfA project which talks about the set up.

License

This repo is BSD Licensed, read more in license.md.

Updates

4 Oct 2012

I may have done some funky merging, but things appear to be ok.

25 Nov 2012

I've made many changes in sheetsee.js while developing it's parent project (the CfA project mentioned in this readme) and haven't refelcted that in this separate repo - until now! Fresh update with sheetsee.js the way it is in the larger project.

About

visualize data from a google spreadsheet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published