How to Scan Receipts into Excel (3 Methods Compared)

There are really two jobs hiding inside the phrase scan receipts into Excel. The first is capturing a clean image of the receipt. The second is turning that image into structured rows: date, vendor, subtotal, tax, total, and sometimes each line item. Most frustration comes from the second job, so that is where this comparison focuses.

Below are the three realistic methods for a small business, freelancer, or bookkeeper, with honest notes on where each one breaks down.

First, capture a scan that is easy to read

Whatever method you choose, the quality of the image decides how much fixing you do later. Receipts are hard: they are long, narrow, curled, and often printed on thermal paper that fades. A few habits make a large difference:

• Flatten it. Lay the receipt on a dark, flat surface; the contrast helps your phone find the edges. Weigh down curled ends.
• Use even light. Avoid overhead lights that throw your phone's shadow across the text. Daylight from a window is ideal.
• Shoot straight down. Angled photos skew the columns, which confuses any extraction method.
• Split very long receipts. If a grocery receipt will not fit legibly in one frame, take two photos with a little overlap.
• Use a scanner app or your phone's built-in document scanner for automatic cropping and contrast. Save as PDF or JPG.
• Scan soon. Thermal receipts can fade within months, and once the total is unreadable no tool can recover it.

Method 1: Manual entry

Manual entry is the baseline: open the receipt image on one side of the screen, a spreadsheet on the other, and type. It requires no tools and gives you complete control, which is why plenty of people start here.

How to make it less painful

1. Set up the columns once: Date, Vendor, Category, Subtotal, Tax, Total, Payment Method, Notes, File.
2. Format the sheet as an Excel Table (Ctrl+T) so formulas and formatting extend automatically to new rows.
3. Add a drop-down list for Category using Data Validation so you do not end up with Supplies, supplies, and Supply as three different categories.
4. Add a check column that flags rows where the parts do not add up.

That check column is worth copying no matter which method you use. With Subtotal in D, Tax in E, and Total in F:

=IF(ABS(D2+E2-F2)>0.01, "CHECK", "")

Where it breaks down: time. Typing the header fields of one receipt takes a minute or so; typing its line items can take several. At a few dozen receipts a month, that is an evening you will keep postponing. Typos in amounts are also hard to spot, which is exactly what the check column is for.

Method 2: Excel's Data from Picture

Microsoft 365 versions of Excel include a Data from Picture feature (on desktop under the Data tab, and in the Excel mobile app) that converts a photo of a table into cells. You select an image or take a photo, Excel previews what it recognized and flags uncertain cells, and you insert the result into your sheet.

When it works well

The feature is designed for tables: printed price lists, simple invoices with clear grid lines, and forms with a consistent column structure. On those, it can save real time.

Where it struggles with receipts

• Receipts are not tables. Store headers, addresses, item lines, and payment details are stacked vertically, so the output tends to land as one long column of mixed text.
• It does not know which number is the total, which is tax, and which is a loyalty discount, so you still have to identify and move those values yourself.
• It processes one image at a time, which adds up across a month of receipts.
• Amounts may come in as text, with dollar signs or trailing characters attached.

If you go this route, these cleanup formulas will save you a lot of retyping. Assume the raw value is in A2:

Strip $ and commas, convert to a number:
=VALUE(SUBSTITUTE(SUBSTITUTE(TRIM(A2), "$", ""), ",", ""))

Turn text like 03/14/2026 into a real date:
=DATEVALUE(TRIM(A2))

Remove non-printing characters and extra spaces:
=TRIM(CLEAN(A2))

Where it breaks down: structure. You get text in cells, but you still have to decide what each value means and arrange it into a usable log. For a few clean documents that is fine; for a monthly batch of crumpled receipts it is slow.

Method 3: An AI receipt converter

AI extraction tools read the receipt the way a person would: they find the merchant name, date, subtotal, tax, and total, and they separate line items into their own rows with quantity and price. Instead of a pile of recognized text, you get a structured spreadsheet.

With PapersToSheet's receipt to Excel converter, the workflow looks like this:

1. Upload receipt photos or PDFs. You can add several at once; multi-page PDFs are fine.
2. Pick an export layout. Standard gives you a documents sheet plus a line-items sheet; summary gives one row per receipt; expense report adds category subtotals; and there is a QuickBooks 3-column CSV.
3. Download as Excel or, from the receipt to CSV page, as a plain CSV for other software.
4. Spot-check the rows against the images, especially faded or handwritten receipts.

The standard layout keeps two related sheets so totals and line items do not get mixed up:

Because both sheets share the File and Date columns, you can pivot line items by vendor or month, or use a lookup to bring each receipt's category across.

Where it breaks down: no extraction is perfect. Badly faded thermal paper, crumpled receipts photographed at an angle, and handwritten amounts can still produce errors. Keep the Subtotal plus Tax equals Total check from Method 1 and review any flagged rows.

A real-world time check: one month of receipts

Picture a freelance photographer with 45 receipts for the month: gas, parking, memory cards, a couple of client lunches, props from a craft store, and a few online orders. Here is how each method plays out in practice.

• Manual entry: header fields only (date, vendor, tax, total) are manageable in one sitting. Adding line items for the craft store and online orders, so props can be split from personal purchases, roughly doubles the work, and that is usually the part that gets skipped.
• Data from Picture: each receipt goes in one at a time, and most land as a single column of text that still needs to be sorted into fields. It saves keystrokes on the clean, printed online-order invoices but helps little on crumpled gas receipts.
• AI converter: all 45 images are uploaded in one batch and come back as one documents sheet and one line-items sheet. The remaining work is reviewing flagged rows, choosing categories, and adding a business purpose for the lunches.

The pattern holds for most small businesses: the more receipts you have, and the more you care about line items, the faster the manual options fall behind. Mixed batches are common too. Supplier invoices that arrive as PDFs can go through the PDF invoice to Excel converter, so you are not forcing a multi-page invoice through a receipt workflow.

Which method should you use?

• Fewer than ten receipts a month and no line items needed: manual entry with a good template is perfectly reasonable.
• Occasional table-like documents, already on Microsoft 365: try Data from Picture, and budget time for cleanup.
• Regular batches, line items, or client work: an AI converter pays for itself in time. A busy month on the weekly or monthly plans costs less than an hour of a bookkeeper's time.

After the import: make the data useful

Getting rows into Excel is the halfway point. A few finishing touches turn the import into something you can file taxes from:

• Add a Category column and fill it with a drop-down so every receipt rolls up to a tax category. Our guide to organizing receipts for taxes suggests a category list.
• Build a monthly summary with a PivotTable, or with =SUMIFS on Category and a month column created by =TEXT(A2, "yyyy-mm").
• Remove duplicates by checking Vendor, Date, and Total together; the same receipt often gets photographed twice.
• Keep the file name column so every row points back to its image.

If your end destination is accounting software rather than Excel, skip a step and export in the format it expects. Our guide on importing receipts into QuickBooks Online walks through that process.