Why Dividend Data for Excel?
Stop copying and pasting financial data. The Dividend Data Excel Add-in brings institutional-quality financial data directly into your spreadsheets with simple formulas.
📦 Installation
Getting started is easy. You can install the add-in directly from the Microsoft AppSource marketplace or search for it inside Excel.
Option 1: One-Click Install (Recommended)
The fastest way to install is via our direct marketplace listing.
Click this link: Dividend Data on Microsoft AppSource
Click the blue "Get it now" button.
Sign in with your Microsoft account if prompted.
Click "Open in Excel" to launch a new spreadsheet with the add-in pre-loaded.
Option 2: Install Inside Excel
You can also find the add-in without leaving your spreadsheet.
For Excel Desktop (Windows/Mac):
Open Excel and go to the Home tab on the top ribbon.
Click the Add-ins button (sometimes labeled as "Get Add-ins" or a grid icon).
Click "More Add-ins" if a menu appears.
In the store window, search for "Dividend Data".
Locate our logo and click Add.
For Excel on the Web:
Go to the Home tab.
Click the Add-ins icon on the far right of the ribbon.
Search for "Dividend Data" and click Add.
✅ Verification: Is it working?
Once installed, you will see a "Dividend Data" tab appear in your top ribbon, or a notification that the add-in has been loaded.
To test it immediately, type this formula into any empty cell:
Excel
=DIVIDENDDATA.QUOTE("MSFT", "price")If you see a price appear (e.g., 415.50), you are ready to go!
Note: If you see a #NAME? error, the add-in may still be loading. Please wait a moment or try restarting Excel.
🚀 Next Steps
Open the Sidebar: Click the Dividend Data tab in the ribbon and select "Open Sidebar" to sign in and access quick tools.
Built for Dividend Investors
30+ years of dividend history for thousands of stocks
Dividend growth rates (1, 3, 5, 10-year CAGRs)
Payout ratios (EPS and Free Cash Flow based)
Ex-dividend dates, payment dates, frequencies
Complete Fundamental Data
Financial statements — Income, Balance Sheet, Cash Flow (annual and quarterly)
100+ financial metrics — Revenue, EPS, Free Cash Flow, and more
50+ financial ratios — P/E, ROE, Debt/Equity, Current Ratio, etc.
Growth rates — Revenue growth, EPS growth, dividend growth
Use Cases
Dividend tracking spreadsheets — Monitor your portfolio income
Stock screeners — Build custom screens with real data
Valuation models — DCF, DDM, and comparable analysis
Research dashboards — Track metrics over time
Watchlists — Live prices and key metrics in one view
Function Reference
All Excel functions use the DIVIDENDDATA. namespace:
=DIVIDENDDATA.DIVIDENDS()- Dividend data=DIVIDENDDATA.DIVIDENDS_BATCH()- Batch dividend data=DIVIDENDDATA.STATEMENT()- Financial statements=DIVIDENDDATA.METRICS()- Financial metrics=DIVIDENDDATA.RATIOS()- Financial ratios=DIVIDENDDATA.GROWTH()- Growth metrics=DIVIDENDDATA.QUOTE()- Stock quotes=DIVIDENDDATA.QUOTE_BATCH()- Batch quotes=DIVIDENDDATA.PROFILE()- Company profiles=DIVIDENDDATA.FUND()- ETF/Fund data=DIVIDENDDATA.SEGMENTS()- Revenue segments=DIVIDENDDATA.KPIS()- Key performance indicators=DIVIDENDDATA.COMMODITIES()- Commodities data=DIVIDENDDATA.CRYPTO()- Cryptocurrency data=DIVIDENDDATA.PRICE_TARGET()- Analyst price targets=DIVIDENDDATA.ESTIMATES()- Analyst estimates
Excel vs Google Sheets
Key difference: Excel uses DIVIDENDDATA. namespace (dot notation) while Google Sheets uses DIVIDENDDATA_ (underscore).
Example: =DIVIDENDDATA.DIVIDENDS("MSFT") in Excel vs =DIVIDENDDATA("MSFT") in Sheets