Skip to content
formulaDB

Install

formulaDB is an Excel add-in. It runs in Excel on the web and Excel desktop (Windows and Mac). Custom functions like =DB.QUERY require a reasonably recent build of Excel.

From AppSource

Section titled “From AppSource”

The simplest path:

  1. In Excel, open Home → Add-ins (or Insert → Add-ins).
  2. Search for formulaDB.
  3. Choose Add.

The =DB.QUERY, =DB.SOURCE, and =DB.SCHEMA functions become available across your workbooks, and the task pane opens from the ribbon.

Verify the install

Section titled “Verify the install”

In any cell, type:

=DB.

The DB.QUERY, DB.SCHEMA, and DB.SOURCE functions appearing in the formula autocomplete confirm the add-in loaded. Then head to Examples to run your first query, or read How it works for the architecture.