Visualize Data from a Google Spreadsheet
Sheetsee.js is a client-side library for connecting Google Spreadsheets to a website and visualizing the information in tables, maps and charts.
Modules
Each of sheetsee.js's features are divided into modules. Use just the parts you need; see docs on building. If you don't want to build your own, you can just use the full library which includes all modules, it's here on GitHub.
| Module | Contains | Docs |
|---|---|---|
| sheetsee-core | Included in any build. Gets you started and has the working-with-your-data functions. | Doc |
| sheetsee-tables | Contains everything you'll need to create a table including sortable columns, pagination and search. | Doc |
| sheetsee-maps | For making maps with your point, line or polygon spreadsheet data. Built on Mapbox.js. | Doc |
| sheetsee-charts | Includes 3 basic d3 charts: bar, line and pie. You can also use your own. | Doc |
Spreadsheets!?
Google Spreadsheets can be used as simple and collaborative databases, they make getting a data driven site going much easier than traditional databases. Read more about using spreadsheets for databases here.
In the Wild
What can you make with Sheetsee.js? Lots of things, here are some examples:
List your sheetsee project here: file an issue or pull request.
Resources & Documentation
More resources on using Sheetsee.js:
| Getting Started | Ideas | Use | Demos |
|---|---|---|---|
| About Sheetsee.js | Fork-n-Go | Sheetsee-core | Table Demo |
| Building Sheetsee | Tips! | Sheetsee-tables | Table Demo |
| Basics | Custom charts | Sheetsee-maps | Map Demo |
| Sheetsee-charts | Chart Demo |
Note on New Google Spreadsheets
Google recently updated their Google Spreadsheets and the API. For a bit this was breaking things using the old API, including Tabletop. This has been fixed and the latest version of tabletop.js works on both old and new spreadsheets. Be sure to include at least version 1.3.4 in your project.