Show HN: Query Your Sheets with SheetSQL

• steampipe

  146 6,391 9.7 Go

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

  

Readers may also enjoy Steampipe [1], an open source CLI to live query Google Sheets [2] and 140+ other services with SQL (e.g. AWS, GitHub, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc across the services. (Disclaimer - I'm a lead on the project.)

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

• steampipe-plugin-googlesheets

  2 31 6.1 Go

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

  

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• flowpipe

  3 276 9.9 Go

  Flowpipe is a cloud scripting engine. Automation and workflow to connect your clouds to the people, systems and data that matters.

  

• libgsqlite

  10 507 0.0 Rust

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

There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)

• xlite

  16 1,230 0.9 Rust

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

There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)

• multiwoven

  16 617 9.9 Ruby

  🔥 Open Source Reverse ETL and Customer Data Platform (CDP). An open-source alternative to Hightouch, Census, and RudderStack.

  

(https://github.com/Multiwoven/multiwoven)

All the best & I'll watch your repo :)

• ImportExcel

  98 2,361 5.3 PowerShell

  PowerShell module to import/export Excel spreadsheets, without Excel

• 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.

  

• rclone

  963 43,720 9.8 Go

  "rsync for cloud storage" - Google Drive, S3, Dropbox, Backblaze B2, One Drive, Swift, Hubic, Wasabi, Google Cloud Storage, Yandex Files

  

• PowerShell-Docs

  10 1,884 9.6 PowerShell

  The official PowerShell documentation sources

  

Suggest a related project