Install the Excel Add-in
Install the add-in from Microsoft AppSource, sign in from the Dividend Data ribbon tab, and run your first formula.
Setup takes about two minutes: install, sign in, type a formula.
Install from AppSource
- Open the Spreadsheets hub and click the Microsoft Excel card — a guided setup opens with a one-click install link to the add-in's listing on Microsoft AppSource. You can also install from inside Excel through the built-in Office Add-ins store (search "Dividend Data").
- Click Get it now on the listing and follow Microsoft's prompts.
- Reopen Excel — you'll find Dividend Data on the Home ribbon.
The add-in is a modern Office Add-in, so it works in Excel on the desktop and Excel on the web — anywhere AppSource add-ins run.
Sign in and Connect
Open the sidebar from the Dividend Data button on the Home ribbon and sign in with the same email you use for your Terminal account. Your account is keyed by email — same email means your plan, functions, and credit pool connect automatically. No API key to paste.
Your First Formula
In any cell, type:
=DIVIDENDDATA.DIVIDENDS("AAPL", "fwd_yield")
Apple's forward dividend yield appears within a moment. Excel uses the dot syntax — every function is =DIVIDENDDATA.NAME(...) (Google Sheets uses an underscore instead). Try a table next:
=DIVIDENDDATA.STATEMENT("MSFT", "income", TRUE, "annual")
That spills Microsoft's annual income statements, with headers, from a single cell.
Where to Go Next
The Functions tab on the Spreadsheets hub is the full reference: every function, its parameters, copy-paste examples in Excel or Sheets syntax, and a Formula Builder that assembles the formula for you. The add-in sidebar's Quick Actions load a full data table without typing anything.
For what each function does and how credits are spent, see Functions, Credits, and Examples.