YieldLens
Sign InStart Your Free Trial
?
Back to Help Center

Data & Imports Guide

How to export your data from your broker and import it into YieldLens.

How Imports Work

YieldLens automatically detects your broker and pre-fills the import settings — you can adjust them if needed. Just export the file directly from your broker using the steps below and upload it as-is. The importer supports both CSV and Excel (.xlsx) files and handles two types of data:

📊 Holdings Import

Your current positions — ticker symbols, number of shares, cost basis, and current value. Use this to get your portfolio into YieldLens.

📋 Transaction History Import

Past activity — dividends, buys, sells, interest, deposits, and transfers. Use this to populate your income history and dividend records.

Important: Do not modify your export file before uploading

YieldLens identifies your broker by reading the exact column headers in your file. If you rename, add, remove, or reorder columns — or delete header/footer rows — the importer may fail to detect your broker. Always upload the file exactly as your broker gave it to you.

Supported Brokers & How to Export

Follow the steps for your broker below. Each section shows where to find the export in your brokerage and which file type to use.

E*Trade / Morgan Stanley

Sync or Excel
E*Trade merged with Morgan Stanley on February 9, 2026. New exports come as Excel (.xlsx) files from the Morgan Stanley platform. Both old E*Trade CSV and new Morgan Stanley XLSX formats are fully supported.

Broker Sync (recommended)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose E*Trade and connect the sync connection
  3. Your positions, transactions, and dividends sync automatically

Positions Export (Excel)

  1. Log in and go to Accounts
  2. Select your account, then click the Positions tab
  3. Click Download or the export icon and save the file

Transaction History Export

  1. Go to Accounts > Activity
  2. Set your desired date range
  3. Click Download — this will download an Excel (.xlsx) file
  4. Upload that file directly to YieldLens

Margin (manual entry)

Margin balances aren’t imported from any broker. To track margin, enter your margin amount manually on the Margin page in YieldLens.

Fidelity

Sync or CSV

Broker Sync (recommended)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose Fidelity and connect the sync connection
  3. Your positions, transactions, and dividends sync automatically

Positions Export (CSV)

  1. Log in and go to Accounts & Trade > Portfolio
  2. Click Download (top right of the positions table)
  3. Select All Accounts or a specific account and download as CSV

Transaction History Export

  1. Go to Accounts & Trade > Activity & Orders
  2. Set your date range (up to 18 months at a time)
  3. Click Download and choose CSV

Note: Fidelity adds a "Pending Activity" footer row — YieldLens skips this automatically.

Charles Schwab

CSV

Positions Export

  1. Log in and click on your account
  2. Go to the Positions tab
  3. Click Export to download a CSV

Transaction History Export

  1. Click on your account and go to the History tab
  2. Set your desired date range
  3. Click Export to download as CSV

Note: Schwab is CSV import only — broker sync is not available for Schwab. Schwab also adds a "Transactions Total" row at the bottom of exports, which YieldLens skips automatically.

Robinhood

Sync only

Broker Sync (recommended)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose Robinhood and connect the sync connection
  3. Your positions, transactions, and dividends sync automatically
We don’t have a Robinhood file importer (their export doesn’t map cleanly to YieldLens). Connect via sync above, or use the Generic template on the Data Import tab to fill in your holdings/transactions and upload.

Tastytrade

Sync only

Broker Sync (recommended)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose Tastytrade and connect the sync connection
  3. Your positions sync automatically
We don’t have a Tastytrade file importer. Connect via sync above, or use the Generic template on the Data Import tab to fill in your holdings/transactions and upload.

Chase (J.P. Morgan)

Sync or Excel

Broker Sync (recommended)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose Chase and connect the sync connection
  3. Your positions, transactions, and dividends sync automatically

Excel Export

  1. Log in to Chase and select your investment account
  2. Go to Transactions, choose your transaction time frame, click Export, and choose Excel for the output

Webull

Sync or CSV
Webull’s sync reports balances only. Use a CSV export below for your holdings and orders. Webull exports don’t include dividend payments — add those via sync or manual entry.

Holdings Export (Positions)

  1. Open Webtrade and click Account on the left side of the page
  2. Choose Positions
  3. Choose your timeframe, then click Export — Webull emails you the file
  4. Upload it here and choose Webull → Holdings / Positions

Orders Export (buy/sell history)

  1. Export your Orders Records CSV from Webull
  2. Upload it here and choose Webull → Transaction History
  3. This brings in your buy/sell history and cost basis (orders don’t include dividends)

Interactive Brokers

Sync or CSV
Interactive Brokers connects and syncs your portfolio balance, but the sync only reports current positions — it does not share dividend transactions. For dividend income tracking, import your transaction history via CSV.

Broker Sync (portfolio only)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose Interactive Brokers and connect the sync connection
  3. Your current positions sync automatically (dividends are not included)

Transaction History Export (CSV)

  1. Log in and go to Transaction History
  2. Choose your time period
  3. Choose CSV download and upload the file to YieldLens

Public

Sync or CSV

Broker Sync (recommended)

  1. Go to the Broker Accounts tab in YieldLens
  2. Choose Public and connect the sync connection
  3. Your positions, transactions, and dividends sync automatically

Positions Export (CSV)

  1. Go to your Portfolio
  2. Click Customize
  3. Choose the Download tab
  4. Select All Investments or Direct Holdings
  5. Click Download — this downloads a CSV of your portfolio holdings only

Vanguard

CSV

CSV File Import

  1. On the dashboard, click Activity
  2. Click Create report
  3. Choose your start and end dates and choose CSV for the file output
  4. Click Create report, then upload the CSV here and choose Vanguard → Transaction History
Use the CSV, not the Excel export — Vanguard’s Excel transactions file leaves the ticker symbol off dividend rows, so it can’t be matched to your holdings. The CSV includes both holdings and transactions and keeps the ticker on every row.

Transaction Types We Recognize

When importing transaction history, YieldLens maps your broker's transaction labels to standard categories. Here is what gets imported and how it's classified:

Dividend

Cash dividends and qualified dividends paid on your holdings

Buy / Sell

Stock and ETF purchases and sales, including reinvestments

Interest

Interest income from bonds, money market, or margin interest received

Deposit / Withdrawal

Cash transfers in and out of your account (ACH, wire, etc.)

Transfer

Account-to-account transfers and ACATS transfers

Fee

Account fees, ADR fees, margin fees, and subscription fees

Capital Gain

Short-term and long-term capital gain distributions

Reinvestment

Dividend reinvestments (DRIP) are recorded as buys

Troubleshooting

My broker wasn't detected automatically

Make sure you haven't opened and re-saved the file in Excel or Numbers — this can change the column headers or encoding. Use the file exactly as downloaded from your broker.

Some transactions are missing after import

Your broker may use a transaction label we haven't seen before. Contact support with the specific transaction type shown in your export file and we'll add it.

Dividends are not showing up (Webull)

Webull’s Positions and Orders exports don’t include dividend payments. To track Webull dividend income, connect Webull via broker sync or add the dividends manually.

I imported holdings but my balances look wrong

Holdings imports update your positions but not your broker account balance. After importing, go to the Broker Accounts tab and update your Account Balance to match your current statement.

Can I re-import to update my holdings?

Yes. When you import a holdings file, you'll be asked whether to add to your existing holdings or replace them entirely. Use Replace if you want your holdings to reflect exactly what's in your latest export.

Ready to import?

Export your data from your broker using the steps above, then head to Data & Imports to upload.

Go to Data & Imports