Convert Fidelity 1099-B to Excel / Google Sheets (CSV)
Upload your Fidelity Investments 1099-B PDF and we'll convert it to a CSV file ready for Excel / Google Sheets. Wash sales and 100+ transactions handled automatically.
Why Fidelity 1099-Bs Don't Import Cleanly Into Excel / Google Sheets
Every broker formats their 1099-B differently. Here's what trips up Excel / Google Sheets users with Fidelity Investments statements.
Fidelity 1099-B PDFs span 30+ pages for active traders, with transactions split across multiple sections (covered, non-covered, undetermined).
Options assignments and exercises appear in their own sub-tables that most importers skip entirely.
Cost basis adjustments for DRIP shares are listed in supplemental notes, not in the main transaction rows.
Upload PDF
Drop your 1099-B
AI Extracts
Reads every transaction
Download
CSV, TXF, and Excel
Import
TurboTax, H&R Block
How to Import Your CSV Into Excel / Google Sheets
After downloading the file from our converter, follow these steps in Excel / Google Sheets.
-
1
Open Excel or Google Sheets and create a new blank spreadsheet.
-
2
Use File → Import (Sheets) or Data → From Text/CSV (Excel) and select the downloaded file.
-
3
Confirm comma as the delimiter and 'Detect data type automatically' for proper formatting.
-
4
Each row is a single transaction with all fields needed for Form 8949.
-
5
Send to your CPA or use it as the source of truth for manual tax entry.
Frequently Asked Questions
Does this work for Fidelity Investments?
Yes. Our AI extractor reads every text-based 1099-B PDF from Fidelity Investments, including consolidated statements with multiple sections, and outputs a CSV file formatted for Excel / Google Sheets.
How is this different from Excel / Google Sheets's built-in Fidelity import?
Direct broker imports often fail with 100+ transactions, miss wash sale adjustments, or refuse to load consolidated statements. We bypass that by reading the PDF directly and producing a clean CSV file.
Is my data secure?
Your PDF is processed in memory and immediately deleted. The extracted text is sent to our AI service over an encrypted connection. No files or financial data are stored after your session ends.
What does it cost?
Free for your first 3 conversions per month. CSV downloads (which Excel and Google Sheets read natively) are always free.
What about wash sales and adjusted cost basis?
We extract wash sale loss disallowed amounts and adjusted cost basis exactly as reported on your Fidelity Investments 1099-B. The output file preserves these adjustments so Excel / Google Sheets handles Form 8949 correctly.
Related Guides
Fidelity 1099-B to TurboTax: How to Import When It Fails
Fidelity is one of the most popular brokerages for individual investors, and every year millions of Fidelit...
Read guideCSV vs TXF vs Excel: Which Format for Your 1099-B?
You just converted your 1099B PDF into something usable. But now you're staring at three download options —...
Read guideForm 8949 From 1099-B: Everything You Need to Know
Tax season means reconciling broker statements with IRS forms that seem designed to confuse. Your broker se...
Read guideReady to Convert Your Fidelity 1099-B?
Upload once and download your CSV for Excel / Google Sheets in under a minute.