Show HN: Query Your Sheets with SheetSQL

• steampipe

  147 6,500 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.0 Go

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

  

• InfluxDB

  www.influxdata.com featured

  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 313 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 660 9.9 Ruby

  🔥🔥🔥 Open Source Alternative to Hightouch, Census, and RudderStack.

  

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

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

• ImportExcel

  98 2,380 6.7 PowerShell

  PowerShell module to import/export Excel spreadsheets, without Excel

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• rclone

  963 44,311 9.8 Go

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

  

• PowerShell-Docs

  10 1,906 9.7 PowerShell

  The official PowerShell documentation sources

  

Suggest a related project