1099-B PDF to CSV: The Complete Guide

Your broker sends a 1099-B as a PDF. Your accountant wants a spreadsheet. You need it in Excel for your records. Here's how to bridge that gap.

Why Convert 1099-B to CSV?

A CSV file is the universal format for structured data. Once your 1099-B data is in CSV, you can:

• Send it to your CPA in a format they can actually work with
• Open it in Excel or Google Sheets for review and analysis
• Calculate your own totals to verify against the broker's summary
• Import into accounting software like QuickBooks or Xero
• Keep clean records for future reference or audits

Method 1: Manual Copy-Paste (Not Recommended)

You could open the PDF, select tables, and paste into Excel. Problems:

• Formatting breaks constantly — columns don't align
• "VARIOUS" dates and footnotes create extra rows
• Wash sale adjustments get lost in the noise
• A 100-transaction 1099-B takes 2-3 hours manually

Method 2: Generic PDF-to-Excel Tools

Tools like Adobe Acrobat, Tabula, or Smallpdf can extract tables from PDFs. They work decently for simple tables, but 1099-B forms are tricky:

• Multiple sections (short-term covered, long-term covered, noncovered) get merged
• Summary rows mix with transaction rows
• Security descriptions wrap across lines
• Different brokers format 1099-Bs completely differently

Method 3: AI-Powered Extraction (Recommended)

Purpose-built tools like 1099-B Converter use AI to understand the structure of your specific 1099-B, regardless of which broker issued it. The AI:

• Identifies each transaction individually
• Separates short-term from long-term
• Extracts wash sale adjustments correctly
• Normalizes dates, dollar amounts, and security names
• Outputs a clean CSV with consistent column headers

What Your CSV Should Contain

A proper 1099-B CSV should have these columns:

Column	Description
Date Acquired	When you bought the security (YYYY-MM-DD or VARIOUS)
Date Sold	When you sold it
Description	Security name and/or ticker
Quantity	Number of shares sold
Proceeds	What you received from the sale
Cost Basis	What you originally paid
Gain/Loss	Proceeds minus cost basis
Wash Sale Loss	Disallowed loss amount, if applicable
Type	Short-term or long-term

Verifying Your CSV

After conversion, always spot-check a few transactions against the original PDF:

1. Pick 3-5 transactions at random
2. Verify the proceeds and cost basis match exactly
3. Check that wash sale amounts are captured
4. Confirm the total proceeds matches the broker's summary

If everything checks out, you have a reliable CSV you can send to your CPA, import into tax software, or keep for your records.

FAQ

What columns should a 1099-B CSV have?

At minimum: date acquired, date sold, description, quantity, proceeds, cost basis, gain/loss, wash sale loss disallowed, and short-term vs long-term type. These map directly to the boxes your tax software and Form 8949 expect. A CSV missing cost basis or wash sale columns will force manual cleanup later.

Can I convert a 1099-B PDF to CSV for free?

Uploading and extracting is free, and so is checking the result — every conversion opens a full preview of the transactions pulled from your PDF. You pay the $8.99 only once the data looks right and you want the file itself. If the extraction misses something, you've spent nothing.

Will the CSV import into TurboTax, TaxAct, or H&R Block?

The CSV is a clean, standard format you can hand to a CPA or use as a reference. For direct software import, TXF is usually the better target — see the CSV vs TXF vs Excel comparison for which format each program prefers.

What if my 1099-B PDF is a scanned image?

If the PDF is a flat scan or photo with no selectable text, extraction quality drops sharply because there's no text layer to read. Ask your broker for the original digital 1099-B PDF from their tax documents portal — it will convert far more reliably.

How do I handle a 1099-B with hundreds of transactions?

Large 1099-Bs are exactly where manual entry breaks down. Conversion handles high transaction counts in one pass — see what to do with a 1099-B with too many transactions for the full workflow.

Is it safe to upload my 1099-B?

You never share broker login credentials — you only upload the PDF you already downloaded, which is far less exposure than tax software's direct-login import. The extraction reads the document and returns your formatted file.

---

Ready to skip the manual work? Try it on your 1099-B — upload the PDF, preview every transaction, and download clean CSV in under five minutes.