22-second walkthrough
One PDF. Five spreadsheet rows. One ZIP.
A real production workflow with a synthetic vendor form and a five-row Excel workbook: match all nine fields, review every PDF, and export one ZIP.
- 1Review nine PDF fields once
- 2Match 9/9 Excel headers
- 3Approve five and export ZIP
PDF mail merge, without Word
How to fill multiple PDF forms from Excel
Keep the original PDF layout. Put column names in the first spreadsheet row and one customer, employee, vendor, or case in each row below it. JustFill creates a separate PDF for every selected row.
- 1
Upload the original PDF
Use an AcroForm, a flat PDF, or a scan. JustFill detects the fields before the merge.
- 2
Import XLSX or CSV
Dates, leading zeros, percentages, booleans, and spreadsheet headers are preserved for mapping.
- 3
Check the column mapping
Matching headers map directly. Ambiguous columns can use AI-assisted mapping.
- 4
Review and export
Approve the records you want and download individual filled PDFs in one ZIP.
Sample input
One contractor payout row becomes one populated 1099-NEC PDF
| Recipient Name & Account # | Box 1 Nonemployee Comp | Payer Entity & State Info |
|---|---|---|
| Jordan Lee Consulting LLC (V-2041) | $18,450.00 (Box 1) · $0.00 Fed WH | Apex Creative Agency Inc · PA / ID 84-2910441 |
| Elena Rostova Design Studio (V-2042) | $9,600.00 (Box 1) · $0.00 Fed WH | Apex Creative Agency Inc · CA / ID 84-2910441 |
| Summit Field Engineering LP (V-2043) | $42,125.00 (Box 1) · $0.00 Fed WH | Apex Creative Agency Inc · TX / ID 84-2910441 |
Recipient Name & Account #
Jordan Lee Consulting LLC (V-2041)
Box 1 Nonemployee Comp
$18,450.00 (Box 1) · $0.00 Fed WH
Payer Entity & State Info
Apex Creative Agency Inc · PA / ID 84-2910441
Click any spreadsheet row above to preview its generated PDF. All 3/3 columns auto-matched by AI.
Upload Form 1099-NEC, 1099-MISC, or W-9 PDF
Start with the official IRS Form 1099-NEC (Copy B for Recipient, Copy C for Payer, Copy 1/2 for State), Form 1099-MISC, or W-9 PDF.
Import your contractor payout CSV or XLSX
Map Payer name/address/TIN, Recipient name/address/TIN, Account Number, Box 1 Nonemployee Compensation, Box 4 Federal Tax Withheld, and Boxes 5–7 State details.
Verify every contractor copy and export ZIP
Inspect each generated 1099-NEC draft on the PDF canvas, fix vendor addresses or Box 1 totals inline, and download all approved PDFs in a single ZIP.
Where it fits
Built for January 1099 season, multi-entity bookkeepers, and AP contractor payouts.
When your 1099 vendor totals are already reconciled in Excel, QuickBooks, Xero, or a payroll CSV export, JustFill maps your Payer and Recipient columns directly onto official fillable or flat 1099-NEC (Copy B, Copy C, Copy 1, Copy 2) and 1099-MISC PDFs so you can review and export clean recipient and file copies in minutes.
32-second video walkthrough
Watch: Batch Fill 1099-NEC from Excel in 32 seconds
See the live browser workflow: upload one PDF template, import your Excel (.xlsx) or CSV spreadsheet, auto-match columns to detected PDF fields, preview every record, and download one filled PDF per row in a clean ZIP.
Simple pricing
Validate five synthetic contractor rows before importing your 1099 vendor ledger.
Download the ready-to-use 1099-NEC CSV template or run the 5-row guided sample. The $7 7-Day Pass unlocks up to 25 clean PDFs for a small contractor roster, while Starter ($19/mo), Pro ($49/mo), and Business ($99/mo) support 25, 100, and 500 contractors per batch.
$7 7-Day Pass — One-off batch up to 25 rows (25 clean PDFs in a batch ZIP + 25 AI credits, no subscription, $7 credited toward Starter)
Need recurring monthly runs, saved templates, and 125 clean output pages/month with AI column mapping? Choose $19/month Starter above.
Get $7 7-Day Pass (up to 25 rows)Running larger spreadsheet batches? Get Pro — $49/month for up to 100 rows per batch (or Business at $99/month for up to 500 rows).
Starter
Recommended first workflow
- AI field detection for 250 new pages per month
- Reusable templates — refills use no detection pages
- Up to 25 PDFs per batch
- 125 clean output pages per month
- Clean, watermark-free ZIP exports
- CSV and XLSX spreadsheet imports
- Review every record before export
Paid workflow
Reuse your calibrated 1099-NEC and W-9 templates across every client entity.
Bookkeepers and CPA firms managing multiple LLCs or S-Corps can save one calibrated 1099-NEC template and swap in each client entity’s vendor payout CSV to generate clean review packets.
Saved 1099-NEC & 1099-MISC field layouts
Map Payer block, Recipient block, Account Number, and Boxes 1–7 once and reuse across multiple client entities without re-running detection.
Same vendor CSV for W-9 collection & 1099-NEC prep
Use your master vendor spreadsheet both to collect missing Form W-9s before year-end and to populate 1099-NEC recipient copies in January.
Inline grid edits before ZIP export
Spot a missing suite number, LLCDBA line, or adjusted Box 1 total? Edit the cell directly in the browser preview table and export a clean ZIP.
Guardrails
Draft preparation with human review.
Clear boundaries
JustFill prepares PDF drafts (such as Form 1099-NEC Copy B, Copy C, Copy 1, and Copy 2) from data your organization or accounting practice provides. It does not e-file information returns with the IRS (FIRE/IRIS) or state agencies, does not produce special red-ink scannable paper Copy A forms, and does not provide tax advice.
Beyond manual uploads
Run the same PDF workflow from an AI agent or n8n.
The browser flow is the fastest way to validate a spreadsheet and PDF. Once the mapping works, the same JustFill account can expose PDF detection, filling, and saved templates through the hosted MCP endpoint.
ChatGPT, Claude and MCP
Give an agent a PDF, inspect detected fields, fill it, and save the reviewed layout for repeat use.
n8n automation
Trigger fills from a webhook, spreadsheet, CRM, or database and send the result to your next workflow node.
PDF Mail Merge Software
Browser-based PDF mail merge software to batch fill fillable, flat, and scanned PDFs without Acrobat plug-ins or VBA macros.
Fill Applications for Clients
Prepare recurring official forms, permits, and intake packets across client rosters from one structured spreadsheet.
Frequently asked questions
Which copies of IRS Form 1099-NEC can we batch-fill as PDFs?
You can batch-fill the official fillable PDF pages for Copy B (For Recipient), Copy 2 (To be filed with recipient’s state income tax return), Copy C (For Payer), and Copy 1 (For State Tax Department). Note that the IRS requires paper Copy A filings to use official red-ink scannable forms or electronic filing via IRS IRIS/FIRE.
Can we keep our Payer Name, Address, and EIN fixed across all contractor rows?
Yes. You can either pre-fill your Payer Name, Address, and TIN directly on the master 1099-NEC PDF template or repeat those columns across your CSV rows while varying the Recipient Name, Address, TIN, Account Number, and Box 1 amount per row.
Can we mask or truncate Recipient TINs on Copy B for security?
Yes. Because JustFill prints the exact string from your Excel or CSV cell, you can format your Recipient TIN column with IRS-permitted truncated taxpayer identification numbers (TTINs, such as ***-**-1234 or **-***1234) on recipient copies.
Does this also work with Form 1099-MISC, 1099-INT, 1099-DIV, and Form W-9?
Yes. You can upload any official IRS information return PDF (including Form 1099-MISC, 1099-INT, 1099-DIV, 1099-R, or 1095-C) or Form W-9 and batch-populate one PDF per spreadsheet row.
Should we test with synthetic contractor data first?
Yes. Click "Download Ready-to-Use CSV/Excel Template" or "Try the sample batch" to verify your Box 1–7 column mappings with synthetic data first, and only import records your organization is authorized to process.
Does it work with scanned or flat PDFs?
Yes. JustFill detects field locations in fillable, flat, and scanned PDFs before mapping spreadsheet columns.
Does each spreadsheet row create a separate PDF?
Yes. The first row contains the Excel or CSV column names. Every selected data row becomes one reviewable PDF in the exported ZIP.
Is this the same as Word mail merge?
It uses the same one-row-per-document idea, but fills your existing PDF directly. You do not need to recreate the form in Word or convert the PDF first.
Can I review results before downloading?
Yes. Each spreadsheet row becomes a reviewable record. Approve the records you want before creating the ZIP.
Does JustFill email the generated PDFs?
Not in the current self-service batch. It creates individual PDFs and packages the approved files in a ZIP for download.
What happens to uploaded documents?
Transfers use TLS. Rendered page images are deleted within 7 days and source documents within 30 days unless you save the PDF as a reusable template.