Importing from Hargreaves Lansdown
Export your HL transaction history as CSV and import it to automatically build your portfolio records.
Last reviewed
Exporting your data from Hargreaves Lansdown
Hargreaves Lansdown allows you to download your transaction history as a CSV file from your online Client Area. Each account (ISA, SIPP, Fund and Share) must be exported separately.
How to export
- Sign in to your client area at www.hl.co.uk
- Navigate to My Accounts and select the account you wish to export
- Click “Download transactions”
- Choose CSV as the file format
- Select the date range you wish to include
- Click “Download” to save the file to your computer
Supported formats and columns
The import wizard recognises Hargreaves Lansdown exports in CSV format by these column headings: description, quantity, trade date, transaction category, value. The default currency is GBP.
Recognised transaction types
buy,purchase,switch in: recorded as Buysell,sale,switch out: recorded as Selldividend,distribution,income distribution: recorded as Dividendreinvest,reinvestment: recorded as Dividend reinvestmenttransfer in: recorded as Transfer intransfer out: recorded as Transfer outstock split: recorded as Stock splitbonus issue: recorded as Bonus issuecoupon: recorded as Couponaccrued interest paid: recorded as Accrued interest paidaccrued interest received: recorded as Accrued interest receivedredemption,maturity: recorded as Redemption
Costs
This export has no per-trade cost column, so no dealing charges are read from it.
Rows set aside
Some rows are recognised but not imported. The review step lists each one and why:
- Unrecognised action — not imported
- Cash transaction — not currently imported
- Date could not be read — not imported
- A number on this row could not be read — check it and add it by hand
Anything else in the Transaction Category column, including cash interest, platform charges and other corporate actions such as rights issues and mergers, is set aside rather than imported. The review step lists each one with the reason it was left out.
PDF statement support
HL statements can also be uploaded in PDF format. The import wizard supports PDF extraction using our self-hosted document processing system. Your financial documents never leave our servers without your approval. However, CSV is recommended for the most accurate and fastest import.
Step-by-step import
Once you have your HL CSV or PDF file ready, follow these steps to import it:
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Drag and drop your HL file, or click to browse (CSV or PDF supported)
- The system will automatically detect the HL format and parse your transactions
- Review the parsed transactions: rows that need attention carry a confidence badge
- Resolve any flagged items (unrecognised securities, low-confidence rows, or pence/pound discrepancies)
- Confirm the import to create your transaction records
Screenshot, for illustration only




Cost line-item extraction
The HL transaction CSV carries no per-trade cost columns: dealing commission and stamp duty reserve tax appear only on the PDF contract note, and platform fees and the annual management charge only on the PDF monthly statement. To capture itemised costs, upload the relevant PDF as well. Our document extraction system reads each charge and files it under the right cost type.
Common issues
Prices in pence rather than pounds
HL often quotes UK share prices in pence (GBX) rather than pounds (GBP). For example, a share priced at 1,250p rather than £12.50. Where the Unit Cost column is marked (p), the price is divided by 100 so it lands in pounds. If a price looks unusually high during review, it may be a pence value that carried no such marker. You can correct it manually during the review step.
No structured ticker symbols
Unlike some brokers, HL does not include ticker symbols or ISIN codes in its CSV exports. Securities are identified by description only (e.g. “Fundsmith Equity Fund I Acc”). The import wizard uses fuzzy matching to identify the correct security from the description. If a match cannot be determined automatically, you will be prompted to select the correct security during review.
Mixed account types
If you export from multiple HL accounts (ISA, SIPP, General Investment Account), import each file separately and use the account selector at upload to say which account it belongs to. Rows are still checked against your other uploads, so a trade that appears in two files is flagged rather than counted twice.
Reinvested dividends
HL records a reinvested dividend as its own category, which is imported as a reinvestment rather than a plain dividend. Where HL also prints a matching buy row for the shares acquired, both rows appear in review. They hold different amounts, so they are not treated as duplicates of one another. Remove whichever you do not want to keep before confirming.
Before you import
Dedicated reader: Hargreaves Lansdown files are read by a reader built for their layout, without AI.
These parts of the Statement import guide apply to every broker:
- Which files work: file types, size limit and plans
- Which statement to download: history, holdings or both
- Password-protected files: what we ask for and what we keep
- Number and date formats: decimal commas and day-first dates
- Currencies: base currency, statement rates, pence
- Checking your import: totals, holdings differences, gaps and duplicates
- Undoing an import: removing what one file added
- Fixing problems: what each import message means
Related pages
- Statement import overview: General guide for all supported brokers
- Portfolio transactions: Managing and editing your transaction history
- Portfolio overview: Understanding your portfolio dashboard
Can’t find what you’re looking for?
Our support team is here to help. Contact us and we’ll get back to you as soon as possible.
Contact us
