How to Scan Receipts into Excel and CSV

You can scan receipts into Excel three ways: use Excel's built-in Data from Picture tool for a single image, type the details into a tracker by hand, or run a whole stack through AI receipt data extraction that exports a finished spreadsheet. For more than a handful of receipts, automated extraction is fastest because it reads the vendor, date, total, and sales tax for you.

Three ways to scan receipts into Excel

Every method has the same goal: turn the text on a paper slip, PDF, or photo into rows and columns you can total and filter. Here is how the common approaches compare before we walk through each one.

• Excel Data from Picture: free and built in, but it handles one image at a time and struggles with faded thermal receipts.
• Manual entry: full control and no extra tools, but slow and error prone once the pile grows.
• AI receipt extraction: reads many files at once and exports a clean Excel or CSV file, which is the practical choice when you have a backlog to clear.

Method 1: Use Excel's Data from Picture feature

Microsoft 365 includes a Data from Picture tool that uses OCR to read an image and place the values into cells. Open the Data tab, click From Picture in the Get and Transform group, then choose Picture From File or take a photo with your phone. Excel reads the receipt, shows each detected value, and asks you to review and correct anything before it inserts the row.

This is genuinely useful for a clearly printed receipt with a standard layout. The limits show up fast, though: it processes one image at a time with no batch option, and accuracy drops on thermal paper, creased slips, and unusual formats. If you only log a receipt or two a week, it is fine. For a month of expenses it becomes a chore.

Method 2: Build a receipt tracker and enter the data by hand

If you prefer total control, create a simple tracker. Add column headers for Date, Vendor, Category, Subtotal, Sales Tax, Total, Payment Method, and Notes, then type in each receipt. Use a SUM formula at the bottom of the Total column and a pivot table to break spending down by category. This costs nothing and keeps your records exactly the way you want them.

The downside is time. Manual entry works for a low volume, but every keystroke is a chance to fat-finger a number, and reconciling those errors later eats the hours you saved. Whichever method you use, keep the original image: the IRS accepts a legible digital copy, so a clean scan attached to each row protects the deduction. Our guide to how long to keep business receipts covers the retention periods, and the receipt scanner for taxes page explains what makes a write-off defensible.

Method 3: Extract a whole stack with AI, then open it in Excel

When you have a shoebox, a travel folder, or a year of expenses, one-at-a-time OCR and manual typing stop being realistic. An AI receipt extractor reads each file separately, pulls the vendor, date, line items, subtotal, and tax, and returns a single spreadsheet with consistent column headers. It handles photos, PDFs, and emailed receipts in the same batch, so you upload once and download a ready-to-use file.

The receipt to Excel converter does exactly this, and the bulk receipt scanner is built for high volume, reading each receipt on its own rather than cramming several into one photo where accuracy falls apart. If your books live in Google's tools instead, the same export drops straight into a sheet, which the receipt to Google Sheets guide walks through.

Which columns should a receipt spreadsheet have?

Consistent headers are what make a receipt spreadsheet useful. At a minimum capture Date, Vendor, Category, Amount, and Sales Tax; add Payment Method and a Notes field if you split personal and business spending. Our guide to extracting receipt data to Excel goes deeper on which fields are worth capturing and how to reconcile them against your bank statement. Keep the header names identical every month so your formulas, filters, and pivot tables keep working as the file grows. If you later move to dedicated software, those same fields map cleanly into receipt OCR software or your accounting system.

Frequently asked questions

Can Excel read a receipt?

Yes. Excel's Data from Picture tool uses OCR to read a receipt photo and turn it into a table you can edit. It works best on clearly printed receipts with a standard layout, and it asks you to review each value before inserting it. It reads one image at a time and is less reliable on faded thermal paper.

How do I scan a receipt into Excel?

Open the Data tab, click From Picture, and choose Picture From File or take a photo. Excel runs OCR on the image, shows the values it detected, and lets you correct them before placing the row into your sheet. For a single, clean receipt this takes under a minute. For a pile of receipts, batch extraction is faster.

Can I scan multiple receipts into Excel at once?

Not with Excel by itself; Data from Picture handles one image per run. To process many receipts at once, use an AI receipt extractor that accepts a batch of files and returns a single spreadsheet. That is the difference between an hour of clicking and a one-time upload, especially at tax time.

How do I convert a paper receipt to Excel?

Photograph or scan the paper receipt first, then feed the image into Excel's Data from Picture tool or an AI extractor. Both read the printed text and convert it to cells. Keep the image file afterward, because a legible digital copy is an acceptable record for tax purposes even after you recycle the paper.

How do I scan a PDF receipt into Excel?

For a digital PDF, Excel's Get Data, From PDF option can pull text-based content, though tables often need cleanup. For a scanned or emailed PDF receipt, an AI extractor is more reliable because it reads the layout, captures the vendor and totals, and exports a clean Excel or CSV file you can open right away. If a comma-separated file is what your accounting import expects, the receipt to CSV converter returns that format directly.

Is there a free way to scan receipts into Excel?

Excel's Data from Picture feature is included with Microsoft 365 at no extra cost and handles occasional receipts, though it is not a true receipt scanner. It is free but slow for volume since it works one image at a time. When the count climbs into the dozens, a paid batch extractor usually pays for itself in the hours it saves on data entry.

If you are past the point of typing receipts by hand, upload your stack to the receipt to Excel converter and download a finished spreadsheet, or read more about choosing a tool in our receipt OCR software overview.