To extract data from 1040 tax returns, you can use Lido. Upload the returns, specify the lines you need, such as total income, adjusted gross income, and total tax, and Lido pulls them into a spreadsheet with one row per return.
In this tutorial, we will walk you through extracting data from a sample Form 1040, step by step.
Lido is the easiest way to extract data from 1040 tax returns because it reads returns from any tax software, including scanned copies, without templates.
Before you start, make sure you have your tax returns 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 tax returns by dragging and dropping them into Lido, or click to browse. You can upload up to 100 files at a time. You can upload several years of returns for the same client at once.

For the purpose of this tutorial, we will be using a sample 2024 Form 1040 for a married couple filing jointly. Enter the columns you want to extract: Taxpayer Name, Filing Status, Tax Year, Total Income, Adjusted Gross Income, Taxable Income, Total Tax, and Refund.
Next, add extra instructions that tie each column to a line. We used: "Extract one row per return. Taxpayer Name includes the spouse on a joint return. Total Income is line 9, Adjusted Gross Income is line 11, Taxable Income is line 15, Total Tax is line 24, and Refund is line 35a. Format amounts as plain numbers." Once done, click Process All Files.

Review the extracted data against the return. Lido returned Total Income of 127,379, Adjusted Gross Income of 126,503, Taxable Income of 94,998, Total Tax of 12,583, and a Refund of 1,367, along with both spouses' names and the filing status.
You can edit any cell before you export, and reprocessing is free within 24 hours if you change a column.

Click Export to Excel to download your 1040 data as a spreadsheet file for income verification, tax planning, or year over year comparisons.

Upload returns from other years or other clients with the same columns. Each return becomes its own row, so comparing two years of adjusted gross income takes one glance.
The right lines depend on why you need the data. These are the most common choices on the 2024 Form 1040:
Income verification: Lenders and landlords usually look at wages on line 1z, total income on line 9, and adjusted gross income on line 11, often for the last two years.
Tax planning and amended returns: Preparers often add the deduction on line 12, taxable income on line 15, total tax on line 24, and total payments on line 33.
Schedules: Business income from Schedule C or capital gains from Schedule D come from schedules attached to the return. Add columns for those amounts, and Lido reads every page of the PDF.
Line numbers can change between tax years, so add a Tax Year column and describe each field by name in your instructions. Lido finds the right value even when the line number moves.
There are a few other ways to get data from a 1040, each with limits:
Manual data entry: Typing figures from each return works for one or two returns. It gets slow and error prone across many clients or many years.
IRS tax return transcripts: Taxpayers can download a tax return transcript from their IRS online account, and lenders often request one with Form 4506-C. Transcripts show most line items from the original return, but you still have to copy the numbers into your own spreadsheet.
Tax software exports: If you prepared the return yourself, your tax software may export the data. Returns prepared elsewhere usually arrive as PDFs. Those PDFs need applications that parse tax paperwork before the numbers can reach a spreadsheet.
For more options, compare OCR tools for tax document processing, or learn how to extract data from W-2 forms that support the wages on line 1z.
Now that you know how to extract data from 1040 tax returns, you can turn any return into spreadsheet data in minutes.
Upload the return to Lido, enter the lines 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 and digital 1040 returns from any tax software.
Yes. Lido reads every page of the PDF, so you can add columns for amounts on Schedule C, Schedule D, and other schedules.
Yes. Upload each year's return with the same columns, and Lido returns one row per return for easy comparison.
Yes. Lido extracts data from Form 1040, 1040-SR, and 1040-NR without templates.