Skip to main content

The excel adapter plugin for dbt (data build tool)

Project description

dbt-excel: Unleash the Power of Excel in Your Data Stack

The ultimate solution for the data-driven world

Welcome to dbt-excel, the revolutionary dbt adapter that combines the rigor of dbt with the flexibility and familiarity of Excel. Get ready to change the way you look at data analytics forever.

dbt-excel logo


  • Integrate Excel with dbt: query data that you didn't know existed, for people who didn't know you existed, all from Excel!
  • Use your favorite Excel functions: VLOOKUP, sheet support, averageif, and more, because life's too short for learning SQL functions.
  • Runs blazingly fast queries thanks to duckdb running in the background, so you can have your cake and eat it too!
  • Monitor your data assets, collaborate on data models, and document your queries, all within Excel. Remember, if it's not in Excel, it's not worth doing!


To install dbt-excel, just run the following command in your terminal:

python -m pip install dbt-excel

Profile setup

The default profile will create a duckdb file in /tmp, of the custom excel type. You can adjust the path if necessary.

  target: dev
     type: excel
     path: /tmp/dbt.duckdb

Running your first DBT Excel model


  1. cd into the dbt_project directory, then run dbt run -s my_first_dbt_model --profiles-dir . this will run the models in the models/example/my_first_dbt_model.sql file.
  2. A Excel file exists in sources/people.xlsx, which will be read and used by the models. The result will be written to first_model.xlsx.
  3. Boom, you just read from AND wrote to Excel!
  4. Savour this moment, it's precious.


Enterprise Architect:

As an Enterprise Architect, I have been involved in countless failed digital transformation projects. They all make the same mistake. They forget one thing: all data lives in Excel. By moving away from enterprise-grade solutions like Excel to complicated stacks based on FivetPython, dbt and XXX, companies neglect their core competence. 1,048,576 rows ought to be enough for anybody. The only digital winners are the companies that build their stack on top of Excel.


Companies worldwide are pouring trillions of dollars into digital transformation. But they forget one thing. In the end, all data lives in Excel. Dbt-excel combines the rigour of software engineering from dbt with the flexibility of Excel. True data democratization starts and ends with Excel.

Anonymous Analyst:

I used to have impostor syndrome working with DBT. With Excel I know I Excel.


Big credits to Josh Wills' excellent DBT Duckdb adapter which inspired this project!

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt-excel-1.4.0rc2.tar.gz (12.8 kB view hashes)

Uploaded Source

Built Distribution

dbt_excel-1.4.0rc2-py3-none-any.whl (13.4 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page