How to Scan Receipts Into Excel: 3 Methods, Step by Step
To scan receipts into Excel, photograph each receipt with an app that reads the date, merchant, total and tax. Then export the results as a CSV file and open it in Excel. You can also type the figures in by hand or run photos through a general text-recognition tool, but a dedicated receipt scanner gives you clean columns with the least cleanup.
Below are the three methods side by side, the spreadsheet layout that works, the exact steps, and the fixes for the problems that show up once the data lands in Excel.
What's the fastest way to get receipts into Excel?
It depends on how many receipts you have and how often. Ten receipts once a year is a different job from forty a month for a client or an employer. Here is how the three common methods compare.
| Method | How it works | Cleanup in Excel | Best for |
|---|---|---|---|
| Manual entry | You read each receipt and type the date, merchant, amount and tax into rows | Little, if you type carefully | A handful of receipts, or a one-off claim |
| Generic OCR (phone text recognition, Excel's picture import) | The tool reads every line of text on the photo | A lot: you have to pick the total out of item lines, store addresses and card numbers | Occasional receipts when you already have the tool |
| Receipt scanner app | The app finds the total, tax and date and stores them as fields, then exports a CSV | Light: check dates and number formats | Regular expenses, freelancers, monthly reports |
The difference comes down to structure. Generic OCR turns a photo into text. A receipt scanner turns it into data, with one receipt per row and one value per column. That is what Excel needs.
How should you set up the spreadsheet first?
Decide your columns before you scan anything. If you skip this, you end up reshaping data every month. A layout that works for most people:
- Date: the purchase date, not the day you scanned it.
- Merchant: the store or supplier name.
- Category: meals, travel, office supplies, fuel, software, and so on.
- Total: the amount paid, tax included.
- Tax: the sales tax (or VAT/GST if you buy abroad) shown on the receipt.
- Payment method: personal card, company card, cash.
- Notes: the client, project or reason for the expense.
- File: the name or link of the receipt image, so you can find the proof later.
Turn the range into an Excel table (select it and press Ctrl+T, or Cmd+T on a Mac). Tables expand when you paste new rows, keep formulas consistent and make filtering easy. Add a drop-down list for Category with Data > Data Validation, so "Meals", "meals" and "Food" don't end up as three different categories.
How do you scan receipts into Excel with a receipt app?
This is the method I use for anything more than a few receipts a month. Say you come back from a three-day work trip with 14 receipts: a $212.40 hotel folio, two Uber rides at $23.85 and $31.10, a $9.75 parking stub, several meals. Here is how they get into Excel in about ten minutes.
- Flatten and light the receipts. Lay them on a dark, plain surface near a window or under a ceiling light. Thermal paper curls, so press it flat for a second. Avoid shadows across the total line.
- Scan each receipt with ScanTicket (also on Android). The receipt frame is detected and captured automatically, and the total, the tax and the date are read for you. Long hotel folios work the same way.
- Check the figures. Glance at each total and date against the paper. If a value was misread, correct it in one tap instead of retyping the whole row. Faded receipts and handwritten tips are where errors usually hide.
- Assign a category. Use the same category names as your spreadsheet drop-down. Custom categories let you match your employer's or accountant's list exactly.
- Export as CSV. Export the period you need, such as the trip or the month. CSV gives you the raw data for Excel. Export a PDF too if your employer or accountant wants a readable report with the receipts attached.
- Open the CSV in Excel the right way. Don't double-click the file. In Excel, go to Data > From Text/CSV, pick the file, check the preview and click Load. This lets you control how dates and numbers are read (more on that below).
- Paste or append into your master table. Copy the new rows under your existing ones, or keep each month on its own sheet and combine them with Power Query later.
If you keep your scans synced to Dropbox, iCloud, Google Drive or OneDrive, you can open the export straight from your computer without emailing files to yourself.
Can you scan receipts into Excel without a dedicated app?
Yes. It just takes more cleanup. Two free options:
Your phone's text recognition
On an iPhone, Live Text lets you select text in a photo and copy it. On Android, Google Lens does the same. Point the camera at the receipt, select the total and date, and paste them into your sheet. It works well for a few receipts. With twenty, you are still doing manual entry, just with copy and paste instead of typing.
Excel's picture import
Recent versions of Excel can import data from a picture of a table. It is built for printed tables, though, not for receipts. A grocery receipt comes in as dozens of rows: the store address, each item, the subtotal, the tax, the card number, the return policy. You then delete everything except the two or three values you wanted. For one receipt, that's fine. For a month of receipts, it is slower than typing.
Plain manual entry, done well
If you only have a few receipts, typing is honestly fine. Speed it up with these habits:
- Sort the paper receipts by date before you start, so rows go in order.
- Use the drop-down for categories instead of typing them.
- Type amounts without the dollar sign. Format the column as Currency once.
- Add a running total at the bottom and compare it with your card statement when you finish.
How do you fix the data once it's in Excel?
Whatever method you use, a few problems come up again and again. Here is how to spot and fix each one.
Dates that are actually text
If dates are left-aligned, or sorting puts March before January, Excel is treating them as text. This usually happens when the file uses day/month/year and your Excel expects month/day/year, or the other way around. Fix it at import: in the From Text/CSV preview, click Transform Data, right-click the date column, choose Change Type > Using Locale, and pick the date format the file actually uses. On an existing sheet, Data > Text to Columns with the right date order also works.
Amounts with commas as decimal points
Receipts from Europe, or apps set to a European language, may write $42.80 as 42,80. Excel in US settings reads that as text, or as 4,280. Use the same Change Type > Using Locale step and choose a locale that uses decimal commas, such as French (France). The values convert to proper numbers.
Duplicates
Scanning the same receipt twice is easy, especially long ones. Select your table and use Data > Remove Duplicates on Date, Merchant and Total together. Review before deleting: two $4.50 coffees at the same café on the same day can both be real.
Totals that don't match your statement
Add up the month with a simple formula such as =SUM(Table1[Total]) and compare it with your card statement. A gap usually means a missing receipt, a tip added after the receipt was printed, or a refund. The card statement is the best checklist you have.
How do you turn the spreadsheet into totals by category or month?
Once the data is clean, two tools do most of the work.
- SUMIFS for quick totals. To total meals: =SUMIFS(Table1[Total],Table1[Category],"Meals"). Add a date range to limit it to one month.
- A PivotTable for the full picture. Select the table, go to Insert > PivotTable, drag Category to Rows, Date to Columns (group by month) and Total to Values. You get a month-by-category grid you can refresh as you add rows.
For a business owner, the same grid makes year-end easier. Your tax preparer can see that you spent, say, $1,860 on software and $640 on office supplies, with each line backed by a receipt in the File column. If you sort expenses for a household budget instead, our guide on organizing spending by category covers how to choose categories that stay useful.
Should you keep the receipt images after scanning?
Yes. The spreadsheet is a summary, not the proof. If your employer audits an expense claim or the IRS asks you to support a deduction, they will want to see the receipt itself, not a row in Excel.
The IRS generally accepts electronic copies of records as long as they are complete and legible. The details, and how long you need to keep different records, are explained in IRS Publication 583. Check it or ask your tax preparer for your own situation. In practice:
- Keep the image of every receipt that appears in your spreadsheet.
- Name or tag it so you can match it to its row: date, merchant and amount is enough.
- Store it somewhere backed up, not only on your phone.
- Scan thermal receipts quickly. They fade, sometimes within months, and a blank slip proves nothing.
Set this up once and the monthly routine is short: scan receipts as you get them, export at the end of the month, import into Excel, check the total against your statement. That takes about fifteen minutes instead of an evening with a shoebox.
Frequently asked questions
Can Excel read a photo of a receipt directly?
Recent versions of Excel can import data from a picture, but the feature is built for tables. On a receipt it pulls in every line, so you have to delete the address, items and card details to keep the total and date.
Is CSV or XLSX better for receipt data?
CSV is the safest format for moving receipt data between apps because almost everything can read it. Import it with Data > From Text/CSV, then save your working file as XLSX to keep formulas, formatting and PivotTables.
Why are my receipt dates wrong after opening the CSV in Excel?
The file probably uses a different date order than your Excel settings, such as day/month/year instead of month/day/year. Import with Data > From Text/CSV and set the column type using the correct locale to fix it.
Do I still need the paper receipt after scanning it into Excel?
The spreadsheet alone is not proof of an expense, so keep a clear image of each receipt. The IRS generally accepts legible electronic copies; check IRS guidance or your tax preparer for how long to keep them.
How many receipts make an app worth it over typing?
If you handle more than a few receipts a month, or have regular expense reports, a scanner that reads the total, tax and date and exports a CSV usually saves time. For a handful a year, typing them in is fine.

