ETF Screener: Filter 3,300+ ETFs by Expense Ratio, Holdings & Performance

M
MarketXLS Team
Published
ETF screener showing filtered results with expense ratios, performance metrics, and sector allocation data in the FundXLS screening tool

ETF screener tools are essential for any investor managing an exchange-traded fund portfolio. With over 3,300 ETFs listed in the US alone — spanning every sector, asset class, geography, and investment theme — finding the right funds without a screener is like searching for a needle in a haystack. In this guide, you will learn how to use an ETF screener effectively, which filters matter most for your investment goals, and how the FundXLS ETF screener gives you capabilities that free tools from Vanguard and Schwab simply do not offer.

What Is an ETF Screener and Why Do You Need One?

An ETF screener is a filtering tool that lets you narrow down thousands of exchange-traded funds based on specific criteria — expense ratio, asset class, sector exposure, performance, dividend yield, fund size, and more. Instead of browsing fund listings one by one, you set your filters and instantly see only the ETFs that match your requirements.

The Problem Without a Screener

Consider this: you want a large-cap US equity ETF with an expense ratio below 0.10%, dividend yield above 2%, and at least $10 billion in assets under management. Without a screener, you would need to:

  1. Browse hundreds of large-cap ETF listings
  2. Check each fund's expense ratio on its provider page
  3. Look up dividend yields individually
  4. Verify AUM for each candidate
  5. Compare performance across multiple timeframes

This process takes hours. An ETF screener does it in seconds.

Who Uses ETF Screeners?

  • Financial advisors selecting funds for client portfolios
  • Wealth managers building model portfolios across asset classes
  • Individual investors choosing between similar ETFs (VOO vs SPY vs IVV)
  • Portfolio managers rebalancing allocations based on changing criteria
  • Tax-loss harvesting — finding replacement ETFs that are similar but not "substantially identical"

Key Filters Every ETF Screener Should Have

Not all ETF screeners are created equal. Here are the filters that separate professional-grade screeners from basic ones:

Expense Ratio

The most important filter for long-term investors. Even small expense ratio differences compound significantly over decades.

Expense RatioAnnual Cost on $100K20-Year Cost (7% return)
0.03% (Vanguard VOO)$30$1,164
0.09% (SPDR SPY)$90$3,474
0.20% (average)$200$7,628
0.50% (active)$500$18,674
0.75% (high cost)$750$27,324

A good ETF screener lets you filter by maximum expense ratio — typically you want funds below 0.20% for passive strategies.

Asset Class

Filter ETFs by what they actually hold:

  • Equity — US large cap, mid cap, small cap, international, emerging markets
  • Fixed Income — Government bonds, corporate bonds, municipal bonds, high yield
  • Commodity — Gold, silver, oil, broad commodity baskets
  • Real Estate — REITs, real estate operating companies
  • Multi-Asset — Balanced funds, target date, allocation funds
  • Alternative — Managed futures, long/short, options strategies

Sector Exposure

For investors targeting specific sectors:

  • Technology, Healthcare, Financials, Energy, Consumer Discretionary
  • Consumer Staples, Industrials, Materials, Utilities, Real Estate, Communication Services

The FundXLS ETF screener shows sector breakdown for every fund, not just the primary classification — so you can see that a "Technology ETF" might actually have 15% healthcare exposure.

Performance Metrics

Screen by returns across multiple timeframes:

  • YTD return
  • 1-year return
  • 3-year annualized return
  • 5-year annualized return
  • 10-year annualized return
  • Since inception return

Fund Size (AUM)

Assets under management matters for liquidity and tracking error. Larger funds typically have:

  • Tighter bid-ask spreads
  • Better tracking of their benchmark
  • Lower risk of closure

Most advisors filter for minimum $100M AUM, with $1B+ preferred for core holdings.

Dividend Yield

For income-focused portfolios, filter by:

  • Current dividend yield
  • Dividend growth rate
  • Distribution frequency (monthly, quarterly, annual)

Geography

Filter by country or region exposure:

  • US only, International developed, Emerging markets
  • Single country (Japan, India, China, Brazil)
  • Regional (Europe, Asia Pacific, Latin America)

Investment Theme

Modern ETF screeners include thematic filters:

  • ESG/Sustainable investing
  • Artificial intelligence
  • Clean energy
  • Cybersecurity
  • Blockchain/Crypto
  • Aging population

How to Use the FundXLS ETF Screener

The FundXLS ETF Screener provides 20+ filters across 3,300+ US-listed ETFs. Here is how to use it for common investment scenarios:

Scenario 1: Finding Low-Cost Core Holdings

Goal: Build a core portfolio with the cheapest index funds

Filters to set:

  • Asset Class: Equity
  • Expense Ratio: Max 0.10%
  • AUM: Min $10 billion
  • Sort by: Expense ratio (ascending)

What you will find: The handful of ultra-low-cost ETFs from Vanguard, iShares, and Schwab that form the foundation of most portfolios — VOO, VTI, SCHB, IVV, ITOT.

Scenario 2: High-Dividend Income Portfolio

Goal: Generate monthly income from dividend ETFs

Filters to set:

  • Dividend Yield: Min 3%
  • AUM: Min $1 billion
  • Distribution Frequency: Monthly or Quarterly
  • Sort by: Dividend yield (descending)

What you will find: High-yield ETFs like SCHD, VYM, HDV, JEPI, and sector-specific income funds.

Scenario 3: International Diversification

Goal: Add non-US exposure to a domestic-heavy portfolio

Filters to set:

  • Geography: International Developed + Emerging Markets
  • Expense Ratio: Max 0.25%
  • AUM: Min $5 billion
  • Sort by: 5-year return

What you will find: Funds like VXUS, VEA, VWO, IXUS, IEMG — the building blocks for international allocation.

Scenario 4: Sector Rotation Strategy

Goal: Overweight sectors expected to outperform

Filters to set:

  • Sector: Select target sector (e.g., Energy)
  • Expense Ratio: Max 0.20%
  • Sort by: YTD return

What you will find: Sector-specific ETFs ranked by current performance — useful for momentum-based sector rotation.

Beyond Basic Screening: FundXLS Advanced Features

What sets the FundXLS screener apart from basic tools:

Complete Holdings Data

Most free ETF screeners show you the top 10 holdings. FundXLS shows you every single holding in 3,300+ ETFs. This matters because:

  • Two "Technology ETFs" might have completely different portfolios beyond the top 10
  • Hidden concentration risk only appears when you see the full holdings list
  • Overlap analysis requires complete data, not just top holdings

Proprietary Scoring System

FundXLS calculates three daily scores for every ETF:

  • Buy Score — Composite rating based on fundamentals, momentum, and value metrics. See top-rated ETFs
  • Momentum Score — Trend strength and relative performance ranking. See top momentum
  • Value Score — Valuation metrics relative to peers. See top value

These scores are updated daily, giving you a quantitative edge over screeners that only show static fund data.

11-Tab ETF Detail Pages

Click any ETF in the screener results to access a comprehensive analysis page with 11 tabs:

  1. Overview — Key stats, description, expense ratio, AUM
  2. Holdings — Complete list of every position (not just top 10)
  3. Performance — Returns across all timeframes with benchmark comparison
  4. Compare — Side-by-side comparison with similar ETFs
  5. Overlap — See how much this ETF overlaps with your existing holdings
  6. Sectors — Sector allocation breakdown
  7. Geography — Country and region exposure
  8. Peers — Similar ETFs ranked by various criteria
  9. Dividend — Yield, growth, payment history
  10. Tax — Tax efficiency metrics and capital gains history
  11. News — Latest news affecting the fund and its holdings

Visit any ETF page directly — for example, SPY analysis or QQQ analysis.

ETF Screener Comparison: FundXLS vs Other Tools

FeatureFundXLSetfdb.cometf.comVanguardSchwab
Number of ETFs3,300+3,000+3,000+Vanguard onlySchwab only
Complete holdingsYes — every positionTop 10-15Top 10Vanguard onlySchwab only
Overlap analysisYes — up to 10 ETFsNoNoNoNo
Proprietary scoresBuy, Momentum, ValueEditorial ratingsRating systemNoSchwab ratings
Tax-loss harvestingBuilt-in toolNoNoNoNo
Portfolio X-RayYes — full analysisNoNoNoNo
Stock-to-ETF lookupYesLimitedNoNoNo
PriceFree + Premium tiersFree + PremiumFreeFreeFree
Expense ratio filterYesYesYesYesYes
Sector breakdownFull detailBasicBasicBasicBasic
ETF detail depth11 tabs per ETFModerateModerateBasicBasic

What FundXLS Has That Others Do Not

  1. Overlap CalculatorCompare up to 10 ETFs to find duplicate holdings. If you own VOO and QQQ, you might have 40% overlap without knowing it.

  2. Portfolio X-RayUpload your entire portfolio for institutional-grade analysis including efficient frontier, Sharpe ratio, drawdown analysis, and a 0-100 health score.

  3. Tax-Loss Harvesting ToolFind replacement ETFs that are similar enough to maintain your strategy but different enough to avoid wash sale rules.

  4. Stock-to-ETF Lookup — Want to know which ETFs hold Apple? Search any stock and see every ETF that includes it, sorted by weight.

Common ETF Screening Mistakes

Mistake 1: Focusing Only on Past Returns

Past performance does not predict future results — yet most investors sort by highest returns. A fund that returned 40% last year might be concentrated in one sector that happened to rally. Look at risk-adjusted returns (Sharpe ratio) and consistency across timeframes instead.

Mistake 2: Ignoring Tracking Error

An index ETF should closely track its benchmark. High tracking error means the fund is not doing its job. Check how closely the ETF's returns match its stated benchmark — a difference of more than 0.10% annually should raise questions.

Mistake 3: Overlooking Overlap

This is the biggest hidden risk in ETF portfolios. If you own VTI (total US market), VOO (S&P 500), and QQQ (Nasdaq 100), you have massive overlap — Apple, Microsoft, and Amazon appear in all three with heavy weightings. Use the FundXLS Overlap Calculator to check your actual diversification.

Mistake 4: Choosing the Cheapest Option Without Context

The lowest expense ratio is not always the best choice. Consider:

  • Liquidity (bid-ask spread can cost more than expense ratio for large trades)
  • Tracking error (cheap but inaccurate is not cheap)
  • Tax efficiency (some fund structures are more tax-efficient)
  • Securities lending revenue (some funds offset expenses through lending)

Mistake 5: Not Checking Holdings Regularly

ETF holdings change. Fund managers rebalance, indices reconstitute, and sector weights shift. Screen your existing holdings periodically — not just when buying new funds.

ETF Screening Workflow for Financial Advisors

Professional financial advisors use ETF screeners differently than individual investors. Here is the workflow used by advisors managing client portfolios:

Step 1: Define the Asset Allocation

Start with the target allocation based on the client's risk profile, time horizon, and goals. For example:

  • 60% US Equity, 25% International Equity, 15% Fixed Income

Step 2: Screen for Candidates in Each Bucket

Use the ETF screener to find 3-5 candidates for each allocation bucket. Filter by:

  • Asset class matching the bucket
  • Expense ratio below threshold
  • Minimum AUM for liquidity
  • Track record (inception date at least 3 years ago)

Step 3: Check Overlap Across Selections

Before finalizing, run all candidates through the Overlap Calculator. Ensure your international ETF does not duplicate holdings in your US ETF.

Step 4: Run Portfolio Analysis

Upload the proposed portfolio to Portfolio X-Ray to check:

  • Overall Sharpe ratio
  • Maximum drawdown
  • Efficient frontier positioning
  • Portfolio health score (0-100)
  • Aggregate expense ratio

Step 5: Document and Present

Generate a portfolio report for the client showing the analysis, rationale for each fund selection, and projected metrics.

Frequently Asked Questions

What is the best free ETF screener?

The FundXLS ETF Screener offers a free tier that includes basic screening of 3,300+ ETFs with top 10 holdings, expense ratio filters, and 2-ETF comparison. For complete holdings data, advanced scoring, and portfolio analysis, the premium tiers start at $60 per month. Other free options include etfdb.com and etf.com, though they lack overlap analysis and complete holdings data.

How do I compare two ETFs side by side?

Use an ETF comparison tool that shows holdings, performance, expense ratios, and sector exposure in parallel. The FundXLS Overlap Calculator lets you compare up to 10 ETFs simultaneously, showing exactly which holdings overlap and by how much — something most comparison tools cannot do because they only show top 10 holdings.

What expense ratio is considered good for an ETF?

For passive index ETFs, an expense ratio below 0.10% is excellent and below 0.20% is good. Broad market ETFs like VOO (0.03%) and VTI (0.03%) set the standard. Active ETFs and niche thematic funds typically charge 0.40-0.75%. Use an ETF screener to filter by maximum expense ratio and avoid overpaying for beta exposure that cheap index funds provide equally well.

How often should I screen my ETF portfolio?

Review your ETF holdings quarterly at minimum. Check for changes in expense ratios, tracking error, holdings concentration, and overlap with other positions. Major market events (sector rotations, new fund launches, index reconstitutions) warrant ad-hoc screening. The FundXLS portfolio tools make this a quick process rather than a research project.

Can I screen for ETFs that hold a specific stock?

Yes. The FundXLS Stock-to-ETF Lookup lets you search for any stock and see every ETF that holds it, sorted by weight. For example, searching for AAPL shows every ETF holding Apple stock. You can even search for combinations — ETFs that hold both AAPL and MSFT.

What is the difference between ETF screening and ETF comparison?

Screening is filtering — narrowing 3,300+ ETFs down to a short list based on criteria. Comparison is analyzing — looking at 2-10 specific ETFs side by side to choose between them. A good workflow starts with screening to create your short list, then comparison to make the final selection. FundXLS provides both: the ETF Screener for filtering and the Overlap Calculator for detailed comparison.

Start Screening ETFs Today

Finding the right ETFs does not have to mean hours of manual research across dozens of fund provider websites. The FundXLS ETF Screener puts 3,300+ ETFs at your fingertips with professional-grade filters, complete holdings data, proprietary scoring, and tools that go far beyond basic screening — including overlap analysis, portfolio X-Ray, and tax-loss harvesting.

Whether you are a financial advisor building client portfolios or an individual investor choosing between similar funds, start with the FundXLS ETF Screener and make data-driven decisions in minutes instead of hours.

For investors who also work in Excel, the MarketXLS Excel add-in complements FundXLS with over 1,000 financial data functions including ETF-specific formulas like =DividendYield("VOO"), =PERatio("SPY"), and =Last("QQQ") — bringing the same depth of ETF data directly into your spreadsheet environment for custom analysis and portfolio modeling.

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