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,619 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

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

  

• visidata

  36 7,409 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,031 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 361 7.7 Python

Suggest a related project