Let’s be honest: who doesn’t love the idea of earning a little extra cash without lifting a finger? That’s the beauty of dividend stocks. They’re like those friends who always pay you back, no matter what. You invest, and in return, you get regular payouts just for holding onto them. It’s a win-win.

But the thing is, finding the right dividend stocks can be a headache. The market is packed with options, and not all of them are created equal. You’ve got to sort through a lot of numbers, look at yields, check payouts, and watch for growth. It’s a lot.

That’s where a dividend stock screener comes into play. This tool helps you quickly filter through the noise and find stocks that fit your criteria. Set it up to match what you’re looking for – be it a certain yield, payout consistency, or sector focus – and you’ll get a refined list of potential winners in no time.

Why is this important? Because you don't want to just pick any dividend stock. You want to make informed choices that align with your income goals. A screener saves time, boosts efficiency, and helps you focus on stocks that are more likely to deliver consistent returns, even during market swings.

What is a Dividend Stock Screener

First, let’s cover the basics. Dividends are regular payments made by companies to their shareholders, usually from their profits. Basically, you get a bonus simply for holding onto a company's stock. This makes dividend stocks appealing for investors looking to earn consistent income alongside potential growth.

But with so many stocks out there, how do you find the right ones that pay good dividends?

This is where a dividend stock screener becomes useful. It’s a tool that helps investors sort through hundreds (or even thousands) of stocks to find ones that meet specific dividend criteria.

If you’re interested in another fundamental-based screening approach, learn how to create a Graham Number Stock Screener in Excel or Google Sheets.

Here’s how it works: you set specific filters based on what you’re looking for. Maybe it’s a certain dividend yield, payout ratio, or even the consistency of dividend growth. Once your criteria are set, the screener scans available stocks and pulls up only those that meet your requirements. So, instead of having to wade through endless stocks, you get a clear and focused look at options that fit your goals.

In other words, a dividend stock screener is designed to save time and help investors make better decisions. Zeroing on stocks that align with your personal income targets or risk tolerance makes it easier to identify potential opportunities and avoid duds.

How to Create a Dividend Stock Screener in Excel & Google Sheets

Creating a dividend stock screener might sound complex, but is actually pretty straightforward. All you need is Excel, Google Sheets, and a plugin like Wisesheets to make it even easier.

Let’s break it down step-by-step.

Step 1: Listing the Stocks

First things first, you’ll need a list of stocks to work with. You can generate this list from various sources:

• Yahoo Finance: Search for stocks by sector, region, or market cap.
• Google Finance: Use their stock listing and filter options.
• Your Broker’s Platform: Most broker platforms offer pre-set lists of dividend-paying stocks.

Check out this article on Yahoo Finance Excel to learn more about retrieving live and historical stock data, which can be useful for building your dividend stock screener.

Once you have a list of stocks you are interested in analyzing, the next step is to gather financial data for each stock. We recommend you use the Google Sheets and Excel plugin called Wisesheets.

After you have installed the add-on as the documentation states, you can start to build your screener and create something like this:

Step 2: Selecting Parameters

Now, it’s time to narrow down the criteria for your screener. Here are some common parameters to include:

• Dividend Yield: The percentage of the stock’s price that’s paid out as dividends.
• Payout Ratio: The percentage of earnings paid out as dividends.
• Market Cap: The company’s size, which can indicate stability.

If you’re using Wisesheets, you can use the plugin to pull this data automatically.

Learn how to get all the stock data you need in Google Sheets with this guide, which can complement your dividend stock screener setup.

Install it, connect your account, and highlight the stock tickers from Step 1. In the Wisesheets panel, choose your parameters (e.g., yield, payout ratio), then click 'Get Data' to populate your sheet with live information.

Step 3: Build Your Screener

Once you have both your tickers and parameters, click the tab "Screener" in your Wisesheets Panel:

Lastly, select the range of tickers (with a limit of up to 1000 per call) and the range of parameters to be analyzed, and click on "Get Data".

The data will get retrieved instantly, and you will be able to see the following:

Step 4: Analyzing the Results & Creating Graphs

Now that your data is loaded, it’s time to make sense of it:

• Use Excel/Google Sheets filters to sort stocks based on your criteria.
• If you’re interested in visual trends, create charts to compare dividend yields, growth rates, or payout ratios.

To track real-time price changes of your selected dividend stocks, explore our guide on getting live stock prices in Excel.

• Highlight stocks that meet your target metrics, like those with a yield over 4% or a healthy payout ratio.

To create a chart:

• Select the data range you want to visualize.
• Format the data before charting:
  • Dividend Yield & Payout Ratio: Format these as percentages for better readability. Select the cells, go to Format > Number > Percentage.
  • Market Cap: Format this as a number with commas for easier reading. Select the cells, then go to Format > Number > Number.
• Once the data is formatted, go to the Insert tab and choose the chart type that best fits your data (e.g., bar chart for comparing yields or line graph for trends).
• Adjust the design and labels to make the chart clear and easy to understand. Add a title, axis labels, and any data legends needed.

Why Use a Dividend Stock Screener

If you’re investing in dividend stocks, you’re likely aiming for more than just stock price growth. You want consistent income, potential tax perks, and a bit more reliability. But finding the right dividend stocks can be tough. That’s where a dividend stock screener can make things a whole lot easier.

For more guidance on using stock screeners, check out our Google Finance Stock Screener Tutorial.

Here’s how:

Advantages of Screening Dividend Stocks

• Steady Income Potential: Dividend stocks pay regularly, but you need to identify the ones that offer consistent payouts. A screener helps you filter for specific yields, so you can easily find stocks that meet your income goals, whether it's 2%, 4%, or even higher You can use it to spot stocks with a solid history of paying dividends, reducing the chances of picking unreliable options.

• Reliability & Stability: Companies that pay consistent dividends are often well-established and financially sound. With a screener, you can sort for important indicators like payout ratios or dividend growth rates. This way, you can identify stocks that have a better chance of maintaining or increasing their payouts, even during market downturns.

• Tax Perks: In many places, dividends come with tax advantages over other income types, like interest. Using a dividend stock screener allows you to zero in on stocks that pay qualified dividends, potentially saving you money come tax time.

• Efficient Decision-Making: Screeners allow you to cut through the clutter fast. If you want to find stocks with a yield above 5% and a payout ratio under 60%, you can set those filters and get an instant list. It’s an easy way to save time and focus only on the stocks that meet your criteria.

Explore these 5 best free stock screeners that can help you make wise investment decisions, including dividend investing.

• Easier Diversification: A screener can help you diversify your portfolio by letting you filter based on sectors, market caps, or regions. This makes it simpler to spread your risk while still targeting high-yield stocks.

Pair your dividend screener with this Google Finance Watchlist Template to monitor your selected stocks more effectively.

Top Criteria to Consider in a Dividend Stock Screener

When it comes to picking the best dividend stocks, knowing what to look for is half the battle. A dividend stock screener can help, but you’ll need to set the right criteria to get meaningful results. Here are the top factors to focus on:

1) Dividend Yield and Payout Ratio

Dividend Yield: This is the percentage of the stock’s price that’s paid out as dividends over a year. It’s a quick way to gauge how much income you can expect relative to your investment.

For example, a 5% yield means you’ll earn $5 annually for every $100 invested. But remember, higher isn’t always better—sometimes a high yield can signal financial trouble. Aim for yields that are attractive but sustainable.

Payout Ratio: This is the percentage of a company’s earnings that goes toward dividends. A payout ratio under 60% is generally considered sustainable, while anything above 80% could mean the company’s stretching its earnings to pay dividends. Lower ratios often suggest the company has room to grow dividends over time.

2) Dividend Growth Rate

This measures how much a company’s dividend has grown over a set period (e.g., 3, 5, or 10 years). Consistent growth is a good sign of financial health and suggests that management is committed to returning value to shareholders.

To better evaluate the stability and growth of dividends over time, explore our guide on mastering the Horizontal Analysis Formula for stock investing.

A strong dividend growth rate also helps combat inflation. Stocks with growing dividends can provide increasing income over time, which is crucial for maintaining purchasing power.

3) Market Cap & Sector

Market Cap: Large-cap stocks (over $10 billion) are often seen as safer, more stable dividend payers, while mid-cap and small-cap stocks might offer higher yields but with more risk.

Sector: Different sectors have different approaches to dividends. For instance, utilities and consumer staples are known for reliable dividends, while tech or biotech may prioritize growth over payouts. When screening, it’s useful to filter by sector to ensure your picks align with your risk tolerance and income needs.

4) Volatility (Beta)

Beta measures how volatile a stock is compared to the overall market. A beta of 1 means the stock moves with the market, while less than 1 indicates lower volatility. Dividend investors often favor lower-beta stocks because they tend to be less sensitive to market swings.

Screening for low-beta stocks can help you build a more stable, income-focused portfolio. You don't just want to focus on high yields, but also on keeping that income steady – even when markets get bumpy.

Best Practices for Using a Dividend Stock Screener

Once you’ve set up your dividend stock screener, it’s important to use it effectively.

Here are some best practices to ensure you’re getting the most out of it:

1) Setting Realistic Criteria

When you start screening, it’s tempting to set very specific filters right away. But starting broad can actually help. For example, begin with a wider range for dividend yield (e.g., 2% to 8%) or payout ratio (e.g., under 80%) to see what’s out there. You might be surprised by some stocks that meet your broader criteria but offer other advantages, like strong growth potential.

Once you have a broad list, you can narrow it down further. Adjust parameters based on yield, market cap, or other factors until you’ve refined your list to the best potential matches.

2) Regular Updates

The market changes constantly, and so do dividends. It’s a good idea to refresh your screener regularly—ideally, once a month or at least quarterly. This ensures you’re capturing the most up-to-date information about yield, payout ratios, and other important metrics.

To make updates easier, you can use the Wisesheets plugin in Google Sheets or Excel.

For more detailed tracking of your dividends, check out our ultimate guide on tracking your dividends effectively.

Here’s how:

• Open Your Existing Screener: Go to your spreadsheet with the existing screener setup.
• Select the Stock Tickers: Highlight the stock tickers you want to update.
• Open Wisesheets: From the menu, navigate to the Wisesheets plugin.
• Choose Parameters: Select the parameters you want to refresh, such as Dividend Yield or Payout Ratio.
• Click 'Get Data': The plugin will fetch the latest data and replace the old information, giving you an updated list of stocks based on current market conditions.

Look out for any dividend cuts, unexpected changes in payout ratios, or new opportunities from recently listed companies. A screener that’s regularly updated helps keep your portfolio aligned with current market conditions.

3) Reinvesting Dividends for Compound Growth

One of the best strategies for growing wealth over time is dividend reinvestment. Instead of taking dividends as cash, consider reinvesting them to buy more shares. This not only increases your holdings but also boosts your future dividends, creating a compounding effect.

If your screener identifies stocks with solid dividend growth rates, these are often good candidates for reinvestment. Over time, the compounding effect can lead to significant gains, making your screener even more valuable as part of a long-term growth strategy.

Examples of High-Performing Dividend Stocks in 2024

For 2024, a few dividend stocks have stood out for their reliable payouts, growth potential, and overall stability. These stocks not only offer attractive yields but also meet many criteria you would typically set in a dividend stock screener.

Let’s take a closer look:

1) Exxon Mobil Corp. (XOM)

• Dividend Yield: 3.16%
• Payout Ratio: 0.44

Why It's a Top Pick: Exxon Mobil continues to be one of the strongest names in the energy sector. Despite a cooling energy market, the company’s consistent cash flow has allowed it to maintain a solid yield. With a payout ratio below 50%, it has room to sustain and even grow its dividends over time. Additionally, Exxon’s focus on cost efficiency and capital management further boosts its dividend reliability.

Best Fit For: Investors looking for stable income from a large-cap stock, especially in the energy sector.

2) Kenvue Inc. (KVUE)

• Dividend Yield: 3.60%
• Payout Ratio: 0.63

Why It's a Top Pick: Kenvue, a spin-off of Johnson & Johnson, is making waves in the consumer healthcare space. Despite market skepticism, the company has demonstrated a strong focus on generating consistent cash flow, which supports its attractive yield. The payout ratio is slightly higher but still within a comfortable range, making it a viable option for income-focused investors.

Best Fit For: Investors who want exposure to the growing healthcare sector with a focus on income stability.

3) Hutchinson Holdings Ltd (OTC CKHUY)

• Dividend Yield: 5.9%
• Payout Ratio: 0.59

Why It's a Top Pick: Hutchinson’s diversified business model, which spans telecom, retail, and infrastructure, supports its substantial dividend yield. While the higher payout ratio suggests more of its earnings are going to dividends, the company’s diversified revenue streams make this yield sustainable. It’s also undervalued, which offers potential capital gains alongside the strong income.

Best Fit For: Investors seeking higher yields and diversified international exposure.

4) British American Tobacco PLC (BTI)

• Dividend Yield: 8.79%
• Payout Ratio: 0.70

Why It's a Top Pick: British American Tobacco has shifted its focus toward new nicotine products, which could drive future growth. Despite challenges in the traditional tobacco sector, its dividend yield remains one of the highest among blue-chip stocks. The payout ratio, while higher, is still manageable due to the company’s strong cash flow.

Best Fit For: Income-seeking investors comfortable with the regulatory risks associated with tobacco stocks.

Case Study: Using a Dividend Stock Screener to Find a High-Yield Stock

Let’s say you want to find a reliable, high-yield stock to add to your portfolio. We’ll walk through the entire process using a dividend stock screener in Google Sheets, with Wisesheets as the data source.

For this example, our target criteria are:

• Dividend Yield: At least 5%
• Payout Ratio: Below 70%

Step 1: Setting Up the Screener in Google Sheets

• Install Wisesheets: First, make sure you have the Wisesheets plugin installed in Google Sheets. It’s available on the Google Workspace Marketplace.
• Add a List of Stocks: Copy a list of dividend-paying stocks into your spreadsheet. For simplicity, we’ll start with a few well-known names like Exxon Mobil, AT&T, Verizon, and Altria Group.

Step 2: Pulling the Data

• Highlight the Stock Tickers: Select the cells that contain the stock tickers you added.
• Open Wisesheets: Navigate to the Wisesheets plugin on your Google Sheets menu and click on it.
• Choose Your Parameters: In the Wisesheets panel, select the data you want to pull. For this example, choose Dividend Yield and Payout Ratio.
• Click 'Get Data': The screener will automatically fetch the latest data for the selected stocks and fill it into your spreadsheet.

Step 3: Filtering for High-Yield Stocks

• Apply Filters: Use Google Sheets’ built-in filters to narrow down the results. Set the filter to show only stocks with a dividend yield of 5% or higher and a payout ratio below 70%.
• Analyze the Results: Look for stocks that satisfy this criteria. In this case, both Verizon and Altria Group meet both the requirements.

• Dividend Yield: 8.79%
• Payout Ratio: 0.70

Step 4: Evaluating the Selected Stock

Now that we’ve identified British American Tobacco as a match, let’s do a quick evaluation:

• Yield: The 8.79% yield is above our target, offering a high level of income.
• Payout Ratio: While it’s on the higher end (70%), it’s still within our threshold.

Based on this screener output, British American Tobacco could be a solid addition for an income-focused portfolio.

FAQs (Frequently Asked Questions) About Dividend Stock Screener

What is a dividend stock screener?

A dividend stock screener is a tool that helps you filter and find stocks based on specific dividend-related criteria, like yield, payout ratio, or sector. It’s designed to make the process of identifying high-yield, sustainable stocks easier and faster. Instead of manually sorting through hundreds of stocks, you can set filters and let the screener do the work for you.

---

How often should I update my screener?

It’s a good idea to update your screener at least once a month. The stock market can change rapidly, and so can dividend policies. Regular updates ensure you’re working with the latest information on yields, payout ratios, and company performance. You might also want to do a quick refresh after major market events, earnings releases, or dividend announcements to keep your data accurate.

---

What criteria are most important in a screener?

The most important criteria typically include:

• Dividend Yield: Indicates how much return you’ll get relative to the stock’s price.
• Payout Ratio: Shows how much of a company’s earnings are paid as dividends; a lower ratio suggests more sustainability.
• Market Cap & Sector: Helps you understand the size and industry of the company, which can affect dividend reliability.
• Volatility (Beta): Useful for assessing the stock’s price stability in relation to the overall market.

The criteria you choose depend on your personal income goals and risk tolerance, but these are the most commonly used filters.

---

Can I create a screener for free?

Yes, you can create a dividend stock screener for free using tools like Google Sheets or Excel, combined with financial data plugins like Wisesheets. These platforms offer free access to data and allow you to build custom screeners tailored to your preferences. There are also many free stock screener websites that offer basic filtering options, though they may have some limitations compared to fully customizable options.

Wrapping It Up: Start Screening for Better Dividend Stocks

So, there you have it. A dividend stock screener is not just a tool, but a smarter way to invest in income-producing stocks. It helps you cut through the noise and focus on the stocks that really fit what you’re looking for, whether that’s reliable income, potential for growth, or just more stability in your portfolio.

But the real magic happens when you start building your own screener. Seriously, it’s easier than you think. You don’t need to be a finance pro or a spreadsheet wizard. Just start simple. Use Excel, Google Sheets, or even one of the free online tools. Set some basic filters like yield and payout ratio, then tweak as you learn more about what works best for you.

If you’ve been following along, you’ve got all the steps you need right here. So why not give it a shot? Start small, make adjustments, and see what kind of high-yield opportunities you can uncover. You might be surprised at what you find!