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
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)
- Open the ETF's fund page on investor.vanguard.com — use the direct links in the table below. No login needed.
- Scroll to the "Portfolio composition" section and open the holdings view to see the securities the fund owns.
- 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.
Direct Links: Holdings Pages for Popular Vanguard ETFs
Each link goes straight to the fund's official Vanguard page, where the Portfolio composition section has the full holdings download:
| Ticker | Fund | Asset Class | Holdings |
|---|---|---|---|
| VTI | Vanguard Total Stock Market ETF | Total US Stock Market | Fund page |
| VOO | Vanguard S&P 500 ETF | S&P 500 Index | Fund page |
| VUG | Vanguard Growth ETF | US Large-Cap Growth | Fund page |
| VTV | Vanguard Value ETF | US Large-Cap Value | Fund page |
| VGT | Vanguard Information Technology ETF | US Technology Sector | Fund page |
| VXUS | Vanguard Total International Stock ETF | Total International Stock | Fund page |
| VEA | Vanguard FTSE Developed Markets ETF | Developed Markets ex-US | Fund page |
| VWO | Vanguard FTSE Emerging Markets ETF | Emerging Markets | Fund page |
| BND | Vanguard Total Bond Market ETF | Total US Bond Market | Fund page |
| VYM | Vanguard High Dividend Yield ETF | US High Dividend Yield | Fund page |
| VIG | Vanguard Dividend Appreciation ETF | US Dividend Growth | Fund page |
| VNQ | Vanguard Real Estate ETF | US 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 FreeFrequently 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.
Keep Reading
How to Export Your Portfolio from Any Brokerage (2026 Guide)
Step-by-step instructions for exporting your portfolio data from Fidelity, Schwab, Vanguard, Robinhood, E*TRADE, and Interactive Brokers. Learn about ...
Read articleBroker Integration Guides: Track Your Portfolio from Any Brokerage
Complete guides for exporting your portfolio data from major brokerages. Learn how to track investments from Fidelity, Schwab, Robinhood, Vanguard, E*...
Read articleHow to Track Your Vanguard Account Portfolio in 2026 (Free Tool)
Consolidate your personal Vanguard accounts — IRAs, 401(k)s, brokerage — in one dashboard. AI risk scores and rebalancing tips in 2 minutes, completel...
Read article