formulaDB

formulaDB brings the power of SQL to Excel. Query remote Parquet and CSV datasets, or tables right inside your workbook, directly from a cell and get the results spilled back into the grid.

No imports. No row limits from copy-paste. No leaving the spreadsheet.

Key features

• Query with SQL from a cell: =DB.QUERY("SELECT * FROM wells WHERE oil > 100", source) spills the result directly into your worksheet, headers and all.
• Read data where it lives: point at a remote Parquet or CSV file by URL, a partitioned dataset, a local file you pick, or a range already in your workbook. No uploading or importing required.
• Join across sources: combine a remote dataset with a local file or an in-sheet table in a single query.
• Inspect before you query: =DB.SCHEMA(source) returns the column names and types of any source.
• Powered by DuckDB-WASM: a full analytical SQL engine runs locally inside Excel. Your data is read directly from the source and is never sent to a third-party server.
• No account, no sign-in, no subscription: formulaDB works immediately on install. There is nothing to register for and no credentials to manage. All functionality is available to every user out of the box.
• Live and reactive: queries recalculate automatically through Excel's formula graph when your sources or filters change.

Who it's for

Analysts, data scientists, and anyone who works with large or remote datasets and wants to explore them with SQL without first loading everything into a sheet.

Getting started

1. Add a source: =DB.SOURCE("https://example.com/data.parquet", "data")
2. Query it: =DB.QUERY("SELECT * FROM data LIMIT 100", A1)

The results spill into your sheet, ready to chart, pivot, or reference like any other Excel range.

Support & contact

Questions or issues? Reach the formulaDB team at hello@sumpalabs.com or visit sumpalabs.com/contact.