To filter 23,000+ mutual funds down to a shortlist, use a mutual fund screener in this order: pick the category (asset class and style), cap the expense ratio, set a minimum 3- or 5-year return, then sort by fund size (AUM) and compare the top two or three. The MarketXLS Mutual Fund Screener covers 7,000+ US mutual funds with 20+ filters, including expense ratio, dividend yield, 1-, 3- and 5-year returns, volatility, region, and holdings. Free users see the top 10 results; the asset class, investment style, and FundXLS score filters and additional result pages are premium features (see FundXLS).
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
This guide explains which filters matter most, gives example screens for common goals, and shows what to do after screening.
What Is a Mutual Fund Screener?
A mutual fund screener is a filtering tool that searches thousands of mutual funds by criteria such as category, expense ratio, returns, volatility, and fund size.
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+ filters. It also accepts a plain-English query (for example, "low-cost international index funds") and converts it to filters.
The Filters That Matter Most
1. Category / Asset Class
Category is the first filter because it defines the fund's role 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 removes most irrelevant funds before you compare anything else.
2. Expense Ratio
Expense ratio is the one fund trait you know in advance, and it comes straight out of returns every year. Set a maximum based on the category:
| Category | Target Expense Ratio |
|---|---|
| US Index Funds | Under 0.10% |
| International Index | Under 0.20% |
| Bond Index | Under 0.10% |
| Active Large-Cap | Under 0.75% |
| Active Small-Cap | Under 1.00% |
| Target-Date | Under 0.20% |
A fund charging well above these thresholds needs consistently better returns to justify the premium.
3. Minimum Investment
Minimum investment rules out share classes you cannot buy. If you're starting with $1,000, a fund requiring $100,000 (institutional shares) is out. The MarketXLS screener does not filter on minimum investment, so check it on the fund's page or prospectus for your finalists.
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. In the MarketXLS screener, sort the results by the AUM column.
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%. Turnover is not a screener filter, so check it for your finalists in the fund's prospectus.
How to Screen for Mutual Funds: Step-by-Step
Step 1: Open the Screener
Go to the MarketXLS Mutual Fund Screener. You'll see 23,000+ funds with all available filters.
Step 2: Set Your Category
Select the asset class and investment style you're looking for (premium filters), or type a plain-English query into the AI search box. Category 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: Check Fund Size
$500 million AUM is a reasonable floor for most categories. Sort by the AUM column and ignore funds below that level.
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%)
Lowest cost with no minimum in this example: FXAIX (FZROX is 0.00% but is available only at Fidelity). Expense ratios change; confirm current figures before deciding.
Goal: 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+
Results will include: VTIAX, FSPSX, and 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 a category and sort by expense ratio, the cheapest funds are usually index funds, and S&P's SPIVA research shows most active funds trail their benchmark over long periods.
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 U.S. Scorecard. Figures vary by edition; check the latest 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). For core equity and bond positions, low-cost index funds are the default many investors start from. This is educational content, not investment advice.
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, which gives a quick shortlist to research further.
Free Mutual Fund Screener vs Paid Options
Several mutual fund screeners are available, including Morningstar, Fidelity, and Schwab. Here's how they compare:
| Screener | Cost | # of Funds | Key Advantage |
|---|---|---|---|
| MarketXLS | Free (top 10 results); premium for full results and some filters | 7,000+ | Linked overlap calculator, comparison, and tax-harvesting tools |
| Morningstar | Free (basic) / paid premium tier | Broad US coverage | Star ratings, analyst reports |
| Fidelity | Free (with account) | Their funds + others | Deep research on Fidelity funds |
| Schwab | Free (with account) | Their funds + others | Schwab-specific ratings |
The MarketXLS Mutual Fund Screener links directly to the overlap calculator, comparison tool, and tax-harvesting tool, so screening, comparing, and overlap checks happen in one place.
Explore More FundXLS Tools
- ETF Overlap Tool: find hidden holdings duplication between ETFs in your portfolio
- ETF Comparison Tool: compare any two ETFs side-by-side on all key metrics
- Mutual Fund Comparison: go beyond returns and compare mutual funds on fees, overlap, and risk
- Fund Overlap Calculator: check overlap between any combination of ETFs and mutual funds
Start Screening Mutual Funds
Define your criteria, filter 23,000+ funds, and shortlist the ones that fit your portfolio.
Open the Mutual Fund Screener →
Filter by category, expense ratio, returns, volatility, geography, and holdings.
