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 shipment row becomes one Bill of Lading PDF
| BOL Number | Consignee & Destination | Handling Units & Weight |
|---|---|---|
| BOL-2026-0411 | Ridgeline Flooring LLC (Lexington, KY) | 2 Pallets / 48 Cartons / 3,400 lb |
| BOL-2026-0412 | Bluegrass Kitchen & Bath (Louisville, KY) | 1 Pallet / 24 Cartons / 1,720 lb |
| BOL-2026-0413 | Tri-State Builders Depot (Cincinnati, OH) | 4 Pallets / 96 Cartons / 6,800 lb |
Upload your straight BOL PDF
Use your company BOL, a customer-required BOL, or our free fillable straight Bill of Lading template.
Import daily shipment rows
Map BOL number, ship date, shipper, consignee, carrier SCAC, pallet/package counts, NMFC class, weight, and special instructions.
Review and print/export ZIP
Check each BOL draft in the browser, adjust dock notes or weights inline, and download all approved BOL PDFs in a ZIP.
Where it fits
Built for daily LTL/TL shipping desks, 3PL warehouses, and customer-specific BOLs.
Use JustFill when your orders live in Excel, Shopify/ERP exports, or a WMS spreadsheet and you need to generate 20 to 500 clean, dock-ready Bills of Lading without retyping consignee addresses and NMFC lines.
Simple pricing
Test five shipment rows free before your next dock dispatch.
Download the BOL CSV template or run the 5-row guided sample. Your first AI column match is free; Starter ($19/mo), Pro ($49/mo), and Business ($99/mo) support 25, 100, and 500 shipments per batch.
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
Save your BOL layout once and run daily shipment exports in under two minutes.
Keep the same column headers in your daily WMS or ERP export. Reopen your saved BOL session each morning, drop in today’s CSV, and download the ZIP for the shipping dock.
Saved BOL template
Reuse exact field positions for your standard straight BOL or customer-mandated BOL layouts.
Inline dock-note editing
Add appointment numbers, PRO numbers, or liftgate instructions directly in the browser table before export.
Dock-ready ZIP output
Download clean, watermark-free PDFs ready to print for drivers or attach to carrier tenders.
Guardrails
Draft preparation with human review.
Clear boundaries
JustFill prepares Bill of Lading PDF drafts from shipment data your team provides. It does not determine NMFC freight classes, validate hazmat declarations under 49 CFR, tender loads to carriers, or issue carrier receipts.
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.
Frequently asked questions
Do we need our own Bill of Lading PDF to start?
You can upload your own company or customer-specific BOL PDF, or download our free 1-page straight Bill of Lading PDF template from /bill-of-lading and use it with the BOL CSV template on this page.
Can it handle flat or scanned customer-specific BOL forms?
Yes. JustFill detects fields on flat and scanned PDFs, lets you adjust and save the field layout once, and reuses that layout for every subsequent CSV batch.
Can we edit pallet counts or weights right before printing?
Yes. The inline spreadsheet grid in Batch Fill lets you edit any cell (such as actual scale weight or pallet count) and immediately updates the preview before you export the ZIP.
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.