Convert Brokerage Statement to Excel and CSV
Upload a brokerage statement PDF and get a structured spreadsheet back in seconds. PDFXLSX reads the holdings and activity tables and exports every symbol, quantity, cost basis, and amount into separate Excel or CSV columns, so you can reconcile a 1099-B, track a portfolio, or import the data without retyping a single line.
Works with statements from Fidelity, Charles Schwab, Vanguard, E*TRADE, Merrill, Morgan Stanley, and Robinhood. Files are encrypted and deleted after conversion.
Drop your PDF here or click to browse
PDF files up to 50MB
First conversion is free. No software to install.
Holdings + Activity
Both tables extracted
<10s
Per statement
XLSX + CSV
Export formats
50MB
Max file size
Turn a locked brokerage PDF into spreadsheet data you can actually use
Brokerage statements pack a lot into a PDF: a holdings table with symbols, share counts, cost basis, and market values, plus an activity section listing buys, sells, dividends, interest, and fees. It all reads fine on screen, but try to pull it into Excel and the columns collapse. Symbols merge with descriptions, share quantities land next to dollar amounts, and a multi-account statement turns into an afternoon of cleanup.
This converter skips the retyping. It detects each table inside the statement, separates every field into its own column, and keeps quantities and dollar figures as real numbers and dates as real dates. The output opens straight in Excel, Google Sheets, or your tax software, ready to total realized gains, reconcile a 1099-B, or roll holdings into a portfolio tracker.
If you also handle checking, savings, or card documents, the same engine powers our bank statement to Excel converter and our credit card statement converter, so every account type lands in the same clean format.
| Symbol | Qty | Cost Basis | Market Value |
|---|---|---|---|
| AAPL | 120 | $14,880.00 | $23,412.00 |
| VTI | 85 | $19,210.50 | $24,905.75 |
| MSFT | 40 | $11,640.00 | $16,884.00 |
| BND | 200 | $14,520.00 | $14,210.00 |
| SCHD | 150 | $11,775.00 | $12,690.00 |
Built for the way advisors and tax pros use this data
Every feature targets the specific pain of pulling investment data out of a PDF statement.
Holdings and activity separated
Symbol, quantity, cost basis, and market value each land in their own column, and the transaction log comes out as a second clean table. No merged fields, no wrapped descriptions, no manual splitting.
Correct number and date types
Share counts, cost basis, and proceeds come out as numbers you can sum and pivot, not text. Trade dates are real Excel dates. Losses and debits keep their sign, so realized gain math stays correct.
Scanned statements work too
If your statement is a scan or an image-based PDF, built-in OCR reads it accurately and still returns structured rows. No retyping holdings from a printout.
Export to Excel or CSV
Download an XLSX for analysis or a CSV ready to import into tax software, a portfolio tracker, or your accounting system. Same clean data, your choice of format.
Multi-account and multi-page
Consolidated statements that span several accounts and run across many pages come back as one ordered dataset. Repeated headers are removed and rows stay in sequence from the first page to the last.
Private and secure
Your statement holds account numbers and balances. Files are encrypted in transit and at rest, processed in isolation, and deleted automatically after conversion. Nothing is stored or shared.
How to convert a brokerage statement to Excel
Three steps, no spreadsheet skills required.
Upload the PDF
Drag your brokerage statement into the box at the top of this page, or browse to select it. Monthly, quarterly, and year-end statements up to 50MB are supported.
Let it extract the tables
The engine finds the holdings and activity tables, identifies the symbol, quantity, cost basis, and amount columns, and applies OCR if the statement is scanned. Most files finish in under ten seconds.
Download Excel or CSV
Review the preview, then download a clean XLSX or CSV. Open it in Excel or Google Sheets, or import it into your tax software or portfolio tracker.
Who uses this converter
Anyone who has to account for investment activity and is tired of keying it in by hand. The tool earns its keep the first time you skip a manual 1099-B reconciliation or a quarter of portfolio entry.
-
Tax preparers and CPAs reconciling 1099-B figures, checking cost basis, and totaling realized gains across client accounts. See the workflow built for accountants.
-
Financial advisors and RIAs aggregating held-away accounts and building portfolio snapshots from statements clients send as PDFs.
-
Finance and operations teams rolling corporate investment and treasury accounts into one reporting spreadsheet. See the finance team workflow.
-
Individual investors tracking cost basis and performance across multiple brokerages in their own spreadsheet.
Brokerages we convert
Brokerage not listed? The converter reads the table structure, not a fixed template, so most US brokerage and 1099 composite statements work the same way.
Brokerage statement to Excel: common questions
Upload your statement PDF to the converter at the top of this page, let it extract the holdings and activity tables, and download the result as an Excel file. The whole process takes about ten seconds and needs no software. Each holding and transaction lands in its own row with symbol, quantity, cost basis, and amount in separate columns.
Yes. Convert the statement PDF here, then download a CSV or XLSX. Both open directly in Excel and Google Sheets, and the CSV imports into tax software and portfolio trackers. Because quantities and dollar amounts stay as numbers, you can total positions, calculate gains, and pivot the activity the moment the file opens.
The same way as any brokerage: download the statement PDF from your Fidelity or Schwab account, upload it here, and download the Excel or CSV output. The converter reads the table layout rather than a fixed template, so statements from Fidelity, Schwab, Vanguard, E*TRADE, Merrill, Morgan Stanley, and Robinhood all extract into the same clean column structure.
Yes, and it is one of the most common uses. Convert your year-end or 1099 composite statement to a spreadsheet, then compare the extracted proceeds and cost basis against the figures on your Form 1099-B. Having the trades in Excel makes it easy to spot missing lots, total short-term and long-term gains, and prepare the data your tax software needs.
Upload the statement and the converter pulls the cost basis column straight from the holdings table into its own spreadsheet field, next to the symbol, quantity, and market value. From there you can sort by position, calculate unrealized gain or loss, and verify the basis against what your broker reported. Always confirm the figures, since broker-supplied cost basis can be incomplete on transferred lots.
It is safe here because files are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once the conversion finishes. Your statement is never stored long term, shared, or used for any other purpose. Avoid free tools that keep uploads on unknown servers, since brokerage statements expose account numbers and holdings.
Related converters
Convert Bank Statement PDF to Excel in Seconds
Convert bank statement PDFs to Excel for fast reconciliation and bookkeeping. Preserves transaction dates, amounts, and descriptions.
Use casesConvert Invoice PDF to Excel for Faster Accounts Payable
Extract invoice data from PDF into Excel spreadsheets. Line items, totals, tax amounts, and vendor details parsed automatically.
Use casesExtract Data From PDF to Excel Without Errors
Extract data from PDF to Excel automatically. Pull structured data from any PDF document into organized spreadsheet columns and rows. No copy-paste errors.
Use casesConvert Financial Report PDF to Excel for Deep Analysis
Transform financial reports from PDF to Excel for pivot tables, charting, and variance analysis. Handles balance sheets and income statements.
Convert your brokerage statement now
Drop a PDF at the top of the page and download a clean Excel or CSV in seconds. Your first conversion is free.