How to Convert Fidelity Statements to Excel & CSV (2026)
Fidelity Investments provides PDF statements for brokerage, cash management, and retirement accounts — but getting that data into a spreadsheet isn't straightforward. Fidelity's download options are limited, and their CSV exports often miss key data or require reformatting. Here's how to get clean, complete transaction data from your Fidelity statements into Excel or CSV.
Why Convert Fidelity Statements to Excel?
Fidelity PDF statements contain valuable transaction data across your investment accounts:
- Track investment performance — See buy/sell prices, dividends, and fees over time in sortable columns.
- Tax preparation — Extract cost basis, capital gains, and dividend income for tax filing.
- Portfolio analysis — Run your own calculations on asset allocation, contribution history, and returns.
- Import into accounting software — QuickBooks, Xero, and financial planning tools accept CSV and Excel imports.
Method 1: Use BankParse (Fastest — 30 Seconds)
The quickest way to convert a Fidelity PDF statement to Excel or CSV:
- Download your Fidelity statement — Log in to Fidelity.com, go to Accounts & Trade → Statements, and download the PDF for the period you need.
- Go to BankParse Fidelity Converter — No signup required.
- Upload your PDF — Drag and drop your Fidelity statement or click to browse.
- Download your Excel or CSV — All transactions are extracted with dates, descriptions, and amounts. Click CSV or Excel to download.
This works with Fidelity brokerage statements, cash management account statements, and retirement account (IRA, 401k) statements.
Method 2: Fidelity's Built-in Download
Fidelity does offer some export options within their Activity & Orders section:
- Log in to Fidelity.com and go to Activity & Orders.
- Select your date range and account.
- Click the Download icon (arrow pointing down).
- Choose CSV format.
Limitations: This export only includes recent activity (not full statement data), may not include running balances, and only covers the current account view — not the comprehensive statement format. For complete statement data, convert the PDF directly with BankParse.
Method 3: Copy and Paste (Manual)
For a quick one-off extraction:
- Open your Fidelity PDF statement in a PDF viewer.
- Select the transaction table and copy (Ctrl+C / Cmd+C).
- Paste into Excel or Google Sheets.
- Clean up formatting — this usually requires significant manual work to align columns properly.
This method is tedious and error-prone, especially for statements with many transactions or complex multi-line descriptions.
What Data Gets Extracted?
When you convert a Fidelity statement with BankParse, you get:
- Transaction dates — Settlement and trade dates
- Descriptions — Security names, transaction types (buy, sell, dividend, transfer)
- Amounts — Dollar amounts for each transaction
- Running balance — Account balance after each transaction (when available)
Frequently Asked Questions
Can I convert Fidelity 401k statements?
Yes. BankParse works with any Fidelity PDF statement, including 401(k), IRA, brokerage, and cash management accounts. Download the PDF from Fidelity's Statements section and upload it.
How far back can I get Fidelity statements?
Fidelity typically provides statements going back 10+ years through their online portal. Go to Accounts & Trade → Statements to access your full archive.
Does this work with Fidelity NetBenefits?
Yes. If you can download a PDF statement from Fidelity NetBenefits (employer-sponsored plans), BankParse can convert it to Excel or CSV.