1099-NEC deadline · Feb 1, 2027 Tax year 2026 brings a $2,000 reporting threshold, new tips and overtime boxes, and the end of FIRE. What changed for 2026 Free FIRE converter Collect a W‑9

Back to Blogs IRS Forms

W-2 Excel Import: Prepare, Map and Check Your Spreadsheet

October 30, 2026 Tax Form Hero Team 5 min read

Geometric spreadsheet rows becoming W-2 drafts

A W-2 Excel import moves employee wage data from a spreadsheet into W-2 software in one step, instead of keying each employee by hand. The import works when the spreadsheet matches what the receiving tool expects: one row per employee, one column per field, clean numbers and no stray characters. This guide covers how to lay out the file, which fields to map, which errors stop an import, and what to check afterward.

TaxFormHero

Move W-2 Data Beyond the Spreadsheet

Import employee records from Excel, prepare W-2 forms, and transmit federal information returns to the IRS through IRIS A2A.

E-File W-2 Forms

TL;DR

An Excel import is a data-entry step. It does not file anything with the Social Security Administration (SSA) or the IRS.
Use one row per employee and one column per field. Store SSNs and EINs as digits only, with no hyphens.
Some state portals require their own spreadsheet framework. Do not alter its columns, rows or formatting.
After import, compare totals with your payroll register, check names and SSNs, and test the file format before you submit.
Employers with 10 or more information returns must file Copy A electronically, so a clean import saves real time.

TaxFormHero is an IRS-authorized e-filing platform, so you can e-file Form W-2 online without paper or a subscription.

What a W-2 Excel import does and does not do

An import reads rows from a spreadsheet and creates a draft W-2 for each one. It is a way to load data. It is not a filing.

Filing is a separate step. The SSA’s employer FAQ says employers can file W-2s electronically through W-2 Online, software that produces an EFW2 file for upload to Business Services Online, or commercial software that files electronically. Your spreadsheet is the input to one of those routes, never a replacement for them.

Two points follow from that:

A spreadsheet is not a filing format. The SSA wants wage data in its EFW2 record structure, and the SSA’s file-edit guidance describes that structure and its numeric rules. Your software converts rows into that format.
A printed or downloaded W-2 is not a substitute either. The IRS states that W-2 forms downloaded from IRS.gov are for information only and cannot be filed with the SSA, because they lack the scannable features.

If your workflow starts in payroll software, you may not need Excel at all. Many payroll systems export a file you can load directly. We cover one common case in W-2 e-filing for Paychex payroll data.

Who needs to file electronically

The threshold matters because it decides whether an import saves you time or is simply good practice.

IRS Publication 1141 says employers must file Forms W-2 (Copy A) electronically with the SSA if they file 10 or more information returns, unless the IRS grants a waiver or the employer claims an exemption. The same publication notes that electronic filers do not file a paper Form W-3.

The count of 10 applies to information returns in total, not only W-2s. An employer with 6 W-2s and 5 Forms 1099-NEC is over the line. Our article on sending 1099s electronically explains how that count works for 1099 filers.

Even below the threshold, a spreadsheet import is the faster route once you have more than a handful of employees. It also makes next year easier, because you can reuse the file.

Does the software need its own template?

Usually yes, in some form. There is no universal W-2 spreadsheet standard. Each tool defines the columns it recognizes.

There are three situations:

A vendor template. The tool gives you a blank workbook with fixed column headers. You paste your data into it. This is the most common setup.
A mapping screen. You upload your own file, and the tool asks you to match each of your column headers to a W-2 field. This tolerates different layouts but needs more attention.
A state-supplied workbook. Some tax agencies publish a spreadsheet you must use for their own upload. These are strict.

South Carolina is a clear example of the third type. The state’s W-2 and 1099 upload page says not to alter the spreadsheet’s formatting, not to remove rows or columns, and not to cut, copy or paste text into cells. Virginia’s web upload guide likewise describes a specially formatted spreadsheet for W-2 uploads. If your state requires a framework file, use the state’s file for the state upload only, and keep a separate working copy for everything else.

Before you build anything, read the tool’s own import instructions and download its template. Rebuilding a layout by guesswork is the most common cause of a failed first import.

Build the spreadsheet: layout rules

The same rules apply to almost every import.

One row per employee

Each row is one W-2. Each column is one field. Do not merge cells, add subtotal rows, or leave blank rows in the middle of the data. Put one header row at the top and nothing above it.

Spreadsheet structure with one employee per row

If an employee worked in two states or has two sets of withholding, check how the tool handles it. Some tools take multiple state columns on one row. Others expect a second row. The template will show which.

Store identifiers as text

Excel strips leading zeros from numbers. An SSN such as 012-34-5678 can become 12345678 if the column is formatted as a number. Format the SSN, EIN and ZIP code columns as Text before you paste data in.

Use digits only. The South Carolina instructions call for numeric-only SSN and EIN fields without hyphens, and the same habit is safe for other imports unless a template tells you otherwise.

Keep money fields clean

Enter amounts as plain numbers. Remove dollar signs, commas inside text cells, trailing spaces and notes such as “n/a”. The SSA warns against negative numbers and nonnumeric characters in specified money fields in the wage file. That rule applies to the EFW2 file, not to Excel itself, but a spreadsheet that carries those problems will pass them straight into the file your software builds.

If you need to correct an earlier year’s wages, do that on a corrected return. Do not enter a negative number on a regular W-2.

Match names and addresses to records

Use the legal name as it appears on the Social Security card, split into first, middle and last name columns if the template asks. Avoid nicknames. Keep suffixes in their own column when one exists. Put city, state and ZIP in separate columns. Use the two-letter state abbreviation.

Which fields to include and map

The exact headers differ by tool, but the content does not. Here is a working field list for a standard W-2 import.

Group	Fields to include	Notes
Employer	EIN, legal business name, address	Same on every row, so check once
Employee identity	SSN, first name, last name, address	Full SSN, digits only
Federal wages	Wages, tips and other compensation; federal income tax withheld	Box 1 and Box 2
Social Security and Medicare	Social Security wages and tax, Medicare wages and tax	Boxes 3 to 6
Other boxes	Tips, dependent care, retirement plan indicator, Box 12 codes, Box 14	Only where they apply
State and local	State, employer state ID, state wages, state tax withheld, locality fields	Needed for state copies

The South Carolina upload list is a useful minimum for the state side. It asks for the FEIN, each employee’s full SSN, name and address, income tax reporting, wages, tips and other compensation, state taxable wages, and state income tax withheld.

Pay special attention to Box 12 and Box 14. These hold codes and notes that are easy to lose in a spreadsheet, because a single employee can have several. For the 2026 form year, new reporting codes appear on the W-2. Our guide on mapping the TT, TP and TA codes shows what to add to your payroll export before January.

Step-by-step: import and review

This is the sequence we recommend whatever tool you use.

Export from payroll. Pull the year-end register by employee, not by pay period. Include every employee who was paid during the year, including those who left.
Download the template. Use the current year’s version. Column sets can change between tax years.
Paste values only. Use Paste Special, then Values, so formulas and source formatting do not carry over.
Format identifier columns as Text. Do this before you paste, or re-enter the leading zeros afterward.
Clean the data. Delete hyphens from SSNs, trim spaces, remove symbols from money cells, and check that state codes are two letters.
Total the columns. Add up wages, federal withholding, Social Security wages and Medicare wages in the spreadsheet. Write the totals down.
Save as the required type. Some tools accept .xlsx, others want .csv. Follow the tool’s instruction.
Upload and read the results screen. Most tools list the rows imported and the rows rejected. Do not click past warnings.
Fix and re-import. Correct the source spreadsheet, not just the screen, so your records match what you file.
Review the drafts. Open a sample of the imported W-2s and compare them with payroll.

If you handle large batches, our bulk W-2 upload guide covers formats, SSA limits and a preparation checklist in more detail.

Common errors and how to fix them

Most failed imports trace back to a short list of problems.

Symptom	Likely cause	Fix
SSN rejected as too short	Leading zero dropped by Excel	Reformat the column as Text and re-enter the value
SSN rejected as invalid	Hyphens or spaces in the cell	Remove them and keep nine digits
Amount rejected	Dollar sign, text note or negative number	Enter a plain positive number
Row skipped	Missing required field such as name or address	Fill the field and re-import
Whole file rejected	Altered headers or deleted columns	Start again from a fresh template
State upload fails	Wrong format for state workbook	Use the state’s own framework file

Virginia’s guide gives the same pattern for its own portal: errors such as missing fields, wrong lengths, invalid amounts or years, and incorrect formatting must be corrected and the file uploaded again.

Two habits prevent most of this. First, never edit the header row. Second, keep the original export untouched and work in a copy, so you can always see what payroll produced.

What to verify before you file or distribute copies

A successful import means the data loaded. It does not mean the data is right. Check these items before you file and before employees receive their copies.

Totals. The SSA’s guidance tells filers to compare the RT and RU record totals with payroll records. In plain terms, the sums on the file must equal the sums in your payroll register.
Names and SSNs. A mismatch between name and SSN is one of the most common reasons for a wage report problem. Spot-check new hires and anyone who changed their name.
EIN. Confirm the employer EIN on the file matches the one on your payroll account.
Money fields. Look for blanks, negative values and amounts that look ten times too large or small.
File format. The SSA says employers can upload a wage file produced by their own software if it meets the electronic-filing specifications, and can use AccuWage to test the report before submission.

If you want an extra check on the SSN and name pair, TIN matching is available on our platform at $0.49 per verification.

For teams that file at volume, an exception queue helps. It holds problem records aside so clean ones can move forward. We describe the approach in our W-2 filing workflow.

Worked example: a 40-employee import

A bookkeeping firm imports year-end data for a client with 40 employees.

The client’s payroll export has 40 rows. The firm pastes values into the template and finds three SSNs of eight digits. Each lost a leading zero. It reformats the column as Text and corrects the three.
It totals Box 1 wages in the spreadsheet: the total matches the payroll register to the cent.
The upload screen reports 38 rows imported and 2 rejected. Both rejected rows had “N/A” typed in a Box 2 cell. The firm replaces it with 0 and re-imports.
It opens five of the drafts, including one with a Box 12 code, and confirms each matches payroll.

At our published rate of $2.99 per form for the first 50 W-2 forms, the base filing cost for 40 forms is $119.60. Optional services are priced per form on top of that: encrypted e-delivery is $0.19, print and mail is $1.69, and state filing is $0.99. For other volumes, see our W-2 e-file cost examples.

Our perspective: treat the spreadsheet as a controlled document

We see the same pattern in imports again and again. The tool is rarely the problem. The spreadsheet is.

The spreadsheet is where payroll data leaves a system with validation and enters one with none. Excel will happily accept a name in a number column or drop a zero from a SSN. So we treat the import file as a controlled document:

One person owns it, and one copy is the master.
Columns are fixed. Nobody adds, hides or renames them.
Totals are written down before upload and compared afterward.
Corrections are made in the source file, then re-imported, so the record always matches what was filed.

Our platform supports Excel and CSV bulk import for high-volume work, and manual entry for small jobs. We built it that way because accountants and payroll teams rarely start from a clean slate. They start from an export, and they need to see what failed and why before they file.

The best preparation is boring: format the identifier columns, remove symbols, total the money columns and test the file. That takes less time than fixing a rejected batch.

— Nazrul

Load your W-2 data with TaxFormHero

If your data is ready, TaxFormHero accepts it by manual entry or by Excel import, and you can manage more than one payer account in the same place. W-2 filing begins at $2.99 per form for the first 50 forms, with lower rates at higher volumes. There is no subscription, signup fee or annual contract. We are an IRS-authorized e-file platform, and Tax Form Hero LLC holds a SOC 2 Type I attestation.

TaxFormHero

You can see the full list of per-form add-ons on our pricing page, or start from the TaxFormHero home page to begin with W-2 or ACA forms. For a walk-through of the process, read our step-by-step guide to W-2 e-filing for payroll professionals.

FAQ

Can I use my own Excel layout for a W-2 import?

Sometimes, but not always. Some tools let you map your own column headers to W-2 fields, while others only accept their own template. State portals are usually the strictest: South Carolina, for example, tells filers not to alter its spreadsheet’s formatting or remove rows and columns. Check the tool’s instructions before you build a layout.

Does an Excel import file my W-2s with the SSA?

No. The import only loads data into software. Filing is a separate step in which the software sends the wage data to the SSA in its required electronic format. The SSA lists W-2 Online, EFW2 file upload and commercial software as the electronic routes.

Why did my SSN column lose its leading zeros?

Excel treats the entry as a number and drops the leading zero. Format the column as Text before you paste data, then re-enter the missing digits. Keep SSNs and EINs as digits only, without hyphens, unless the template says otherwise.

Should I save the file as .xlsx or .csv?

Follow the tool’s instruction. Many tools accept both, and some require .csv. If you save as .csv, reopen the file in a plain text editor to confirm that leading zeros and decimals survived.

What should I check right after the import?

Compare the spreadsheet totals with your payroll register, then open a sample of the drafts. Check names, SSNs, the EIN and the money fields. The SSA also provides AccuWage to test the format of a wage file before submission.