Xlite: Query Excel, Open Document spreadsheets (.ods) as SQLite virtual tables

• xlite

  16 1,230 0.9 Rust

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

• dsq

  20 3,603 4.3 Go

  Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

  

  This is a cool project! But if you query Excel and ODS files with dsq you get the same thing plus a growing standard library of functions that don't come built into SQLite such as best-effort date parsing, URL parsing/extraction, statistical aggregation functions, math functions, string and regex helpers, hashing functions and so on [1].

  [0] https://github.com/multiprocessio/dsq

  [1] https://github.com/multiprocessio/go-sqlite3-stdlib

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

  

• visidata

  36 7,388 9.8 Python

  A terminal spreadsheet multitool for discovering and arranging data

  Sweet. Here’s my open issue with VisiData about this: https://github.com/saulpw/visidata/issues/1398

  There’s a sample file at the end of that thread.

• advanced-formula-environment

  3 103 0.0

  Create, edit, and reuse formulas in Excel

  

  Do you have a workaround workflow in the meantime? I could imagine a few non-Macro or Macro-light solutions to this. Use a pivot table for example, the results of which I believe get 'magiced' into their destination cells instead of getting hidden, I however don't recall whether they auto-inherit autofilters set on the source table.

  How much organizational (not technical, we'll get to that) control/authority/input/stakeholder role do you have on the source document templates?

  Also, you might want to check out https://github.com/microsoft/advanced-formula-environment/

• textql

  15 9,028 3.7 Go

  Execute SQL against structured text like CSV or TSV

  Somewhat-kinda related, the textql extension for Asciidoctor is so dang useful it should be in core.

  https://gist.github.com/mojavelinux/8856117

  I use this as a "centralized parts repository" for big ol' maintenance manuals. Refresh from PDM/PLM/LSA/Whatever. Rebuild for new parts data.

  Built on TextQL, natch

  https://github.com/dinedal/textql

• cppyy

  1 357 7.7 Python

Suggest a related project