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 claim row becomes one populated CMS-1500 or UB-04 claim PDF
| Patient & Subscriber ID (Boxes 1a–5) | ICD-10 & CPT/HCPCS (Boxes 21 & 24) | Billing Provider & NPI (Boxes 25–33) |
|---|---|---|
| Vance, Marcus E. · ID: HKA-9041822 | ICD-10: M54.50 · CPT 99214 ($185.00) | Metro Orthopedics PLLC · NPI 1497821045 |
| Rostova, Elena K. · ID: UHC-7710493 | ICD-10: J01.90 · CPT 99213 ($135.00) | Metro Orthopedics PLLC · NPI 1497821045 |
| Mendoza, Carlos A. · ID: BCB-5529018 | ICD-10: S83.511A · CPT 29888 ($2,450.00) | Lone Star Ambulatory Surgery · NPI 1821094432 |
Patient & Subscriber ID (Boxes 1a–5)
Vance, Marcus E. · ID: HKA-9041822
ICD-10 & CPT/HCPCS (Boxes 21 & 24)
ICD-10: M54.50 · CPT 99214 ($185.00)
Billing Provider & NPI (Boxes 25–33)
Metro Orthopedics PLLC · NPI 1497821045
Click any spreadsheet row above to preview its generated PDF. All 3/3 columns auto-matched by AI.
Upload your CMS-1500 (HCFA) or UB-04 PDF template
Start with a standard CMS 1500 fillable PDF (Boxes 1–33) or a UB 04 form PDF (CMS-1450 Form Locators 1–81), whether interactive AcroForm or flat.
Import your billing export from Excel or CSV
Run an HCFA 1500 batch fill from CSV or XLSX by mapping patient demographics, insured ID, ICD-10 diagnosis pointers (Box 21), CPT/HCPCS service lines (Box 24A–J), tax ID, and rendering/billing NPI (Boxes 25–33).
Inspect every claim on the canvas and export a ZIP
Verify box alignment, modifiers, charges, and NPI numbers on each generated claim draft before downloading a clean ZIP for printing or payer portal upload.
Where it fits
Built for medical billing claim PDF automation — HCFA 1500 batch fill from CSV and UB-04 institutional runs.
When out-of-network payers, workers’ compensation carriers, auto/PIP insurers, secondary payers, or paper appeal packets require a clean CMS 1500 fillable PDF (02/12 edition, Boxes 1–33) or UB 04 form PDF (CMS-1450, Form Locators 1–81), JustFill turns your practice management or EHR spreadsheet export into individual, print-ready claim PDFs in one batch.
Simple pricing
Validate your claim column mapping with five synthetic rows first.
Test the 5-row guided sample in your browser with synthetic data. Your first AI column match is free; Starter ($19/mo), Pro ($49/mo), and Business ($99/mo) include 125 clean output pages per month on Starter and support 25, 100, and 500 claims 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
Calibrate Boxes 1–33 (CMS-1500) or FL 1–81 (UB-04) once and reuse for every billing cycle.
Save your reviewed CMS-1500 or UB-04 field geometry as a template. Keep your billing provider NPI, taxonomy, facility address, and EIN fixed while importing each week’s claim CSV.
Saved Box 1–33 & FL 1–81 coordinate templates
Preserve exact field placement across all 33 boxes of CMS-1500 and 81 form locators of UB-04 without re-running detection on repeat batches.
Inline grid editing for modifiers & ICD-10 pointers
Adjust a CPT modifier, units, charge amount, or prior authorization number in the browser grid before exporting the ZIP.
Clean ZIP or Interactive AcroForm export
Export flattened print-ready PDFs for payer submission or interactive AcroForm PDFs when billers need final manual edits.
Guardrails
Draft preparation with human review.
Clear boundaries
JustFill is a PDF drafting utility. It is not a healthcare clearinghouse, medical coding service, or HIPAA covered entity, does not validate CPT/HCPCS or ICD-10-CM coding accuracy, does not determine medical necessity, and does not transmit EDI 837P/837I claims to payers. Use synthetic data during initial template setup and process only data your organization is authorized to handle.
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
How does HCFA 1500 batch fill from CSV work with a CMS 1500 fillable PDF?
Upload your CMS 1500 fillable PDF (or flat CMS-1500 template) to JustFill, import your CSV or Excel file where each row represents one claim, and map your columns to Boxes 1–33 (patient info, subscriber ID, ICD-10 codes in Box 21, CPT/HCPCS lines in Box 24, and provider NPI/TIN in Boxes 25–33). Preview each claim in the browser and export all populated PDFs in one ZIP.
Does JustFill also support the UB 04 form PDF (CMS-1450) for institutional claims?
Yes. You can upload a UB 04 form PDF (CMS-1450), auto-detect or calibrate Form Locators 1 through 81 (including revenue codes, HCPCS rates, value codes, and attending/operating provider NPIs), save the layout as a reusable template, and batch-populate institutional claims from Excel or CSV.
Can we keep our Billing Provider Name, Address, EIN, and NPI (Boxes 25, 32, and 33) constant across every claim?
Yes. Include your standard facility and billing provider columns in your CSV export or pre-fill them on your saved template so every generated CMS-1500 or UB-04 PDF automatically carries your practice’s EIN, NPI, and taxonomy code.
Does JustFill submit claims electronically to Medicare or commercial clearinghouses?
No. JustFill is a browser-based medical billing claim PDF automation tool that generates populated PDF files in a ZIP for paper mailing, faxing, payer portal upload, or appeal packets.
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.