To extract data from W-2 forms, you can use Lido. Upload your W-2s, specify the boxes you need, such as wages and federal tax withheld, and Lido pulls them into a spreadsheet with one row per W-2.
In this tutorial, we will walk you through extracting data from a sample W-2 form, step by step.
Lido is the easiest way to extract data from W-2 forms because it reads W-2s from any employer or payroll provider, including scans and photos, without templates.
Before you start, make sure you have your W-2s saved as PDFs, images, or scanned copies.
If you don't have a Lido account yet, you can create one for free here.
Once you're logged in, create a New File.

Select the Extract Data button at the top of the sheet.

Upload your W-2s by dragging and dropping them into Lido, or click to browse. You can upload up to 100 files at a time. The W-2s can come from different employers and payroll providers.

For the purpose of this tutorial, we will be using a sample W-2. Enter the columns you want to extract: Employee Name, Employer Name, Tax Year, Wages, Federal Tax Withheld, Social Security Wages, Medicare Wages, and State Income Tax.
Next, add extra instructions that tie each column to a box. We used: "Extract one row per W-2. Wages is Box 1, Federal Tax Withheld is Box 2, Social Security Wages is Box 3, Medicare Wages is Box 5, and State Income Tax is Box 17. Format amounts as plain numbers." Once done, click Process All Files.

Review the extracted data against the W-2. Lido returned Wages of 68,450, Federal Tax Withheld of 7,842.60, Social Security and Medicare Wages of 72,000, and State Income Tax of 5,690.25.
Notice that Social Security Wages are higher than Box 1 Wages. The employee put 3,550 into a 401(k), shown in Box 12 with code D, which lowers Box 1 but not Boxes 3 and 5. Extracting both boxes makes differences like this easy to spot.

Click Export to Excel to download your W-2 data as a spreadsheet file, ready for tax preparation, income verification, or payroll reconciliation.

Upload the rest of your W-2s with the same columns and instructions. Each W-2 becomes its own row, so a household with several jobs or a firm with hundreds of clients ends up with one sortable list.
You can also connect a Google Drive folder, a OneDrive folder, or an email inbox in the Extract Data window so new W-2s are extracted as clients send them.
Every W-2 uses the same box numbers, so you can pick columns once and reuse them. These are the boxes most teams extract:
Boxes 1 and 2: Wages subject to federal income tax and the federal income tax withheld. These feed directly into Form 1040.
Boxes 3 to 6: Social Security and Medicare wages and the tax withheld for each. These help you check withholding and catch payroll errors.
Box 12: Coded amounts such as D for 401(k) contributions, W for HSA contributions, and DD for employer health coverage. Add a column for each code you need and name the code in your instructions.
Boxes 15 to 17: The state, the employer's state ID, state wages, and state income tax withheld. Use Extract Multiple Rows per Document if an employee worked in more than one state.
W-2s often arrive alongside other tax forms. Our guides to automating 1099 processing and automating Schedule K-1 data entry use the same steps.
There are a few other ways to get W-2 data, depending on who you are:
Manual data entry: Typing each W-2 into a spreadsheet or tax software works for a few forms. During tax season, it adds up to hours of work and typos in wage amounts.
Payroll system exports: If you are the employer, export W-2 data directly from your payroll system instead of extracting it from PDFs.
IRS wage and income transcripts: Taxpayers can request a wage and income transcript from their IRS online account. Transcripts are often not available until later in the filing season, so most preparers still work from the W-2s themselves.
For other options, see our list of the best payroll data extraction tools.
Now that you know how to extract data from W-2 forms, you can turn a stack of W-2s into a clean spreadsheet in minutes.
Upload the W-2 to Lido, enter the boxes you need as columns, and click Process All Files. Lido returns the values in a spreadsheet you can export to Excel.
Yes. Lido reads scanned, photographed, and digital W-2s from any employer or payroll provider.
Yes. Add a column for each Box 12 code you need, such as D or DD, and Lido extracts the matching amount.
Yes. You can upload up to 100 W-2s at a time, and each one becomes its own row.
No. Lido reads W-2s in any layout without templates or setup for each employer.