Choosing between two ETFs shouldn't require a spreadsheet and three hours of research. Yet most investors either pick blindly or spend way too long toggling between fund provider websites trying to piece together a comparison.
An ETF comparison tool puts everything in one view — expense ratios, historical returns, holdings, volatility, dividend yield — so you can make a decision in minutes, not days.
In this guide, we'll walk through exactly how to compare ETFs the right way and show you how to use MarketXLS's free ETF compare tool to do it instantly.
Why Comparing ETFs Matters More Than Ever
The ETF market has exploded. There are over 3,300 ETFs available to US investors, and many of them look very similar on the surface. There are 15+ S&P 500 ETFs alone. Dozens of dividend ETFs. Hundreds of bond ETFs.
Small differences between similar ETFs compound into large differences over time:
- A 0.10% expense ratio difference on $100,000 costs you ~$26,000 over 30 years (assuming 8% returns)
- Tracking error means two ETFs following the same index can deliver different returns
- Tax efficiency varies based on how the fund handles distributions
- Liquidity affects your ability to buy/sell at fair prices
The only way to know which ETF is right for you is to compare ETFs head-to-head on the metrics that matter.
What to Compare When Evaluating ETFs
Expense Ratio
This is the annual fee you pay, expressed as a percentage of assets. Lower is almost always better for index funds tracking the same benchmark.
| ETF | Expense Ratio | Index |
|---|---|---|
| VOO | 0.03% | S&P 500 |
| SPY | 0.09% | S&P 500 |
| IVV | 0.03% | S&P 500 |
VOO and IVV track the same index as SPY for one-third the cost. Over 30 years on a $500,000 portfolio, that 0.06% difference is worth about $30,000.
Historical Returns
Past performance doesn't guarantee future results, but it reveals tracking accuracy and whether a fund delivers what it promises.
When you compare ETFs on MarketXLS, you'll see 1-year, 3-year, 5-year, and 10-year annualized returns side-by-side. This makes it easy to spot funds that lag their benchmark.
Holdings and Concentration
Two ETFs in the same category can have very different holdings. For example:
- SCHD (Schwab US Dividend Equity): ~100 holdings, focuses on dividend quality
- VYM (Vanguard High Dividend Yield): ~450 holdings, broader dividend approach
More holdings generally means more diversification, but also more exposure to mediocre companies. Fewer holdings means more concentration — higher potential returns but more volatility.
To see exactly how much holdings overlap exists between two ETFs, use the ETF overlap calculator.
Volatility and Risk Metrics
Standard deviation, beta, max drawdown, and Sharpe ratio tell you how much risk you're taking for the returns you're getting.
A fund with slightly lower returns but significantly lower volatility might be the better choice, especially if you're nearing retirement or can't stomach big drawdowns.
Dividend Yield and Distribution
If you need income, compare:
- Current yield: What percentage the fund pays annually
- Distribution frequency: Monthly, quarterly, or annually
- Dividend growth: Is the payout increasing over time?
Fund Size and Liquidity
Larger funds typically have tighter bid-ask spreads, meaning you pay less to trade. This matters more for frequent traders than buy-and-hold investors, but it's worth checking.
How to Compare ETFs: Step-by-Step
Step 1: Identify Your Candidates
Start with a question: What role should this ETF play in your portfolio?
- Core US equity: VOO, VTI, SPY, IVV, ITOT
- Growth tilt: QQQ, VUG, SCHG, IWF
- Dividend income: SCHD, VYM, DVY, HDV, DGRO
- International: VXUS, IXUS, VEA, VWO
- Bonds: BND, AGG, SCHZ, VGSH
Not sure where to start? The ETF screener lets you filter 3,300+ ETFs by category, expense ratio, performance, and 20+ other criteria to narrow your list.
Step 2: Run a Head-to-Head Comparison
Go to the ETF comparison tool and enter your two candidates. You'll get a complete side-by-side breakdown including:
- Expense ratios and fund size
- 1Y, 3Y, 5Y, and 10Y total returns
- Top 10 holdings with weights
- Risk metrics (beta, standard deviation)
- Dividend yield and distribution info
The URL format is simple: marketxls.com/etfs/compare/TICKER1-vs-TICKER2. Try VOO vs VTI or SCHD vs VYM.
Step 3: Check for Overlap
If you're adding an ETF to an existing portfolio, make sure it's not just duplicating what you already own. Run your new candidate against your current holdings in the ETF overlap calculator.
A fund might look different on paper but hold 70% of the same stocks. That's not diversification — it's duplication with extra fees.
Step 4: Make Your Decision
Weight these factors based on your situation:
- Long-term buy-and-hold: Prioritize low expense ratio and broad diversification
- Income investor: Focus on yield, dividend growth, and payout consistency
- Active trader: Consider liquidity, bid-ask spreads, and options availability
- Tax-sensitive account: Look at tax efficiency and potential for tax-loss harvesting
Popular ETF Comparisons
Here are the matchups investors search for most often:
SPY vs QQQ
The classic. SPY gives you 500 large-cap US stocks across all sectors. QQQ concentrates on 100 Nasdaq-listed companies, heavily tilted toward tech. QQQ has higher returns in tech bull markets but drops harder in downturns. Compare SPY vs QQQ →
VOO vs VTI
Both from Vanguard, both dirt-cheap at 0.03%. VOO is S&P 500 only (large-cap). VTI is total market (adds mid-cap and small-cap). VTI gives slightly more diversification. In practice, their returns are very similar because large-caps dominate the total market index. Compare VOO vs VTI →
SCHD vs VYM
Two of the most popular dividend ETFs. SCHD is more concentrated (~100 stocks) and screens for dividend quality (growth, payout ratio). VYM is broader (~450 stocks) and simply picks high-yielding stocks. SCHD has outperformed historically but carries more concentration risk. Compare SCHD vs VYM →
QQQ vs VGT
Both are tech-heavy, but QQQ tracks the Nasdaq 100 (which includes consumer discretionary names like Amazon and Tesla), while VGT is pure technology sector. They overlap about 75% — check exact overlap with the ETF overlap tool. Compare QQQ vs VGT →
BND vs AGG
The two biggest US bond ETFs. Nearly identical in practice — both track broad US investment-grade bond indices. BND is slightly cheaper (0.03% vs 0.03%). Returns are almost indistinguishable. Pick whichever your brokerage offers commission-free. Compare BND vs AGG →
Comparing ETFs to Mutual Funds
Many investors hold mutual fund equivalents of popular ETFs — like VFIAX (Vanguard 500 Index Admiral Shares) instead of VOO. If you're deciding between the two, or looking to switch, you'll want to compare mutual funds with the same level of detail.
Use the mutual fund comparison tool to check overlap between mutual funds, or between a mutual fund and an ETF. The mutual fund screener can also help you find fund alternatives.
Finding the Best ETFs With a Screener
Sometimes you don't have two candidates to compare yet — you need to find them first. That's where the ETF screener comes in.
Filter 3,300+ ETFs by:
- Category: Large-cap, small-cap, international, sector, bond, commodity
- Expense ratio: Set a maximum to filter out expensive funds
- Returns: Minimum 1Y, 3Y, or 5Y performance
- Dividend yield: Filter for income-generating funds
- Fund size (AUM): Stick to larger, more liquid funds
You can also check the Top ETFs by Buy Score for a curated list ranked by a composite quality metric.
Once you have your shortlist, use the ETF comparison tool to pick the winner.
Explore More FundXLS Tools
- ETF Overlap Calculator — Find hidden holdings duplication between any two ETFs
- Fund Overlap Tool — Check overlap across ETFs and mutual funds to eliminate redundancy
- Mutual Fund Comparison — Compare mutual funds side-by-side with the same depth
- Mutual Fund Screener — Filter 7,000+ mutual funds by performance, fees, and category
Start Comparing ETFs Now
Stop guessing which ETF is better. Put them side-by-side and let the data decide.
Enter any two tickers and get a complete head-to-head comparison — expense ratios, returns, holdings, risk metrics, and more. Works for all 3,300+ US-listed ETFs.
