finds.dev← search

// the find

jlord/sheetsee.js

★ 3,110 · JavaScript · NOASSERTION · updated Aug 2024

:eyes: :chart_with_upwards_trend: Visualize Data from a Google Spreadsheet

Sheetsee.js turns a Google Spreadsheet into the data source for a static site — sortable/paginated tables (via Mustache.js) and maps (via Leaflet.js) with no backend of your own. It's aimed at people who want a non-technical, spreadsheet-editable data layer for a simple site, not developers building a real data app.

Split into independent modules (core/tables/maps) so you can build a custom bundle with only what you need instead of shipping the whole thing. Using a Google Spreadsheet as the data source means non-technical collaborators can edit content directly without touching code or a CMS. Docs are actually written out as separate pages (basics, building, templates, tips) rather than crammed into one readme, so onboarding has a real path.

Packaging is bower-based (bower.json, no npm-installable package for the compiled library), and bower has been dead since ~2017, so wiring this into a modern build is manual work. The real code and issue trackers live in four separate repos (sheetsee-core, sheetsee-tables, sheetsee-maps, sheetsee), so bugs filed here mostly won't get attention. No visible tests in the tree, and the library predates the current Google Sheets API/publish-to-web model, so getting a spreadsheet actually recognized as a data source may need workarounds Google has changed multiple times since this was written.

View on GitHub →

// want more like this?

We dig through GitHub every week and send a few repos picked for what you actually care about — each with an honest take like this one.

Get finds in your inbox → Search again →