formulaDB documentation

formulaDB is an Excel add-in that runs SQL directly from a cell. Name a source with =DB.SOURCE, query it with =DB.QUERY, and the result spills into the grid. DuckDB does the work inside the browser — there’s no upload and no server, so a query can read a remote Parquet file or a local one without the data leaving your machine.

A1: =DB.SOURCE("https://dev-fdb.sumpalabs.com/samples/sales.parquet", "sales")
B1: =DB.QUERY("SELECT region_id, SUM(revenue) FROM sales GROUP BY region_id", A1)

Start here

• How it works — the architecture: DuckDB in the browser sandbox, source cells, remote vs. local, and partitioned datasets.
• Install — get formulaDB into Excel, from AppSource or a pre-release channel.
• Examples — three worked queries: a single remote file, a JOIN across sources, and a worksheet range as a lookup table.

Function reference

• =DB.QUERY — run a SQL query over one or more sources and spill the result.
• =DB.SOURCE — name a source: a remote URL, a local file, or a worksheet range.
• =DB.SCHEMA — list a source’s columns as (name, type) pairs.

Need a hand? Reach us from the support page.