Back to Blog

Vanguard ETF Full Holdings: How to Download the Complete Portfolio File

Get the full holdings list for VTI, VOO, VGT, or any other Vanguard ETF as a spreadsheet file — no account required

July 12, 20265 min read

Portfolio Genius Team

AI Portfolio Management Experts · Quantitative finance and portfolio optimization

Vanguard publishes the complete portfolio holdings of every one of its ETFs — the full list of stocks or bonds inside the fund, with weights — as a downloadable file on each fund's page. You don't need a Vanguard account, and it takes about a minute once you know where to look. Here are the exact steps, direct links to the most popular funds, and the official sources to use if you need point-in-time data for research.

Looking for your own account data instead? This guide covers downloading a Vanguard fund's holdings (the stocks inside VTI, VOO, etc.). If you want to export the positions in your personal Vanguard brokerage, IRA, or 401(k) account, see our guide on how to export and track your Vanguard account.

How to Download the Full Holdings File (3 Steps)

  1. Open the ETF's fund page on investor.vanguard.com — use the direct links in the table below. No login needed.
  2. Scroll to the "Portfolio composition" section and open the holdings view to see the securities the fund owns.
  3. Use the export/download option above the holdings table to save the complete list as a spreadsheet (CSV) file. The on-page table is paginated — the exported file contains every position.

Why the holdings date looks a month old

Vanguard discloses complete ETF holdings monthly, typically about 15 calendar days after month-end — not daily like most other ETF issuers. That's because Vanguard's ETFs are structured as share classes of its mutual funds, which follow mutual-fund disclosure rules. Check the "as of" date shown above the holdings table.

Each link goes straight to the fund's official Vanguard page, where the Portfolio composition section has the full holdings download:

TickerFundAsset ClassHoldings
VTIVanguard Total Stock Market ETFTotal US Stock MarketFund page
VOOVanguard S&P 500 ETFS&P 500 IndexFund page
VUGVanguard Growth ETFUS Large-Cap GrowthFund page
VTVVanguard Value ETFUS Large-Cap ValueFund page
VGTVanguard Information Technology ETFUS Technology SectorFund page
VXUSVanguard Total International Stock ETFTotal International StockFund page
VEAVanguard FTSE Developed Markets ETFDeveloped Markets ex-USFund page
VWOVanguard FTSE Emerging Markets ETFEmerging MarketsFund page
BNDVanguard Total Bond Market ETFTotal US Bond MarketFund page
VYMVanguard High Dividend Yield ETFUS High Dividend YieldFund page
VIGVanguard Dividend Appreciation ETFUS Dividend GrowthFund page
VNQVanguard Real Estate ETFUS Real Estate (REITs)Fund page

Holding a different Vanguard ETF? The URL pattern is the same for every fund: investor.vanguard.com/investment-products/etfs/profile/<ticker>

What's in the Holdings File

The exported file lists every security the fund holds as of the disclosure date. For an equity fund you'll typically get each holding's name and ticker, the number of shares the fund owns, the position's market value, and its percentage weight in the fund. For a fund like VTI that's several thousand rows — which is exactly why the download beats paging through the website table.

Official Sources for Research-Grade Holdings Data

If you need audited, point-in-time portfolio schedules — for quantitative research, backtesting, or academic work — go beyond the fund page:

SEC N-PORT filings (EDGAR)

Every registered fund files complete portfolio holdings with the SEC quarterly on Form N-PORT, in machine-readable format. Search for the fund on EDGAR full-text search. This is the authoritative source for historical, point-in-time holdings.

Annual & semiannual reports

Each fund's shareholder reports include a full schedule of investments, available on the fund's Vanguard page under literature/reports or on EDGAR.

Vanguard's advisor site

advisors.vanguard.com publishes fund data aimed at financial professionals, including downloadable holdings information for the same funds.

What Most People Do Next: Check Fund Overlap

The most common reason investors pull holdings files is to answer one question: how much do my funds overlap? VTI and VOO, for example, share their large-cap holdings almost entirely — owning both concentrates your portfolio more than the two tickers suggest. You can compare exported files in a spreadsheet, but it's tedious for funds with thousands of positions.

Skip the spreadsheet work

Add your ETF positions to Portfolio Genius (free, no signup required to try) and it detects fund overlap, breaks down your true sector and geographic exposure, and flags concentration risk automatically.

Analyze Your ETF Overlap Free

Frequently Asked Questions

How often does Vanguard publish full ETF holdings?

Vanguard discloses complete ETF holdings monthly, typically with a lag of about 15 calendar days after month-end. Unlike most ETF issuers that disclose holdings daily, Vanguard's ETFs are structured as share classes of its mutual funds, so they follow mutual-fund-style monthly disclosure. The as-of date is shown at the top of the holdings section on each fund page.

How do I download the complete list of stocks in VTI or VOO?

Open the fund's page on investor.vanguard.com, scroll to the Portfolio composition section, open the holdings view, and use the export or download option to save the full list as a spreadsheet file. No Vanguard account is required.

Why doesn't the fund page show all of the holdings?

The on-page holdings table is paginated and only shows a portion of the portfolio at a time — for a fund like VTI that holds thousands of stocks, browsing page by page is impractical. The exported holdings file contains every position in the fund.

Where can I get official point-in-time holdings data for research?

For official, point-in-time portfolio schedules, use the fund's N-PORT filings on SEC EDGAR, which disclose complete portfolio holdings quarterly in a machine-readable format. Annual and semiannual shareholder reports also include full schedules of investments. These are the authoritative sources for academic or quantitative research.

How do I check how much my Vanguard ETFs overlap with each other?

Funds like VTI and VOO share most of their large-cap holdings, so owning both can concentrate your exposure more than expected. Rather than comparing holdings files by hand, you can import your portfolio into a tool like Portfolio Genius, which detects fund overlap and shows your true exposure across positions.

Share this article
Related Articles

Keep Reading

Portfolio Genius LogoPortfolio Genius

© 2026 Teralyt Software LLC. All rights reserved.