Mutual Fund Screener: How to Filter 7,000+ Funds to Find the Right Ones

M
MarketXLS Team
Published
Mutual fund screener showing filtered fund results

There are over 7,000 mutual funds available to US investors. That's not a feature — it's a problem.

How do you find the right one? You can't research all 7,000. You can't rely on "top 10" lists because they're based on past performance that probably won't repeat. And your financial advisor's recommendation might prioritize their commission over your returns.

What you need is a mutual fund screener — a tool that lets you set your criteria and filter thousands of funds down to a handful that actually match what you're looking for.

In this guide, we'll show you how to use a screener effectively, which filters matter most, and how to go from 7,000 options to a confident pick.

What Is a Mutual Fund Screener?

A mutual fund screener is a filtering tool that lets you search across thousands of mutual funds using specific criteria: expense ratio, category, returns, fund size, minimum investment, and more.

Think of it as a search engine for mutual funds. Instead of browsing lists or following recommendations, you define what you want and the screener finds funds that match.

The MarketXLS Mutual Fund Screener covers 7,000+ US mutual funds with 20+ filterable data points, making it one of the most comprehensive free mutual fund screeners available.

The Filters That Matter Most

1. Category / Asset Class

Start here. What role will this fund play in your portfolio?

  • US Large-Cap Blend: Core equity holding (VFIAX, FXAIX, SWPPX)
  • US Large-Cap Growth: Growth-tilted equity (VIGAX, FCNTX)
  • US Large-Cap Value: Value-tilted equity (VVIAX, DODGX)
  • US Small-Cap: Higher growth potential, higher risk (VSMAX, FSSNX)
  • International Developed: Non-US developed markets (VTIAX, FSPSX)
  • Emerging Markets: Higher risk international (VEMAX, FEMKX)
  • US Bond: Fixed income core (VBTLX, FXNAX)
  • Target-Date: All-in-one age-based allocation (VFFVX, FFFHX)

Filtering by category first eliminates 80% of irrelevant funds instantly.

2. Expense Ratio

The most predictive factor of future fund performance. Set a maximum based on the category:

CategoryTarget Expense Ratio
US Index FundsUnder 0.10%
International IndexUnder 0.20%
Bond IndexUnder 0.10%
Active Large-CapUnder 0.75%
Active Small-CapUnder 1.00%
Target-DateUnder 0.20%

Any fund charging significantly more than these thresholds needs to justify the premium with consistently superior returns — which very few do.

3. Minimum Investment

This is a practical filter. If you're starting with $1,000, a fund requiring $100,000 (institutional shares) is out.

Common minimums:

  • $0: Many Fidelity index funds (FXAIX, FZROX)
  • $1,000-$3,000: Vanguard Investor/Admiral shares
  • $100,000+: Institutional share classes (sometimes available in 401k plans)

4. Historical Returns

Use returns as a screening filter, not a selection criterion. Filter for funds that meet a minimum performance threshold (e.g., top 50% in their category over 5 years) to eliminate underperformers, then make your final decision on other factors.

5. Fund Size (AUM)

Larger funds are generally more stable and have lower operating costs per dollar invested. A reasonable minimum for most categories is $500 million in assets under management.

Very small funds (under $100 million) may have:

  • Higher expense ratios
  • Risk of closure or merger
  • Lower liquidity

6. Turnover Ratio

For taxable accounts, low turnover means fewer capital gains distributions. Index funds typically have turnover under 10%. Active funds can exceed 100%.

How to Screen for Mutual Funds: Step-by-Step

Step 1: Open the Screener

Go to the MarketXLS Mutual Fund Screener. You'll see 7,000+ funds with all available filters.

Step 2: Set Your Category

Select the asset class you're looking for. This is your most important filter — it determines the universe of funds you're searching within.

Step 3: Set an Expense Ratio Cap

Use the thresholds above as a guide. For index funds, keep it under 0.10%. For active funds, stay under 0.75% for large-cap and 1.00% for small-cap.

Step 4: Set a Minimum Fund Size

$500 million AUM is a reasonable floor for most categories. This filters out tiny, potentially unstable funds.

Step 5: Review the Results

Sort by expense ratio (lowest first) or returns (highest first). You should now have a manageable list of 5-15 funds.

Step 6: Compare Your Top Candidates

Take your top 2-3 and run them through the mutual fund comparison tool for a detailed side-by-side analysis. Check overlap if you're adding to an existing portfolio.

Screening for Specific Investment Goals

Goal: Lowest-Cost Core Equity Fund

Filters:

  • Category: US Large-Cap Blend
  • Expense ratio: 0 to 0.05%
  • Minimum investment: $0 to $3,000
  • AUM: $10 billion+

You'll find: FXAIX (0.015%), VFIAX (0.04%), SWPPX (0.02%), FZROX (0.00%)

Winner for most people: FXAIX — no minimum, rock-bottom fee, massive fund size.

Goal: Best Dividend Income Fund

Filters:

  • Category: US Equity Income / Dividend
  • Expense ratio: Under 0.50%
  • 5-year return: Top quartile
  • AUM: $1 billion+

You'll find a mix of index and active dividend funds. Compare your top picks on yield, dividend growth rate, and holdings concentration. Use the mutual fund overlap calculator to make sure a dividend fund doesn't overlap too much with your core equity holding.

Goal: Simple 401k Allocation

Filters:

  • Only your 401k's available funds (check your plan website)
  • Sort by expense ratio within each category

Most 401k plans offer 15-30 funds. Your screening job is simpler: find the cheapest index fund in each category you need (US equity, international equity, bonds). Skip anything with an expense ratio above 0.50%.

Goal: International Diversification

Filters:

  • Category: International / Foreign Large-Cap
  • Expense ratio: Under 0.20%
  • AUM: $5 billion+

Top results will include: VTIAX, FSPSX, SWISX — all broad international index funds with low fees. The differences between them are minimal.

Active vs Index: What the Screener Reveals

When you screen any category and sort by expense ratio, a pattern emerges: the cheapest funds are index funds, and they tend to outperform most of the expensive active funds above them.

The data is clear:

  • Over 15 years, 88% of US large-cap active funds underperform the S&P 500 index
  • Over 15 years, 90% of US small-cap active funds underperform their benchmark
  • Over 15 years, 85% of international active funds underperform their benchmark

(Source: S&P SPIVA Scorecard)

The screener makes this visible. Sort by 10-year returns in any category and count how many active funds beat the cheapest index option. Very few do.

That doesn't mean active management is always wrong — there are legitimate use cases in less efficient markets (emerging markets, small-cap value, alternatives). But for core equity and bond positions, index funds win for most investors.

Beyond Screening: What to Do Next

Once you've screened and selected your funds, use these tools to make sure your overall portfolio is sound:

Check for Overlap

Before adding a new fund, verify it doesn't duplicate what you already own. Run pairs through the Mutual Fund Overlap Calculator.

Compare Head-to-Head

If you're deciding between two finalists, the mutual fund comparison tool shows a detailed side-by-side breakdown.

Consider ETF Alternatives

For every mutual fund, there's often an ETF equivalent with slightly lower fees and better tax efficiency. If you're in a taxable account, check the ETF screener for alternatives.

Check Buy Scores

The Top Mutual Funds by Buy Score ranks funds using a composite metric that considers fees, returns, risk, and momentum — giving you a quick shortlist of quality funds.

Free Mutual Fund Screener vs Paid Options

There are several MF screeners available — Morningstar, Fidelity, Schwab, and others. Here's how they compare:

ScreenerCost# of FundsKey Advantage
MarketXLSFree7,000+Integrated overlap calculator, comparison tools
MorningstarFree (basic) / $249/yr (premium)7,000+Star ratings, analyst reports
FidelityFree (with account)Their funds + othersDeep research on Fidelity funds
SchwabFree (with account)Their funds + othersSchwab-specific ratings

The MarketXLS Mutual Fund Screener is unique because it connects directly to overlap calculators, comparison tools, and tax harvesting analysis — so you can go from screening to a fully-vetted portfolio decision in one workflow.

Explore More FundXLS Tools

Start Screening Mutual Funds

Stop guessing. Stop scrolling "top funds" lists. Define your criteria, filter 7,000+ funds, and find the ones that actually fit your portfolio.

Try the Free Mutual Fund Screener →

Filter by category, expense ratio, returns, fund size, and 20+ other criteria. Find your next fund in minutes, not hours.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets