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 which broker your file came from — you do not need to manually map columns or configure anything. 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

CSV & XLSX
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.

Holdings Export

  1. Log in and go to Accounts
  2. Select your account, then click the Holdings 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 Export (optional)

If you have a margin account, you can also export your margin requirements file. YieldLens will detect it automatically and import your margin data.

Fidelity

CSV

Holdings Export

  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

Holdings Export

  1. Log in and click on your account
  2. Go to the Holdings 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 adds a "Transactions Total" row at the bottom — YieldLens skips this automatically.

Robinhood

CSV

Transaction History Export

  1. Open the Robinhood app or website and go to your Account
  2. Navigate to Statements & History
  3. Select Export account data and download the CSV
Robinhood does not provide a clean holdings export. For current positions, use the transaction history export which includes all activity including dividends.

Tastytrade

CSV

Holdings Export

  1. Log in and go to Positions
  2. Click the export/download icon to save as CSV

Transaction History Export

  1. Go to History > Transactions
  2. Set your date range
  3. Click Export to download a CSV

Both the current Transactions tab export and the older YTD/legacy download format are supported.

Chase (J.P. Morgan)

CSV

Holdings & History Export

  1. Log in to Chase and select your investment account
  2. Go to Account Activity
  3. Click Download Account Activity and choose CSV
  4. For holdings, look for a Positions or Portfolio download option

Webull

CSV
Webull exports data in separate files.

Webull splits your data across multiple export files. The Orders file only contains buy and sell trades — it does not include dividends or interest. For complete data, import each file separately:

Holdings Export

  1. In the Webull app, go to More > Account
  2. Tap Positions and look for a download or share option

Orders (Trades) Export

  1. Go to More > Account > Orders
  2. Select your date range and tap Export
  3. This file contains buys and sells only

Dividends Export (separate file)

  1. Go to More > Account > Dividends
  2. Export and upload this file separately to capture dividend income

Account Statement (recommended — all-in-one)

If available, your Webull account statement (Date, Description, Symbol, Qty, Amount format) includes all transaction types in a single file and is the easiest option.

Public

CSV
  1. In the Public app, go to your Account or Portfolio
  2. Look for a Download or Export option under history or statements
  3. Download as CSV and upload to YieldLens

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 Orders export does not include dividends. You need to also export and import your Dividends file separately — see the Webull section above.

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