Bulk W-2 Upload: Formats, SSA Limits and a Prep Checklist

A bulk W-2 upload sends many employee wage records in one file instead of typing each form by hand. The Social Security Administration (SSA) accepts one kind of file: a text file in the EFW2 layout. Most payroll teams and accountants start from a spreadsheet, so the real work is getting the data clean and into the right format before anything is sent. This guide covers who has to upload, what the SSA accepts, the limits that cause rejections, and a checklist to run before you submit.

TL;DR

• Employers that must file 10 or more information returns in a year, W-2s included, must file electronically unless the IRS grants a waiver.
• The SSA’s own bulk upload takes only EFW2 or EFW2C text files, not Excel or CSV. A spreadsheet needs a conversion step or a platform that does it for you.
• For tax year 2026, the W-2 due date for both the SSA and employee copies is February 1, 2027. BSO uploads open December 8, 2026.
• Validate the file with AccuWage Online before you upload. Do not fix errors by resubmitting the same file.
• Bulk upload for filing is a different thing from importing a W-2 into tax software.

Need to get this filed? You can e-file Form W-2 online with TaxFormHero, which is IRS-authorized and charges per form, not per month.

What bulk W-2 upload means (and what it does not)

Two different tasks share similar words, and mixing them up wastes time.

Bulk upload for filing is the employer or filer side. You transmit wage data for many employees to the SSA, which is the agency that receives Copy A of Form W-2. This satisfies the legal reporting obligation.

Importing a W-2 is the taxpayer side. Tax software can pull existing tax information from the IRS online account while someone prepares a personal return. An employer cannot use that tool to file W-2s. If a client asks whether they can just upload their W-2 to their tax software, the answer is that this is a separate process and does not report anything on the employer’s behalf.

The rest of this article is about the first task: getting a payroll year-end file to the SSA.

Who must e-file W-2s in bulk

The trigger is a count, not a company size. Under the IRS rules, employers filing 10 or more information returns, including Forms W-2, must file electronically unless the IRS has granted a waiver. The IRS explains in Topic no. 801 that no one is required to e-file in a calendar year unless they must file at least 10 returns that year.

The count is aggregate. According to the General Instructions for Forms W-2 and W-3, it combines many return types, including the 1099 series, the 1098 series, the 1094/1095 series and W-2 itself. A business with six W-2 employees and five 1099-NEC contractors has 11 returns and must e-file all of them. This is the point that most often catches small employers off guard.

Fewer than 10 returns means you may still file on paper, but the IRS encourages every employer to file W-2s electronically. The SSA’s online option lets you create and submit a small number of forms directly, so a very small employer does not need a bulk file at all.

The three ways to get W-2 data to the SSA

The first option is free but demands that you already have a correctly formatted file. The second is free and simple but caps the volume. The third exists because most real-world payroll data lives in a spreadsheet or a payroll export that is not EFW2. We cover the trade-offs in our comparison of SSA BSO alternatives for W-2 filing.

Why the SSA will not take your spreadsheet

The SSA’s formatted-file upload is strict. The EFW2 specifications describe a fixed-width ASCII text layout, and the SSA does not read Excel workbooks or generic CSV files. Each file is built from labeled records in a set order:

1. RA (Submitter) record. Identifies who is sending the file.
2. RE (Employer) record. Identifies the employer whose employees follow.
3. RW and RO (Employee) records. The wage data for each employee.
4. RT (Total) record. Totals for the employer.
5. RF (Final) record. Closes the file.

The SSA’s 2026 filing specifications say the submission must run from the RA record through the RF record in a single wage file. A misplaced character, a wrong field width or a missing total can trigger rejection of the whole file, not just one employee.

That is why hand-building a file from a spreadsheet is risky. If your payroll software exports EFW2, use that export. If it does not, use a tool that maps spreadsheet columns to the layout and produces the filing for you.

Check the submitter record first

If you file for multiple clients, the RA record deserves extra attention. The SSA specifications stress accuracy in the submitter information. Errors in the BSO User ID or contact details are a common cause of delays or rejection. Confirm that the BSO User ID in the file belongs to the person who is attesting to the accuracy of the wage data, since that ties accountability to the submission.

Preparing spreadsheet data for a bulk upload

Whether you convert the file yourself or hand it to a platform, the same data quality rules apply. Most rejected bulk files fail on data, not on technology.

Columns to confirm for every employee

• Legal first name, last name and suffix as they appear on the Social Security card
• Social Security number (nine digits, no dashes in most layouts)
• Full mailing address, including ZIP code
• Box 1 wages, Box 3 and Box 5 wages, and the matching withholding in Boxes 2, 4 and 6
• Box 12 codes with amounts, and Box 13 checkboxes
• State, state employer ID, state wages and state withholding

For tax year 2026 the form also changes. If your payroll data feeds the new tips and overtime reporting, review our note on mapping the 2026 W-2 codes TT, TP and TA before you finalize the columns.

Common data problems

• Names that do not match SSA records. Nicknames, missing hyphens and marriage-name changes are the usual cause of mismatches. Use the exact name on the Social Security card.
• SSNs stored as numbers. Excel strips leading zeros. Format the SSN column as text.
• Duplicate employees. A rehire or a mid-year transfer between entities can create two rows for one person.
• Totals that do not reconcile. The totals in your payroll register should match the sum of employee rows before you export.
• Stray characters. Commas, tabs and special symbols in name or address fields can break fixed-width layouts.

Run a name and SSN check before filing when you can. The same discipline applies to our TIN matching and verification tool, which checks a number against a name before a return is built.

A pre-upload checklist

1. Count your returns. Add W-2s, 1099s, 1095s and other information returns to see if the 10-return rule applies.
2. Register for BSO if you file directly. The IRS says to register with Business Services Online at SSA.gov to e-file W-2 and W-2c forms.
3. Reconcile payroll. Tie Boxes 1, 3 and 5 to your quarterly Form 941 filings before you export.
4. Generate the file. Use payroll software that exports EFW2, or a platform that converts your spreadsheet.
5. Test with AccuWage Online. The SSA recommends running the formatted file through AccuWage Online to catch syntax errors before its automated system does.
6. Check the submitter record. Verify the BSO User ID and contact information.
7. Upload one file at a time. Do not bundle several wage files in one ZIP.
8. Keep the confirmation. Save the submission receipt and the tracking number.

File size, compression and record limits

Three limits come up most often.

• One wage file per upload. The SSA does not process a ZIP that holds multiple separate wage files. Send each file on its own. Compressing a single wage file is allowed, and the SSA says that PKZip, WinZip or compatible software can reduce transmission time.
• 350 MB file ceiling. The BSO handbook lists 350 MB as the maximum for an uploaded formatted file.
• Record count for multi-employer filers. Per the 2026 specifications, organizations filing for several employers should keep a single EFW2 or EFW2C file to no more than 500,000 records to avoid session timeouts. Split larger volumes into separate files.

The SSA also warns that BSO may experience processing delays during high submission volume. Upload early in the season, not on the last day.

Dates that matter for tax year 2026

• December 8, 2026: BSO filers may begin uploading 2026 files. Businesses that are terminating may file before that date.
• February 1, 2027: The due date to file with the SSA and to furnish Copies B, C and 2 to employees. It applies to paper and electronic filing alike.

Extensions are not automatic. The same IRS instructions say an extension to file with the SSA requires Form 8809 and is granted only in extraordinary circumstances. Plan to meet the date instead of relying on one. Our W-2 deadline checklist and the post on checking TINs before December 8 lay out a working calendar.

Our perspective: treat the upload as the last step, not the first

We see the same pattern each January. A team has a clean payroll register and assumes the upload is the hard part. It rarely is. The upload is a transmission. The problems that cost a filer days are earlier: an SSN with a dropped leading zero, a name that does not match, a total that disagrees with Form 941, a file built for a different layout.

So we build the workflow around review before submission. Data comes in by manual entry or by Excel and CSV import, including thousands of records at a time. Records are organized by recipient, and TIN verification is available before a return is created. Federal returns for forms that go through the IRS are transmitted by IRIS A2A. For W-2 specifically, the practical advice is the same whatever tool you pick: validate first, reconcile to payroll, and keep the exception list short enough to clear before February 1.

We also think pricing should be predictable for accountants who file for many clients. That is why we charge per form, with no subscription, signup fee or annual contract. For a closer look at how an exception queue keeps rejects from piling up, see our W-2 filing workflow guide.

— Nazrul

Filing a spreadsheet of W-2s with TaxFormHero

If your data is in Excel or CSV and you do not want to build an EFW2 file, you can e-file W-2 forms with TaxFormHero. W-2 filing begins at $2.99 per form for the first 50 forms, with lower rates at higher volumes. Optional add-ons are priced per form: state filing at $0.99, print and mail at $1.69, encrypted e-delivery at $0.19, and TIN matching at $0.49 per verification. Full rates are on the pricing page, and a worked example for several headcounts is in our W-2 e-file cost breakdown. Firms with very large or multi-entity volumes can look at enterprise information return filing.

Mistakes that get bulk files rejected

• Resubmitting the same file. If a format error caused the rejection, sending it again returns the same result. Test with AccuWage Online, fix the cause, then send.
• Uploading a spreadsheet to the SSA. BSO takes EFW2 text files. A renamed .xlsx is still a spreadsheet.
• Zipping several files together. One wage file per upload.
• Mixing employers without separate RE records. Each employer needs its own employer record in the file.
• Wrong submitter details. An incorrect BSO User ID can stall the entire file.
• Forgetting the employee copies. Filing with the SSA does not furnish copies to workers. Copies B, C and 2 are due on the same February 1 date.

FAQ

Can I upload an Excel or CSV file directly to the SSA?

No. The SSA’s formatted-file upload accepts only EFW2 or EFW2C text files. A spreadsheet has to be converted to that layout first, either by your payroll software or by a filing platform that accepts spreadsheet imports.

How many W-2s can I file through the SSA’s online form?

BSO’s W-2 Online option allows a maximum of 50 Forms W-2 per submission, according to the SSA handbook. Larger volumes need a formatted wage file upload or a third-party platform.

Do I have to file W-2s electronically?

If you file 10 or more information returns in the year, yes, unless the IRS has granted you a waiver. The count combines W-2s with 1099s and other returns. With fewer than 10 you may file on paper, though the IRS encourages e-filing.

What is the $600 rule for W-2s?

There is no $600 rule for W-2s. An employer must file a W-2 when it paid wages that had federal income tax withheld, or when it paid a household employee $3,000 or more in Social Security and Medicare wages, as the IRS explains. Ask a CPA or payroll adviser about your specific situation.

Sources

• General Instructions for Forms W-2 and W-3 (IRS)
• Electronic filers FAQ (IRS)
• Topic no. 801, Who must file information returns electronically (IRS)
• E-file information returns (IRS)
• Import your tax information into tax preparation software (IRS)
• Specifications for Filing Forms W-2 and W-2c, EFW2/EFW2C (SSA)
• 2026 EFW2 filing specifications (SSA)
• Electronic W-2 Filing User Handbook (SSA)
• Employer W-2 Filing Instructions for Software Developers (SSA)

Recommended

• E-File W-2 Forms: 2026 Guide for Payroll Professionals
• Beat Feb 1 Rejects: W-2 Workflow With Exception Queue for U.S. Payroll
• Where to Mail W-2 Forms: SSA and IRS Rules for 2026
• Best SSA BSO Alternative for W-2 Filing in 2026