How to Export Your Portfolio from Any Brokerage

Whether you're switching brokerages, consolidating accounts, preparing taxes, or just want a clearer picture of your investments, the first step is always the same: export your portfolio data. Every major brokerage lets you download your holdings as a file—but the exact steps vary. This guide walks you through the process for Fidelity, Charles Schwab, Vanguard, Robinhood, E*TRADE, and Interactive Brokers, and shows you what to do with your data once you have it.

Why Export Your Portfolio Data?

Your brokerage gives you a view of what you own, but that view is limited to a single account. If you hold investments across multiple brokerages—a 401(k) at Fidelity, a Roth IRA at Vanguard, a taxable account at Schwab—you have no unified picture of your total portfolio. Exporting your data lets you:

Common Export Formats

Brokerages offer several file formats for exporting data. Here are the most common:

Broker-by-Broker Export Instructions

Jump to your brokerage: Fidelity | Schwab | Vanguard | Robinhood | E*TRADE | Interactive Brokers

Fidelity

Fidelity CSV exports include ticker symbols, quantities, cost basis, current value, and gain/loss. Transaction history can be exported from the Activity & Orders tab in 90-day increments. For a detailed walkthrough, see our Fidelity portfolio tracking guide.

Charles Schwab

Schwab exports include all positions from your selected account, including those migrated from TD Ameritrade. Transaction history is available under History & Statements. See our Schwab portfolio tracking guide for more details.

Vanguard

Vanguard exports cover all account types including IRAs, 401(k)s, and brokerage accounts. For OFX format (useful for Quicken), go to Account Activity and select the OFX download option. Our Vanguard tracking guide covers the full process.

Robinhood

For a complete walkthrough including tips for exporting crypto and options positions, see our Robinhood portfolio tracking guide.

E*TRADE (Morgan Stanley)

E*TRADE exports include stock, ETF, and mutual fund positions with cost basis and market values. For transaction history, go to Accounts → Transaction History and select your date range. See our E*TRADE tracking guide for the full process.

Interactive Brokers (IBKR)

Interactive Brokers offers the most flexible export options of any brokerage, supporting CSV, XML, and custom Flex Query formats. See our IBKR portfolio tracking guide for a deep dive.

What to Do with Your Exported Data

Once you have your CSV file, the next step is to turn raw data into actionable insights. You can open it in a spreadsheet, but you'll miss out on automated risk analysis, diversification scoring, and AI-powered recommendations. Once you've exported your data, see our Fidelity portfolio tracker guide for next steps. Here's how to get the most out of your export:

Consolidating Multiple Brokerage Accounts

If you have accounts at more than one brokerage, export a CSV from each one and import them as separate portfolios. Portfolio Genius shows you a consolidated view across all accounts, catching problems like:

• Duplicate holdings—owning the same stock or overlapping ETFs in multiple accounts
• Hidden concentration—total exposure to a single sector or stock that isn't obvious when viewing accounts separately
• Tax-inefficient placement—holding high-dividend assets in taxable accounts instead of tax-advantaged ones
• Allocation drift—your actual allocation across all accounts has shifted away from your target

For a real-world example of how consolidation reveals hidden risks, read our multi-broker consolidation case study.

Skip the Export: Automated Portfolio Syncing

Manual CSV exports work, but they require re-exporting every time you make a trade. If you want automatic syncing, consider connecting an Alpaca brokerage account. Alpaca integrates directly with Portfolio Genius, providing:

• Automatic position syncing—no manual exports
• Direct trade execution from AI recommendations
• Commission-free stock trading
• Paper trading mode to test strategies without real money

Many investors keep their existing brokerage accounts for retirement funds and employer plans, while using Alpaca for active trading with AI-powered assistance.

Frequently Asked Questions