PLAYBOOK P2

Import a portfolio from CSV

A whole portfolio in one go — after checking the three columns that cause most bad imports. — 6 steps

SCREEN
Portfolio → Add an asset → Import a CSV
METRIC
Holdings count, cost basis
PLAN
Investor

Checked against the app on 25 September 2026

Most brokers can export your trades or positions as a CSV file. The importer reads it, guesses which column is which — symbol, buy or sell, shares, cost and date — and shows every row in a grid you can edit before anything is saved. Only rows marked ready go in; the rest wait for you to fix or delete them. A transaction ledger with Debit and Credit columns works too: buys come from debits, sales from credits, and dividend, fee and interest rows are skipped.

Three columns cause most bad imports. Cost must be the total paid for the row, not the price per share: a file whose only money column is a per-share price imports a cost basis that's far too small. Dates decide which past dividends the app books, and a row without one is dated today. And the amounts have to be in the currency you tell the importer — each stock's own, or yours. Imported holdings don't update themselves afterwards. Importing is part of the Investor plan; on the free plan, add holdings one at a time instead.

Export from your brokerCheck the columnsFix the flagged rowsImport the ready ones

Nothing is saved until you press Import, and only rows marked ready go in.

DO IT IN THE APP

0 of 6 done
  1. Export your trade history — or, failing that, your current positions — from your broker as a CSV file.
  2. On Portfolio, choose Add an asset, Stocks, ETFs & funds, then Import a CSV, and choose the file. Open the importer →
  3. Under “We read your columns as”, check Symbol, Shares, Cost and Date point at the right columns. Paste your header row into the check below first if you're unsure.
  4. Under “Cost amounts are in”, say whether they're in each stock's own currency or yours.
  5. Fix or delete every row marked ⚠, then press Import. Leave “Replace existing portfolio” unticked unless you mean to delete what's already there.
  6. Compare the number of holdings and a couple of cost bases with your broker.
Open the CSV importer →

Educational content only. It is not personal financial advice.

TRY IT

Check a file's columns before you import

Paste the first line of your broker's CSV — the column names — and see how the importer will read it.

Or try a sample
Symbol
“Ticker”
Buy/Sell
“Action”
Shares
“Quantity”
Cost
“Price”
Date
“Date”

Cost is reading “Price”, which looks like a price per share. The importer treats Cost as the total paid for the row, so this would record a cost basis far too small. Once the file loads, point Cost at a column holding the total — or correct the Cost cells (price × shares) in the grid.

  • Not used: “Total”, “Currency”.
HOW IT'S WORKED OUT