Back to Blog

    How to Convert Receipts to Excel for Free

    Published Updated 8 min read

    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.

    1. Flatten the receipt. Hold down the curled ends, because a curve bends the lines of text.
    2. Use bright, even light. Daylight near a window works well. Keep your shadow and your phone's shadow off the paper.
    3. Hold the phone straight above it. Shooting at an angle makes the far end of the receipt smaller and harder to read.
    4. Fill the frame. Use a plain, contrasting background and get close enough that the text is sharp.
    5. 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

    1. Open the free Receipt OCR tool.
    2. Upload your photo, or paste a link to it.
    3. 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.
    4. 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.
    5. 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.

    1. Collect. Keep receipts in one envelope through the month, or photograph them as you get them.
    2. Name the files. Rename photos with the date and merchant, like the sample above, so they sort correctly.
    3. 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.
    4. Enter as you go. Download each receipt's file and add its summary row before you move on, so you never lose your place.
    5. 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.

    Frequently asked questions

    Can I convert a receipt to Excel for free?+

    Yes. Upload a photo of the receipt to our Receipt OCR tool, then select Download .xlsx. Each item and its price become a row with Qty, Item and Amount columns, even when the price is printed on the line below the item. If the receipt shows VAT rates, they go in a fourth Tax rate column. Check the file against the receipt before you rely on it.

    Does your tool create an Excel file?+

    Yes. Download .xlsx saves a real Excel workbook. When most items in the text have a price, at the end of the line or on the line below, they go into Qty, Item and Amount columns, with amounts stored as numbers. Any other text becomes one line per row.

    How many receipts can I process for free?+

    You can run 10 extractions an hour with our tool. For a month of receipts, work through them in batches of ten, or spread them across a few short sessions.

    What should I do with faded thermal receipts?+

    Photograph them as soon as you can, because thermal print fades over time. Use bright, even light and check the total against the paper, since faint digits are the characters OCR is most likely to misread.

    Should I keep the original receipts?+

    Check with your local tax authority or an accountant, because the rules differ by country and situation. Whatever you decide, keep the photo alongside your spreadsheet row so you can check any entry later.

    Start with your first receipt

    Upload a receipt photo and download it as an Excel file. Free, with no account.

    Open the free Receipt OCR tool

    Related tools

    Related articles