How to Convert Receipts to Excel for Free
Summary: Turn a receipt photo into an Excel file for free. The tool splits item lines into columns, and this guide shows how to check them and keep a month in one sheet.
To convert receipts to Excel for free, photograph each receipt, upload it to a free receipt OCR tool, and select Download .xlsx. Each item and its price come out as a row with Qty, Item and Amount columns, even when the price sits on its own line, ready to check and add to your own records.
The split into columns is automatic but not perfect, because it works from the text OCR reads. This article covers what to capture, how to take photos that OCR can read, what the Excel file contains, and how to keep a whole month in one sheet.
What to capture from each receipt
You don't need every line. Start with the fields you'll actually use, and add more only if you have a reason.
| Field | Why you want it | Where it usually is |
|---|---|---|
| Date | Sorting, monthly totals, matching to bank statements | Near the top or bottom |
| Merchant | Knowing who you paid | Top of the receipt |
| Total | The amount you actually spent | Near the bottom, often in larger type |
| Tax | Needed if you claim or report it | Just above the total |
| Payment method | Matching to a card or account | Below the total |
| Category | Your own label, such as Travel or Supplies | You add this yourself |
Line items are the slowest part to record, so skip them unless you need them for a claim or a warranty.
Photograph receipts so OCR can read them
Most OCR problems with receipts start with the photo. A few habits help a lot.
- Flatten the receipt. Hold down the curled ends, because a curve bends the lines of text.
- Use bright, even light. Daylight near a window works well. Keep your shadow and your phone's shadow off the paper.
- Hold the phone straight above it. Shooting at an angle makes the far end of the receipt smaller and harder to read.
- Fill the frame. Use a plain, contrasting background and get close enough that the text is sharp.
- Do it soon. Thermal paper fades, and a faded total is the hardest thing to recover later.
Keep each image at 5 MB or less, which is our tool's limit. If a photo is larger, a screenshot of the photo is a quick way to get a smaller file.
For very long receipts, take two overlapping photos and run them separately, rather than shrinking everything to fit one shot.
Turn the photo into an Excel file
- Open the free Receipt OCR tool.
- Upload your photo, or paste a link to it.
- Wait a few seconds. Clear receipts are read by OCR in your browser. If that isn't confident enough, the image goes to Google's Gemini API for a second attempt.
- Check the text against the photo, and correct any mistakes in the text box. The Excel file is made from this text, so fix it here first.
- Select Download .xlsx.
Pay most attention to the digits. A 1 read as a 7 or a moved decimal point changes your total and is easy to miss.
If your receipts are PDFs rather than paper, for example from an online order, use PDF to Text instead. Its results have the same Download .xlsx button.
What's in the Excel file
When most items have a price, as on a typical receipt, the file has Qty, Item and Amount columns, plus a Tax rate column if the receipt prints VAT rates such as 22,00%. These rows come from a sample grocery receipt.
| Qty | Item | Amount |
|---|---|---|
| 2 | APPLE | 1.00 |
| 3 | BANANA | 1.50 |
| TOTAL | 27.35 | |
| CASH | 30.00 |
- Amounts are numbers, shown with two decimals, so Excel can add them up and sort them.
- The quantity is the number at the start of a line, if there is one. Whether that line's amount is the unit price or the line total depends on the receipt.
- Multi-buy lines fill in the quantity. A line such as 6 X 0,22 puts 6 in the Qty column of its item and keeps the line total as the amount.
- Weight lines stay with their item. A line such as 0.217 kg NET @ $3.90/kg is added to the item's name in brackets, not read as a price.
- Totals and payments are rows too. TOTAL, CASH and CHANGE come through like items, so don't add up the whole Amount column, or you'll count the purchase more than once.
- Other lines go in the Item column, such as the store name or a line OCR misread.
Prices written with a currency symbol, a decimal comma or a minus sign, such as $1.50, 1,50 or -1.98, are read as numbers. A price with no decimal places, such as 3, isn't recognized as an amount, so check those lines. Text that doesn't look like a receipt, such as a letter, becomes one line per row.
Keep a month in one sheet
Each download covers one receipt. For a running record, keep a summary workbook with one row per receipt, and copy the date, merchant, tax and total into it from each file. The rows below are made-up examples.
| Date | Merchant | Category | Tax | Total | Paid with | Photo file |
|---|---|---|---|---|---|---|
| 2026-10-03 | Example Cafe | Meals | 0.84 | 9.34 | Card | 2026-10-03-example-cafe.jpg |
| 2026-10-05 | Example Hardware | Supplies | 2.10 | 28.10 | Card | 2026-10-05-example-hardware.jpg |
| 2026-10-09 | Example Fuel | Travel | 3.25 | 43.25 | Cash | 2026-10-09-example-fuel.jpg |
A few small choices will save you trouble later:
- Use real dates. Enter dates in one consistent format so Excel recognizes them, and you can then sort and filter by month.
- Keep numbers as numbers. The downloaded amounts are already numbers. When you type or paste one, leave out the currency symbol so formulas still work.
- Add totals. At the bottom of the Total column, a formula such as =SUM(E2:E100) gives you the running amount.
- Link to the photo. The Photo file column lets you find the original when a number looks wrong.
Batch a month of receipts
Doing a month in one sitting is easier with a routine.
- Collect. Keep receipts in one envelope through the month, or photograph them as you get them.
- Name the files. Rename photos with the date and merchant, like the sample above, so they sort correctly.
- Run them in groups. You can drop several images into the tool at once to queue them. The tool allows 10 extractions an hour, and receipts that need the AI step also count toward 30 server requests a day, so a busy month may take a few sessions.
- Enter as you go. Download each receipt's file and add its summary row before you move on, so you never lose your place.
- Check the total. Compare the month's total with your bank or card statement, which catches most typing and OCR errors.
Our guide to digitizing receipts covers organizing and backing up the files themselves. If these receipts are headed for a claim at work, OCR for expense reports focuses on that process.
Mistakes that throw off your totals
These are the errors that most often make a spreadsheet disagree with your bank statement.
- Using the subtotal. Receipts often show a subtotal, tax and total close together. Record the final total, and take care when OCR returns them on neighboring lines.
- Missing the tip. On a restaurant receipt, a handwritten tip may not be part of the printed total. Check it against your statement.
- Entering a purchase twice. A card slip and an itemized receipt for the same purchase are easy to count as two expenses. Keep both photos, but give them one row.
- Mixing date formats. 03/04 means different dates in different countries. Writing dates as 2026-04-03 removes the doubt and also sorts correctly.
- Mixing currencies. If you travel, add a Currency column rather than adding different currencies together.
- Forgetting refunds. Enter a refund as a negative amount, so that the total stays right.
When to move to paid software
A free tool and a spreadsheet work well when volumes are low and you're the only person involved. Paid software starts to make sense when:
- You're handling enough receipts that typing them in takes real time each week.
- You want the date, merchant and tax captured automatically, without checking each file.
- Other people need to submit or approve expenses.
- You want receipts to flow straight into your accounting software.
Our comparison of the best receipt OCR software explains what to look for. Until you reach that point, the routine above costs nothing and leaves you with records you fully understand.