Batch Fill I-9 Forms from Excel

Employment Eligibility Verification

Power PDF Filler lets HR teams and staffing agencies batch fill USCIS I-9 forms directly from Excel. Pre-fill Section 1 (employee information) for all new hires at once — name, date of birth, address, SSN, and citizenship status. Each row becomes one filled I-9. Essential for seasonal hiring surges and large onboarding cohorts.

What is the I-9 form?

USCIS Form I-9 (Employment Eligibility Verification) is required for every new employee hired in the United States. The employee completes Section 1 on or before their first day of work, providing their name, date of birth, address, Social Security number, and citizenship or immigration status. The employer then completes Section 2 within three business days, examining the employee's identity and work authorization documents.

Employers must retain I-9 forms for all current employees and for three years after the date of hire or one year after termination, whichever is later. The official fillable PDF is available from uscis.gov.

Who needs to batch fill I-9 forms?

HR departments — Pre-filling I-9 Section 1 with known employee data as part of onboarding packets, reducing errors and saving time during orientation.
Staffing agencies — Processing I-9 forms for large volumes of temporary, contract, and seasonal workers placed across multiple client sites.
Companies with seasonal hiring — Retail chains, hospitality groups, agricultural operations, and event companies that onboard dozens or hundreds of workers at once.
Employers during mergers or acquisitions — Re-verifying employment eligibility for acquired employees or generating new I-9 forms for transferred staff.

How to batch fill I-9 forms from Excel

Select your PDF form. Open Power PDF Filler from the Excel ribbon and select the official I-9 fillable PDF (download it from uscis.gov if you don't have it). The add-in detects all fillable fields — employee name, date of birth, address, SSN, citizenship status checkboxes, and document fields.
Select & map your Excel data. Each row represents one new hire. Columns include first name, last name, date of birth, SSN, address, city/state/ZIP, citizenship status, and optionally Section 2 employer fields. Save the mapping as a reusable template.
Click "Ready, Go." Power PDF Filler generates one pre-filled I-9 per row. Distribute to new hires for review and signature. The employer completes Section 2 after examining documents.

What Excel columns do you need?

Excel Column	I-9 Field	Example
last_name	Section 1: Last Name	Garcia
first_name	Section 1: First Name	Maria
middle_initial	Section 1: Middle Initial	L
other_last_names	Section 1: Other Last Names	Rodriguez
address	Section 1: Address	789 Pine St, Apt 3B
city_state_zip	Section 1: City, State, ZIP	Miami, FL 33101
date_of_birth	Section 1: Date of Birth	03/15/1990
ssn	Section 1: SSN	123-45-6789
citizenship_status	Section 1: Attestation	Citizen

Common mistakes to avoid

Using an expired I-9 version. USCIS periodically updates the I-9 form. Always download the current version from uscis.gov. Check the edition date in the bottom-left corner of the form.
Pre-filling Section 2. Section 2 must be completed by the employer after physically examining the employee's documents. Pre-filling Section 2 before document examination is an I-9 compliance violation.
Date formatting. The I-9 requires MM/DD/YYYY format. Ensure your Excel date column matches this format, not DD/MM/YYYY or YYYY-MM-DD.

Also processing W-4 forms?

Batch fill W-4 withholding certificates from the same employee data: Batch Fill W-4 Forms from Excel →

I-9 — Frequently Asked Questions

Can I batch fill I-9 forms from Excel? ▼

Yes. Set up your employee data in Excel with one row per employee — name, date of birth, SSN, address, citizenship status, and document information. Map columns to I-9 Section 1 fields and fill all forms in one click.

Which sections of the I-9 can I batch fill? ▼

You can batch fill Section 1 (Employee Information and Attestation) with employee-provided data. Section 2 (Employer Review) can also be batch filled if you have the document details in your spreadsheet.

Does it work with the current USCIS I-9 form? ▼

Yes. Download the current fillable I-9 from uscis.gov and open it in Power PDF Filler. The add-in detects all fillable fields including text fields, checkboxes, and dropdowns.

How do staffing agencies use this for I-9 processing? ▼

Staffing agencies maintain candidate data in Excel and batch fill I-9 Section 1 for all new placements. This is especially valuable during seasonal hiring surges when dozens or hundreds of I-9s are needed in a short window.

Is it safe for I-9 data containing SSNs? ▼

Yes. In any modern browser such as Chrome or Edge, all processing is client-side — SSN data never leaves your machine. Desktop Excel uses secure cloud processing with HTTPS encryption and daily data purging. Your data is never shared or sold.

Ready to stop filling PDFs manually?

Start your free trial — no credit card required.

Try Free on Microsoft Excel