THREDrDB

THREDrDB is an integrated database add-in for Microsoft Excel that empowers users to run SQL queries and API calls directly within their spreadsheets. Built for business analysts, engineers, financial professionals, and power users, THREDrDB brings advanced data management and automation to Excel—no complex setup or external tools required.

THREDrDB’s data loading and querying are fully integrated with Excel’s calculation engine. Using asynchronous custom functions, data flows seamlessly between Excel sheets and a high-performance SQLite backend, always aligned with Excel’s native workflows. This enables real-time updates, responsive interfaces, and highly dynamic spreadsheets.

A unique volatile query function unlocks iterative and recursive logic without triggering circular reference errors. This makes THREDrDB especially powerful in modeling scenarios where traditional Excel logic falls short—such as engineering calculations, portfolio rollups, and recursive financial formulas.

The built-in clock function enables continuous loops and timed refreshes of API results and dependent logic. With it, you can build real-time dashboards, dynamic charts, or scheduled workflows with minimal effort.

Key capabilities include:

- Querying, filtering, and joining spreadsheet data using SQL

- Importing external API data directly into Excel tables

- Seamless CSV import and export

- Live, self-updating spreadsheets driven by clock-triggered functions

- Circular logic support through VOLATILEQUERY

- A user-friendly interface designed for all skill levels

All THREDrDB features are currently free of charge. No license, subscription, or purchase is required to use the add-in at this time. Please note, however, that pricing and licensing terms are subject to change in the future.

THREDrDB is ideal for anyone seeking to automate workflows, integrate live data, or build advanced models directly in Excel—while keeping performance, flexibility, and control at their fingertips