How to Convert a 1099-DIV PDF to CSV or Excel
Convert 1099-DIV dividend income tax forms from PDF to CSV or Excel. AI extraction captures qualified dividends, capital gains, and more.
If you hold stocks, mutual funds, or ETFs in taxable brokerage accounts, you receive 1099-DIV forms each year reporting your dividend and capital gains distributions. These forms can be complex, especially if you hold funds that distribute different types of income. Converting your 1099-DIV PDFs to CSV or Excel makes it much easier to consolidate data across brokerages, categorize income types correctly, and prepare an accurate tax return.
Quick Summary: Upload your 1099-DIV PDF to StubToCSV for instant AI extraction. All boxes — ordinary dividends, qualified dividends, capital gains distributions, foreign tax paid, and more — are extracted with dual verification. CSV or Excel in under 30 seconds.
1099-DIV Boxes Explained
The 1099-DIV reports multiple types of investment income, each taxed differently. Understanding these categories is essential for accurate tax reporting.
| Box | Field | Tax Rate | Where to Report |
|---|---|---|---|
| Box 1a | Total ordinary dividends | Ordinary income rates | Schedule B / 1040 Line 3b |
| Box 1b | Qualified dividends | Preferential capital gains rates (0%, 15%, 20%) | 1040 Line 3a |
| Box 2a | Total capital gain distributions | Long-term capital gains rates | Schedule D |
| Box 2b | Unrecaptured Section 1250 gain | Up to 25% | Schedule D worksheet |
| Box 3 | Nondividend distributions | Return of capital (not taxed immediately) | Reduces cost basis |
| Box 4 | Federal income tax withheld | Credit on return | Backup withholding |
| Box 5 | Section 199A dividends | May qualify for QBI deduction | Form 8995 |
| Box 7 | Foreign tax paid | Credit or deduction | Form 1116 or Schedule A |
| Box 11 | Exempt-interest dividends | Federally tax-exempt | 1040 Line 2a |
| Box 12 | Specified private activity bond dividends | May trigger AMT | Form 6251 |
Important: Box 1b (qualified dividends) is a subset of Box 1a (total ordinary dividends), not an additional amount. A common error is adding them together, which overstates your dividend income.
Step-by-Step Conversion
-
Download your 1099-DIV PDFs. Get them from each brokerage account where you hold dividend-paying investments. Most brokerages make these available in January or February.
-
Upload to StubToCSV. Visit the converter and upload your 1099-DIV PDF.
-
Dual-AI extraction runs. Both AI models read and verify every box on your form. Under 30 seconds.
-
Download as CSV or Excel. Structured data with all boxes labeled and values extracted.
-
Consolidate across brokerages. If you have accounts at Fidelity, Schwab, Vanguard, and others, convert each form and merge into one master spreadsheet.
Why Investors Need Dividend Data in a Spreadsheet
| Need | PDF Approach | Spreadsheet Approach |
|---|---|---|
| Total dividend income | Add up Box 1a from each PDF manually | SUM formula — instant |
| Qualified vs. ordinary split | Track ratio from each form separately | Calculate portfolio-wide ratio |
| Foreign tax credit | Reference each form for Box 7 | Sum for Form 1116 |
| Schedule B preparation | List each payer manually | Copy directly from spreadsheet |
| Year-over-year income tracking | Compare individual PDFs | Charts and trend analysis |
| Tax-loss harvesting analysis | No data integration | Combine with 1099-B data |
Tip: If your total ordinary dividends (Box 1a across all forms) exceed $1,500, you must file Schedule B. Having all your 1099-DIV data in a spreadsheet makes completing Schedule B straightforward.
Handling Consolidated 1099s
Many brokerages issue a consolidated 1099 that combines 1099-DIV, 1099-INT, 1099-B, and sometimes 1099-OID data into one multi-page document. These consolidated forms can be 10-50 pages long.
StubToCSV’s AI extraction reads the 1099-DIV section within consolidated statements and extracts the relevant data regardless of how it is formatted or where it appears in the document.
Common consolidated 1099 issuers include:
- Fidelity — Combined 1099 with summary and detail pages
- Charles Schwab — Consolidated 1099 with investment income summary
- Vanguard — 1099-DIV included in annual tax document package
- TD Ameritrade / Schwab — Merged formats during transition
Key Considerations for Dividend Income
Qualified vs. ordinary dividends. The tax difference between qualified and ordinary dividends can be substantial. Qualified dividends are taxed at preferential rates (0%, 15%, or 20%), while ordinary dividends are taxed at your marginal income tax rate. Your spreadsheet should clearly separate these.
Section 199A dividends. REIT dividends reported in Box 5 may qualify for the 20% qualified business income deduction. Track these separately — the tax savings can be significant for investors with substantial REIT holdings.
Return of capital (Box 3). Nondividend distributions reduce your cost basis rather than being taxed as current income. If you do not track these adjustments, you will overpay capital gains tax when you eventually sell the shares. A spreadsheet helps you maintain accurate cost basis records.
Foreign tax paid (Box 7). You can claim either a foreign tax credit or a deduction for foreign taxes paid on international dividends. The credit is usually more valuable. Sum Box 7 across all forms for your total foreign tax credit amount.
Pro Tip: After converting all your 1099-DIV forms, calculate your portfolio’s qualified dividend ratio (Box 1b total divided by Box 1a total). If it is below 60-70%, you may want to review your holdings — shifting to more tax-efficient funds can significantly reduce your dividend tax burden.
Get Started
Convert your 1099-DIV forms to CSV or Excel with StubToCSV. AI-powered dual extraction handles every box, every brokerage format, and consolidated 1099 statements. Try it free — Pro plans for investors with multiple accounts.