MotherDuck for Excel
ExperimentalImport, refresh and write back MotherDuck data from Excel. Sign in with your MotherDuck account, or paste an access token.
Watch the demo
Install
Pick the Excel you use. It takes about a minute.
Excel on Windows
Option 1: installer
- Save your work and close Excel.
- Download the installer and open it.
- Excel starts. Open a workbook, then Home → MotherDuck.
The installer isn't signed yet. Your browser may ask whether to keep the file, and Windows may show a security prompt: choose Keep, then Run (or More info → Run anyway).
Option 2: one command
- Save your work and close Excel.
-
Open PowerShell (no admin rights needed), paste this and press Enter:
irm https://motherduck.com/labs/excel/install/install-windows.ps1 | iex
- Excel starts. Open a workbook, then Home → MotherDuck.
Needs Microsoft 365 Excel version 2002 or later. Both options run the same script, which only saves the add-in's manifest and registers it with Excel for your user; read it first: install-windows.ps1.
Remove it
Close Excel, then run in PowerShell:
irm https://motherduck.com/labs/excel/install/uninstall-windows.ps1 | iex
Excel for Mac
Option 1: installer
- Quit Excel (⌘Q).
- Download the installer, open the zip, then open Install MotherDuck for Excel.
- Excel starts. Open a workbook, then Home → MotherDuck.
The installer isn't signed yet, so macOS blocks it the first time. Choose Done, open System Settings → Privacy & Security, select Open Anyway, then open the installer again. Option 2 avoids this.
Option 2: one command
- Quit Excel (⌘Q).
-
Open Terminal, paste this and press Return:
curl -fsSL https://motherduck.com/labs/excel/install/install-mac.sh | bash
- Excel starts. Open a workbook, then Home → MotherDuck.
Needs Microsoft 365 Excel for Mac 16.35 or later. Both options run the same script, which only copies the add-in's manifest and clears Excel's add-in cache; read it first: install-mac.sh.
Remove it
Quit Excel, then run in Terminal:
curl -fsSL https://motherduck.com/labs/excel/install/install-mac.sh | bash -s -- --uninstall
Excel on the web
- Download the add-in file
- In Excel on the web: Home → Add-ins → More Add-ins → Upload My Add-in, and choose the downloaded file.
- Then Home → MotherDuck.
Uploaded add-ins last for the browser session; upload again next time.
Experimental. An early preview: it can change or break without notice, and sign-in is still being finalized. Write-back changes real tables, so try it on data you can re-create.