How to Convert a 1099-NEC PDF to CSV or Excel
Convert 1099-NEC tax form PDFs to CSV or Excel for easy import into tax software and accounting tools. AI-powered extraction in seconds.
If you are a freelancer, independent contractor, or self-employed professional, you likely receive multiple 1099-NEC forms each tax season. Each one arrives as a PDF, and when you need to consolidate income data from several clients, organize it for your accountant, or import it into tax software, you need that data in a spreadsheet. Converting your 1099-NEC PDFs to CSV or Excel solves this problem.
Quick Summary: Upload your 1099-NEC PDF to StubToCSV for instant AI-powered extraction. Get structured CSV or Excel data with all form fields — payer info, TIN, and nonemployee compensation — in under 30 seconds.
What Is a 1099-NEC?
The 1099-NEC (Nonemployee Compensation) is the IRS form used to report payments of $600 or more to independent contractors and freelancers. Starting in 2020, the IRS separated nonemployee compensation reporting from the 1099-MISC form, creating the dedicated 1099-NEC.
| Box | Field | What It Contains |
|---|---|---|
| Payer Info | Company name, address, TIN | Who paid you |
| Recipient Info | Your name, address, TIN | Your identifying information |
| Box 1 | Nonemployee compensation | Total amount paid to you |
| Box 2 | Payer made direct sales of $5,000+ | Rarely used |
| Box 4 | Federal income tax withheld | Only if backup withholding applied |
| Box 5 | State tax withheld | If applicable |
| Box 6 | State/payer’s state ID | State identification number |
| Box 7 | State income | State income amount |
Important: Box 1 is the critical field — it shows how much a client paid you during the tax year. When you have 5, 10, or 20 clients, manually adding up Box 1 from separate PDFs is tedious. A spreadsheet makes this a simple SUM formula.
Step-by-Step Conversion
-
Gather your 1099-NEC PDFs. Download them from client portals, email, or the IRS Transcript service. Collect all forms for the tax year.
-
Upload each PDF to StubToCSV. Visit the document converter and upload your 1099-NEC. Dual-AI extraction processes the form in under 30 seconds.
-
Review the extracted data. Check that payer name, TIN, and Box 1 amount match the original PDF.
-
Download as CSV or Excel. Get structured data ready for import into your tax software or accounting system.
-
Repeat for each 1099-NEC. Convert all forms, then consolidate into a single spreadsheet for a complete income summary.
Tip: Convert all your 1099-NECs before starting tax preparation. Having every form in one spreadsheet lets you verify your total self-employment income matches what you report on Schedule C.
Why Freelancers Need 1099-NEC Data in a Spreadsheet
Managing tax obligations as a freelancer means tracking income from multiple clients, calculating quarterly estimated taxes, and reconciling what was reported to the IRS against your own records.
| Task | With PDFs Only | With Spreadsheet Data |
|---|---|---|
| Sum total income | Open each PDF, write down amounts, add manually | SUM formula — instant |
| Compare to bank deposits | Side-by-side with PDF files | Filter and sort by payer |
| Prepare Schedule C | Reference each form individually | Total ready for line 1 |
| File quarterly estimates | Manual calculation each quarter | Running total updated as forms arrive |
| Share with accountant | Email stack of PDFs | Send one consolidated spreadsheet |
| Multi-year comparison | Dig through folders of PDFs | Sort by year and payer |
Handling Multiple 1099-NECs
The real value of conversion comes when you have multiple forms. Here is a workflow for consolidating several 1099-NECs:
- Convert each form to CSV or Excel using StubToCSV.
- Add each form’s data as a new row in a master spreadsheet.
- Add columns for payer name, EIN, and Box 1 amount at minimum.
- Create a total row that sums all Box 1 amounts.
- Compare the total to your Schedule C gross receipts.
Pro Tip: Your total 1099-NEC income will likely be less than your total self-employment income if any clients paid you less than $600 (which does not trigger a 1099) or if you earned income through platforms that issue 1099-K instead. Track all income sources, not just 1099-NEC amounts.
Common Issues When Converting 1099-NECs
Corrected forms. If a payer issues a corrected 1099-NEC, the corrected box will be checked at the top of the form. Make sure you convert the corrected version, not the original.
State reporting. Some 1099-NECs include state-specific information in Boxes 5-7. StubToCSV extracts these fields when present, which is helpful if you need to file state returns in multiple jurisdictions.
Missing 1099-NECs. Not all clients will send a 1099-NEC, particularly those who paid you less than $600. You are still required to report this income. Your converted 1099-NEC spreadsheet shows reported income, but supplement it with your own invoicing records for a complete picture.
Backup withholding. If Box 4 shows federal tax withheld, this means backup withholding was applied (usually 24%). Track this amount carefully — it is a credit on your tax return.
Security Considerations
1099-NEC forms contain your Social Security number or TIN. When converting these documents:
- Use a tool that processes in real-time and does not store your documents
- StubToCSV processes your form instantly and never saves or logs the file
- Avoid emailing 1099-NEC PDFs as unencrypted attachments
- A CSV extract (without the visual SSN layout) can be safer to share with your accountant than the raw PDF
Get Started
Convert your 1099-NEC forms to CSV or Excel with StubToCSV. AI-powered extraction reads every box accurately with dual verification. Process all your freelance tax forms in minutes instead of hours. Try it free — Pro plans available for tax season volume.