Dividend Tracker Spreadsheet: Yield, Income and Ex-Dividend Dates in Sheets or Excel

Dividend tracker spreadsheet guides for Google Sheets and Excel: track income and ex-dividend dates, calculate yield and monthly income, then build yield on cost and DRIP dashboards with live data.

Start here: Google Sheets stock dividend yield.

1. 1
   Google Sheets Dividend Tracker: Monitor Income, Yield, and Ex-Dates

   Build a dividend tracker in Google Sheets with MarketXLS. Monitor dividend yield, dividend per share, ex-dividend dates, payout ratios, and projected annual income for every stock in your portfolio.

2. 2
   Dividend Yield: How to Find, Calculate, and Screen for High-Yield Stocks in Google Sheets and Excel (2026)

   Find dividend yield in Google Sheets or Excel with =DividendYield("AAPL"), calculate it by hand, and screen for high-yield stocks while avoiding yield traps.

3. 3
   Dividend Tracker Excel: Build a Real-Time Income Portfolio Dashboard in 2026

   Build a self-updating dividend tracker in Excel: formulas for yield, dividend per share, payment frequency, and projected annual income, compared with manual and Google Sheets methods.

4. 4
   Dividend Portfolio Tracker: Build a Complete Monitoring System in Excel

   Dividend portfolio tracking in Excel lets you monitor yield, income, ex-dividend dates, and DRIP growth across all your holdings. Build a complete tracker with MarketXLS formulas.

5. 5
   Monthly Dividend Yield: Calculate and Track Your Income Using Excel in 2026

   Monthly dividend yield is annual yield divided by 12. How to calculate it, and how to build a month-by-month dividend income tracker in Excel with MarketXLS.

6. 6
   Ex-Dividend Dates: Track Multiple Stocks Quickly in Your Excel Spreadsheet (2026)

   To get the next dividend you must buy a stock before its ex-dividend date. Pull ex-dates, pay dates, and yields for many stocks into Excel with MarketXLS formulas.

7. 7
   Streamline Your Dividend Tracking with a Spreadsheet Calendar

   A dividend calendar spreadsheet lists each holding with its ex-dividend date, pay date, frequency, and amount so you know when income arrives. How to build one with MarketXLS.

8. 8
   Get Ahead with a Dividend Calendar Spreadsheet Strategy

   A dividend calendar spreadsheet lists ex-dividend, record, and pay dates with expected amounts for each holding, so you can plan income and reinvestment.

9. 9
   Create a Dividend Calendar Spreadsheet to Maximize Retirement Income

   Build a dividend calendar spreadsheet in Excel with ex-dividend date, pay date, frequency, dividend per share, and yield for each holding to forecast retirement income.

10. 10
    Yield on Cost Dashboard Excel: Track Dividend Portfolio Income Growth (2026)

    Yield on cost is current dividend per share divided by your original cost. Track it per holding and across a dividend portfolio in a free Excel dashboard.

11. 11
    Dividend Reinvestment Calculator Excel: DRIP Compounding Dashboard for Long-Term Income Investors

    Free Excel DRIP calculator: project dividend reinvestment compounding from your yield, growth and contribution inputs, run scenarios, and screen 15 dividend stocks with MarketXLS.