The Lazy Investor’s Guide to Finding Dividend Kings (Free Excel List)

illustration of a relaxed investor sitting in a comfortable chair, looking at a glowing laptop screen showing a simple checklist and a golden crown. A sturdy pipeline of coins flows into their coffee mug.

You don’t need a Wall Street degree to find the best dividend stocks. Follow this step-by-step guide to download the Dividend Kings list and analyze them for free.

Introduction: Don’t Guess, Just Copy the Best

When beginners decide to build a passive income pipeline, they usually get overwhelmed. There are thousands of stocks in the US market. How do you know which ones are safe? How do you know which ones will actually pay you every quarter without cutting their dividend?

Here is the secret: You don’t have to guess. Wall Street has already done the hard work for you. There are specific groups of companies that have proven their reliability through wars, recessions, and pandemics.

Today, I am going to show you the ultimate “Lazy Investor’s Guide.” I will show you exactly how to find these legendary companies and download their complete data into a free Excel spreadsheet. Bookmark this page right now, open a new tab on your browser, and let’s do this together!

👑 Step 1: Understand the “Kings” and “Aristocrats”

Before we search, you need to know exactly what we are looking for. In the US stock market, companies are awarded special titles based on how consistently they reward their shareholders:

  • Dividend Aristocrats : These are companies in the S&P 500 index that have increased their dividend payout every single year for at least 25 consecutive years.
  • Dividend Kings : These are the absolute legends. To be a King, a company must have raised its dividend every year for at least 50 consecutive years.

Think about what 50 years means. These “Kings” survived the 1970s inflation, the 2000 Dot-com crash, the 2008 financial crisis, and the 2020 pandemic without ever cutting their dividends.

📥 Step 2: Download the Free Excel List (Sure Dividend)

You don’t need to pay for expensive financial software to get this list. We are going to use a wonderful free resource called Sure Dividend.

1.Go to suredividend.com. > See All Articles

2. Scroll down to the middle of the homepage until you see a section called “Best Stock Lists”. Click on “The Dividend Kings List” (or Aristocrats, depending on what you want).

    Dividend Aristocrats, Sure Dividend Excel, Seeking Alpha dividend, best US dividend stocks

    3. Click on “The Dividend Kings List” (or Aristocrats, depending on what you want). On the next page, look for a box that says: “Click here to download my Dividend Kings Excel Spreadsheet now.”.

    Dividend Aristocrats, Sure Dividend Excel, Seeking Alpha dividend, best US dividend stocks

    4. A pop-up will appear. Just enter your email address. (You can ignore any prompts for paid subscriptions; just close them). Check your email inbox. You will receive a link to download the Excel file.

    Dividend Aristocrats, Sure Dividend Excel, Seeking Alpha dividend, best US dividend stocks

    Boom! You now have a complete, updated list of the greatest dividend-paying companies in the world right on your computer.

    Dividend Aristocrats, Sure Dividend Excel, Seeking Alpha dividend, best US dividend stocks

    🔍 Step 3: Analyze Your Favorite Stock (Seeking Alpha)

    Now you have the list, but how do you know if a specific stock is attractive right now? We are going to use another free site called Seeking Alpha.

    Let’s use Apple (Ticker: AAPL) as an example.

    1. Go to seekingalpha.com.
    2. Type the ticker symbol (e.g., AAPL) into the top search bar and click on the company.
    3. Click on the “Dividends” tab in the menu.
    Dividend Aristocrats, Sure Dividend Excel, Seeking Alpha dividend, best US dividend stocks

    Here, you will see a simple dashboard with everything you need to know. Look for these key metrics:

    • Dividend Yield: This is your return on investment based on the current stock price. Generally, a yield of 2% or higher is a good starting point.
    • Annual Payout: How much cash you will receive for 1 share over a full year.
    • Payout Ratio: What percentage of the company’s net income is paid out as dividends. If it is too high, the dividend might be in danger. Look for companies with a healthy payout ratio (often 50% or above indicates a strong commitment to shareholder return, but always ensure they earn enough to cover it).
    • Dividend Growth: How many consecutive years they have increased the payout.

    (Expert Tip: Also check the “52-Week Change” on your list. Companies with a price fluctuation of less than 50% over the past year tend to give you less stress and a more stable ride.)

    Conclusion: Start Building Your Pipeline

    Investing doesn’t have to be complicated. By focusing on Dividend Kings and using free tools like Sure Dividend and Seeking Alpha, you can build a massive passive income pipeline with confidence.

    🎁 Want to analyze these Kings like a Pro? Now you have the list of Kings. But how do you pick the absolute best one for your portfolio?

    Run your top choices through my free <10-Minute FIRE Checklist: Invest Like Warren Buffett>. Enter your email below, and I’ll send you the exact checklist I use to filter out the traps and find the safest cash-flowing businesses!

    Scroll to Top