Free Dividend Tracking Spreadsheet
A clean dividend tracker spreadsheet template for Google Sheets or Excel — with the columns and formulas dividend investors actually need: income per holding, current yield, yield on cost, and portfolio totals. Free download, no email required.
What's in the template
The template ships with three example holdings (Coca-Cola, Realty Income, and SCHD) so you can see how each column works before replacing them with your own positions. Open it in Google Sheets or Excel — it's a plain CSV, so it imports anywhere.
Ticker / Company
The stock or ETF symbol and name.
Shares & Avg Cost
How many shares you own and what you paid on average. Total Cost = Shares × Avg Cost.
Current Price & Market Value
What the position is worth today. In Google Sheets this can update automatically (formula below).
Annual Dividend / Share
The stock's forward annual dividend. Annual Income = Shares × Annual Dividend.
Current Yield %
Annual Dividend ÷ Current Price. What a new buyer earns today.
Yield on Cost %
Annual Dividend ÷ Avg Cost. What YOUR money earns — this is the number that grows every time a company raises its dividend.
Payment Frequency & Ex-Dividend Date
Quarterly vs monthly payers, and the date you must own shares by to receive the next payment.
The formulas, step by step
Assuming your first holding is in row 2 (ticker in column A, shares in C, average cost in D, current price in F, annual dividend per share in H):
Total Cost (E2) = C2 * D2Live Price (F2) = GOOGLEFINANCE(A2, "price")— Google Sheets onlyMarket Value (G2) = C2 * F2Annual Income (I2) = C2 * H2Current Yield (J2) = H2 / F2— format as percentageYield on Cost (K2) = H2 / D2— format as percentage
For the totals row, SUM() the cost, value, and income columns, then compute the blended yields from the totals (total income ÷ total value, and total income ÷ total cost) rather than averaging the per-row percentages.
Where spreadsheets fall short
A spreadsheet is a genuinely good way to start tracking dividends — it forces you to understand yield on cost, and it costs nothing. But it has a maintenance bill that comes due every month: GOOGLEFINANCE doesn't supply dividend data, so every raise, cut, and special dividend is yours to catch and type in. Every buy changes your average cost. Every new holding is another row of lookups. And no spreadsheet will flag a payout ratio creeping toward unsustainable, or tell you what your income looks like in 2031 if your holdings keep raising at their real 5-year rates.
That's the job of an automatic dividend tracker: REWD syncs holdings and dividend payments from 100+ brokerages daily, surfaces safety signals per holding, and projects your income forward with each ticker's actual dividend growth history. The free plan tracks unlimited holdings manually — same data as the spreadsheet, none of the formula upkeep — and you can pair it with our dividend calculator and yield-on-cost calculator for planning.
Frequently Asked Questions
How do I use this template in Google Sheets?
Download the CSV, then in Google Sheets go to File → Import → Upload and select the file. Replace the example rows (KO, O, SCHD) with your own holdings. The TOTALS row shows portfolio-level cost, value, income, and blended yields.
How do I get live stock prices in the spreadsheet?
In Google Sheets, replace the Current Price cell with =GOOGLEFINANCE(A2, "price") where A2 is the ticker cell. Excel users can use Stocks data types (Data tab → Stocks). Dividend amounts are not available via GOOGLEFINANCE — you have to update those by hand when companies raise or cut.
How do I calculate yield on cost in a spreadsheet?
Yield on cost = annual dividend per share ÷ your average cost per share. If you bought at $50 and the stock now pays $2.50/year, your yield on cost is 5% — even if the current market yield is only 3%. It's the best single measure of how a dividend growth position is performing for you.
What are the limitations of tracking dividends in a spreadsheet?
Three big ones: dividend raises and cuts don't update themselves, every new purchase means manual data entry, and a spreadsheet can't warn you about payout-ratio risk or project income forward with real growth rates. That's the point where most investors move to an automatic dividend tracker.
Is there a free alternative to tracking dividends manually?
Yes — REWD's free plan tracks unlimited holdings with manual entry plus research data on 2,500+ dividend stocks, and paid plans from $9.99/month sync 100+ brokerages automatically so prices, holdings, and dividend payments update daily without any spreadsheet upkeep.
Tired of updating it by hand?
REWD tracks your dividends automatically — free to start, brokerage sync from $9.99/month.
Create Your Free AccountThis tool is for educational and informational purposes only and does not constitute investment, financial, tax, or legal advice. Consult a licensed professional before making investment decisions.
Past performance does not guarantee future results. All projections are hypothetical estimates based on user-provided inputs and may differ materially from actual outcomes.
By using this tool you agree to our Terms of Service and Privacy Policy.