MotherDuck for Excel

Experimental

Import, refresh and write back MotherDuck data from Excel. Sign in with your MotherDuck account, or paste an access token.

Watch the demo

80 seconds · no sound

Install

Pick the Excel you use. It takes about a minute.

Excel on Windows

Option 1: installer

  1. Save your work and close Excel.
  2. Download the installer and open it.
  3. 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

  1. Save your work and close Excel.
  2. Open PowerShell (no admin rights needed), paste this and press Enter:
    irm https://motherduck.com/labs/excel/install/install-windows.ps1 | iex
  3. 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

  1. Quit Excel (⌘Q).
  2. Download the installer, open the zip, then open Install MotherDuck for Excel.
  3. 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

  1. Quit Excel (⌘Q).
  2. Open Terminal, paste this and press Return:
    curl -fsSL https://motherduck.com/labs/excel/install/install-mac.sh | bash
  3. 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

  1. Download the add-in file
  2. In Excel on the web: Home → Add-ins → More Add-ins → Upload My Add-in, and choose the downloaded file.
  3. 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.