Does Excel Have a Receipt Scanner? What It Can and Cannot Do

No, Excel does not have a receipt scanner. Microsoft Excel includes a feature called Data from Picture that can read a printed or on-screen table into cells, and on a phone you can point the camera at rows and columns. But it is a generic table reader, not a receipt scanner: it does not know what a vendor, a subtotal, a sales tax line, or a payment method is, it handles one image at a time, and it makes no attempt to structure the result into an accounting-ready record. For business receipts you need OCR that is built to read receipts, then hand the fields back to Excel.

Last updated July 2026.

Does Excel have a built-in receipt scanner?

No. There is no menu item in Excel called receipt scanner, and no template that pulls receipt data in automatically. The closest tool is Data from Picture, found under the Data tab on Excel for Windows (Data, then From Picture) and in the Excel mobile app. It uses optical character recognition to turn a photographed table into editable cells. Microsoft designed it for whiteboards, printouts, and screenshots of tabular data, not for the messy, non-tabular layout of a real receipt.

When you feed a receipt to Data from Picture, it tries to force the receipt into a grid. A receipt is not a clean grid. The merchant name, the date, a column of items, a subtotal, tax, tip, and total are scattered across the layout, often on faded thermal paper. The tool typically returns a jumble that you still have to clean up cell by cell, which defeats the point.

What does Excel's Data from Picture feature actually do?

Data from Picture converts an image of a table into rows and columns you can edit in a worksheet. You capture or upload the image, Excel processes it, flags any cells it is unsure about for review, and inserts the result. It works well on a clean printed table with clear gridlines. It has real limits for receipts:

• No field understanding. It reads characters, not meaning. It will not label one number as the total and another as sales tax, because it does not know it is looking at a receipt.
• One image at a time. There is no batch mode. A shoebox of 200 receipts is 200 separate captures and 200 cleanups.
• No line-item extraction. Individual purchased items rarely survive as clean, separated rows.
• Platform limits. On Windows it needs a recent Windows 10 or 11 build with the Edge WebView2 runtime, and the polished capture experience lives in the mobile app.

How do I get receipt data into Excel then?

Use a receipt scanner that is built to read receipts and exports to Excel, rather than asking Excel to be the scanner. A purpose-built tool identifies the vendor, date, payment method, line items, sales tax, and total on each receipt, assigns a category, and returns a clean spreadsheet. You upload a whole stack at once, review the rows, and you are done. Our receipt to excel converter does exactly this, and the receipt scanner app covers the same workflow from a phone or desktop browser with no install.

Here is how the two approaches compare for business use.

Can Excel read a receipt on a phone?

The Excel mobile app can photograph a table and drop it into a sheet, so in a narrow sense it can read a phone image. It cannot interpret that image as a receipt. You get raw text or a rough grid, not a categorized expense record with the tax split out. For one receipt in a pinch it saves a little typing. For the volume a business actually deals with, it is slower than uploading the batch to a scanner that returns a finished spreadsheet.

Is a scanned receipt in Excel good enough for taxes?

It can be, if the record is complete. The IRS accepts digital records as long as they are an accurate and legible reproduction of the original and show the merchant, date, amount, and what was purchased. A row of numbers that Data from Picture guessed at, with no clear vendor or tax field, is weak substantiation. Extracted, itemized data that keeps the vendor, date, line items, and tax is far more defensible. If you also reconcile card spending, you can convert the PDF statement to a spreadsheet and match it against your receipt file, so every charge has a document behind it.

The bottom line

Excel is a spreadsheet, not a receipt scanner. Its Data from Picture tool is handy for a clean printed table, but it does not understand receipts, cannot batch them, and leaves you cleaning up cells. The reliable path is to extract the receipt data with a tool built for the job, then work with the finished file in Excel. Drop your receipts into the receipt to excel converter and download a ready-to-use spreadsheet, or read how a bulk receipt scanner clears a full backlog in one upload.