Batch Fill I-9 Forms for Seasonal Hiring (2026 Guide)
You can batch fill Section 1 of the USCIS Form I-9 from an Excel roster of seasonal hires. Map your columns — last name, first name, date of birth, address, SSN, citizenship status — to the official fillable I-9 once in Power PDF Filler, save the mapping as a template, and generate one pre-filled PDF per row. The employee still reviews, attests, and signs Section 1 themselves, and the employer still completes Section 2 after physically examining documents within three business days of the start date. Pre-filling removes the transcription work; it does not remove the examination.
The seasonal hiring problem
Seasonal hiring is not just more hiring. It is the same paperwork, compressed.
A retail chain onboarding 300 holiday associates across 40 stores, an agricultural operation bringing on a harvest crew, a hospitality group staffing a summer resort, a logistics company adding drivers before peak — all of them face the same shape of problem. Every worker needs Section 1 of the I-9 completed on or before their first day, and every worker needs Section 2 completed by the employer within three business days of that start date. Not spread over a quarter. Within the same week.
The bottleneck is almost never the part that requires judgment. Examining someone’s driver’s license and Social Security card takes a couple of minutes and cannot be automated away. The bottleneck is the twenty minutes per person of hand-typing demographics that you already have — because the worker gave you their name, address, and date of birth on the application weeks ago, and it is sitting in a spreadsheet or your HRIS right now.
Multiply that by 300 and you get the familiar orientation-day scene: a room full of new hires copying data onto forms, HR staff answering the same formatting question forty times, and a stack of I-9s that will need correction because someone wrote the date in the wrong order.
What you may pre-fill, and what you may not
This is the part worth getting right before touching any tooling, because the compliance line runs straight through the middle of the form.
Section 1 — pre-filling is permitted. Populating Section 1 with information the employee already provided is allowed. But the employee remains responsible for its content. They must review every entry, correct anything wrong, select their own citizenship or immigration status attestation, and sign and date it personally. A pre-filled Section 1 is a draft handed to the employee, not a finished document. You cannot choose the attestation for them and you cannot sign for them.
Section 2 — pre-filling is not permitted. Section 2 records what the employer actually observed: the title, issuing authority, number, and expiration date of the identity and work-authorization documents the worker presented. Completing it before the examination happens is a compliance violation, and it is among the most common findings in an audit. There is no volume-related exception to this.
So the honest framing of batch filling I-9s is narrow and useful: it automates the transcription half of Section 1 and nothing else. That is still most of the clerical work, and it leaves your staff’s time for the examination, which is the part that legally requires a person.
Building the roster spreadsheet
Everything downstream depends on one clean spreadsheet — one row per worker, one column per field. If you already have this in your applicant tracking system or HRIS, export it; the point is a flat sheet, not a new data entry project.
For Section 1 you need:
| Excel column | I-9 Section 1 field | Example |
|---|---|---|
last_name | Last Name (Family Name) | Garcia |
first_name | First Name (Given Name) | Maria |
middle_initial | Middle Initial | L |
other_last_names | Other Last Names Used | Rodriguez |
address | Street Number and Name | 789 Pine St |
apt_number | Apt. Number | 3B |
city | City or Town | Miami |
state | State | FL |
zip | ZIP Code | 33101 |
date_of_birth | Date of Birth | 03/15/1990 |
ssn | U.S. Social Security Number | 123-45-6789 |
email | Employee’s Email Address | m.garcia@example.com |
phone | Employee’s Telephone Number | 305-555-0142 |
citizenship_status | Citizenship/Immigration Status attestation | Citizen |
Workers whose status requires additional identifiers will also need columns for USCIS A-Number, Form I-94 admission number, foreign passport number and country of issuance, and work-authorization expiration date. Leave those columns blank for the rows that do not use them — the fields simply stay empty on the generated PDF.
Two formatting rules save the most rework:
- Dates must be MM/DD/YYYY. Excel will happily hand you
2026-03-15or15/03/1990. Format the column as text in the target format before filling. - Keep SSN formatting consistent. Pick
123-45-6789and apply it to the whole column so leading zeros survive.
Filling the batch
With the roster ready, the mechanics are short:
- Download the current I-9. Get the official fillable PDF from uscis.gov. USCIS updates the form periodically — check the edition date in the bottom-left corner, and re-download before each hiring season rather than reusing last year’s file.
- Open Power PDF Filler from the Excel ribbon and select that PDF. The add-in detects the fillable fields automatically.
- Map your columns to the fields and save the mapping as a template named for the form edition —
I-9 (ed. 01/20/25) Section 1, for example. Next season you reload the template instead of remapping. - Select the roster rows and click “Ready, Go.” Each row becomes one pre-filled I-9. Download them individually or as a ZIP, named by employee.
- Distribute for review and signature, then complete Section 2 at the point of document examination.
The whole batch takes minutes. The step-by-step walkthrough covers the mapping interface in more detail, and the I-9 form page lists the field-by-field mapping.
Where seasonal batches go wrong
A few failure modes show up specifically at seasonal volume.
Using last season’s form edition. The single most expensive mistake, because it invalidates the entire batch at once rather than one form at a time. Re-download from USCIS before every hiring wave and confirm the edition date.
Treating the pre-filled form as finished. If a pre-filled Section 1 goes into a file without the employee’s review and signature, you have an unsigned I-9 — worse than a blank one, because it looks complete. Build the review-and-sign step into orientation explicitly.
Losing the three-day Section 2 clock across sites. When 300 hires start on staggered days at 40 locations, the three-business-day deadline is per worker, not per batch. Track start dates in the same spreadsheet so each site knows its own deadline.
Reusing a stale roster. If someone moved between application and start date, the pre-filled address is wrong and the employee has to correct it by hand — which defeats the purpose. Refresh the export close to the start date.
Staffing agencies: one roster, many sites
For staffing agencies the pattern is even more favorable, because the placement spreadsheet already exists.
Keep one placement roster. Batch fill Section 1 for an entire cohort, then distribute the pre-filled PDFs to each client site where the on-site supervisor or agency representative handles the Section 2 examination. The agency controls the data and the template; the sites handle only the part that must happen in person.
The same roster then drives the rest of the packet. Map it a second time against the W-4 and you have withholding certificates from the same data with no re-entry. That is the real compounding benefit of keeping onboarding data in Excel: one clean sheet, several saved templates, an entire onboarding packet generated per cohort. The HR document automation page covers the broader onboarding workflow.
How this compares to onboarding platforms
Full HR onboarding suites — Rippling, BambooHR, WorkBright and similar — handle I-9s as part of a larger system, usually with an electronic signature flow and sometimes with E-Verify integration. If you already run one, use it; a dedicated system that manages the whole lifecycle is the right tool.
Batch filling from Excel fits a different situation:
- You do not have an onboarding platform, or seasonal hires never get entered into the one you have.
- Your hiring is spiky — hundreds of workers twice a year — and per-employee platform pricing for a six-week engagement is hard to justify.
- You need the PDF itself for a client site, a paper file, or an auditor, not a record inside a SaaS product.
- Your roster lives in Excel because that is what the operations team uses, and it always will.
The two are not mutually exclusive. Plenty of employers run a platform for permanent staff and batch fill from a spreadsheet for the seasonal surge that the platform was never priced for.
The bottom line
Batch filling does not make I-9 compliance automatic. Document examination, employee attestation, the three-day deadline, and retention are unchanged.
What it removes is the transcription — the one part of the process that is pure clerical cost and pure error surface. If you are onboarding a seasonal cohort and the demographics already sit in a spreadsheet, pre-filling Section 1 turns the longest part of orientation into a few minutes of setup.
Start with the I-9 form page for the field mapping, or the HR use case for the full onboarding-packet workflow.