Query Google Sheets as virtual tables with SQLite extension – libgsqlite

• libgsqlite

  10 507 0.0 Rust

  A SQLite extension which loads a Google Sheet as a virtual table.

Those setup instructions are so frustrating: https://github.com/0x6b/libgsqlite#setup-google-cloud

Why does this have to be so hard!? I really wish Google Cloud (and likewise AWS and many other providers) didn't force users to jump through so many steps to use tools like this.

• gsheet

  4 67 4.0 Go

  gsheet is a CLI tool (and Golang package) for piping csv data to and from Google Sheets

I wrote a little cli[1] that is a bit easier than curl for getting data to and from google sheets as csv. I do think this sqlite extension would be even more convenient if it supported writing data with INSERT/UPDATE.

1: https://github.com/cristoper/gsheet

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• xlite

  16 1,230 0.9 Rust

  Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite

This project actually started as a fork of https://github.com/x2bool/xlite - SQLite extension for querying .xls and .xlsx spreadsheets.

• steampipe

  146 6,391 9.7 Go

  Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

  

In a similar vein, Steampipe [1] has a Google Sheets plugin [2]. It uses Postgres Foreign Data Wrappers instead of SQLite as the virtual table engine. (Disclaimer: I'm a lead on this open source project.)

1 - https://github.com/turbot/steampipe

• steampipe-plugin-googlesheets

  2 31 6.0 Go

  Use SQL to instantly query spreadsheets, sheets, and cell data from Google Sheets. Open source CLI. No DB required.

  

• grist-core

  52 6,233 9.8 TypeScript

  Grist is the evolution of spreadsheets.

  

Sounds like you're describing Grist! And it's open source. https://github.com/gristlabs/grist-core

Suggest a related project