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

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • xlite

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

  • dsq

    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

    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

    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

    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

    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

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts