There are five genuinely free ways to get receipt data into Excel. They don't all work equally well, and which one makes sense depends entirely on what kind of receipt you're starting with.
Below is a comparison of all five, with honest notes on where each one breaks down. The article takes no strong position on any single tool — use whichever fits your receipts.
Why this is harder than it looks
Receipts are harder to parse than most documents. Unlike invoices, which follow somewhat predictable layouts, receipts come in every format imaginable: thermal paper (often faded), phone photos taken at odd angles, emailed HTML receipts, PDF receipts from e-commerce platforms, handwritten receipts from small vendors.
The standard workarounds, copy-paste from PDF and Excel's built-in import, were designed for structured native PDFs. They don't handle thermal paper photos or scanned receipts. Knowing this up front tells you which tools are worth trying for your specific format.
Method 1: AI Receipt Converter
AI Converter (CleanTably)
Upload any receipt — PDF, JPG, PNG — and download a structured .xlsx file. No account, no software install. Works with phone photos, scanned PDFs, thermal paper prints, and e-commerce PDFs.
AI-based extraction is the only method that handles all receipt types without requiring preprocessing. The way it works: rather than parsing PDF structure or applying character-level OCR and then trying to infer columns, it reads the receipt the same way a person would. The result is structured data with correct column assignments, even for receipts with unusual layouts.
CleanTably's receipt converter extracts vendor name, date, line items (description, quantity, price), subtotal, tax, and total. The output is a .xlsx file where numbers are numbers — not text — so you can run formulas on it immediately.
The limitation: accuracy drops for blurry or low-resolution photos. A phone photo of a crumpled receipt taken under bad lighting will produce worse output than a clean scan. In good conditions, accuracy on printed receipts is 95–99%. Handwritten receipts: around 85%.
Free tier: 20 receipts per day. No signup required.
Try it now — Upload any receipt and download the Excel file. Free, no account needed.
Method 2: Google Drive OCR + Google Sheets
Google Drive OCR
Upload receipt image to Drive → right-click → Open with Google Docs → Google extracts the text via OCR → copy to Sheets. Manual cleanup required for columns and formatting.
Google Drive has had OCR built into its "Open with Google Docs" feature for years. It's genuinely useful for getting text out of images. The process:
- Go to Google Drive and upload the receipt image (JPG or PNG, or a PDF scan)
- Right-click the file → "Open with" → "Google Docs"
- Google Docs will display the extracted text below the image
- Copy the text and paste it into a Google Sheet
- Use the "Split text to columns" feature to separate the data
The catch: Google Drive extracts raw text, not structured table data. You get the words and numbers from the receipt, but figuring out which numbers are prices versus quantities versus totals requires manual work. For a simple restaurant receipt (date, vendor, total amount), this is manageable. For a receipt with 15 line items at different quantities and prices, it becomes a cleanup project.
This method is free with any Google account and requires no additional tools. It's a reasonable choice when you only need a few fields from a receipt (just the total and date, for example) and don't need full structured output.
Method 3: Excel's Built-in PDF Import
Excel Data → From PDF
Excel can import tables from PDF files directly: Data → Get Data → From File → From PDF. Works well for e-commerce PDF receipts generated by software. Fails entirely on scanned or photographed receipts.
If you receive e-commerce receipts as PDFs — from Amazon, Shopify stores, or accounting software — Excel's built-in PDF import is worth trying. Go to Data → Get Data → From File → From PDF, select your receipt, and Excel will show a navigator with the tables it found.
This works because native PDFs embed text in a parseable format. When the receipt is a clean single-table document, Excel can extract the table reliably. When the PDF has a complex layout (logo, header, line item table, footer, total block), results get unpredictable.
Critical limitation: this only works with native PDFs. A scanned receipt saved as a PDF is just an image inside a PDF container. Excel cannot extract any structured data from it. The same reason copy-paste from PDF breaks data applies here: scanned PDFs don't have selectable text.
If your receipts are digital PDFs from known sources (email attachments from e-commerce platforms), this method is worth trying first before reaching for other tools.
Method 4: iLovePDF or SmallPDF (Free Tier)
Online PDF-to-Excel Converters
iLovePDF, SmallPDF, and similar tools convert PDF tables to Excel. They work for clean native PDFs and partially for high-quality scans. Free tiers allow a few conversions per day.
Tools like iLovePDF and SmallPDF extract PDF content and try to map it to Excel column structure. For a cleanly formatted PDF receipt from a major retailer, they often produce usable output.
The limitations are similar to Excel's built-in import, just accessible without Excel. They work on native PDF text. Some have basic OCR for scanned PDFs, but quality varies significantly. For receipts with complex formatting — anything that isn't essentially a single table — output quality tends to be variable.
Free tier restrictions: iLovePDF allows a limited number of conversions per day on the free plan. SmallPDF is more restrictive — two tasks per day on free accounts. For occasional use with a small batch of PDF receipts, this is fine.
Method 5: Manual Entry
Manual Data Entry
Type the data directly into Excel. 100% accurate when done carefully. Doesn't scale — 20 receipts = 60–100 minutes of entry time. The right choice when you have 1–2 complex receipts and no other method is working.
Manual entry is worth including here because it's the fallback that always works. If the receipt is handwritten, in a language the OCR doesn't handle well, or otherwise not cooperating with any automated method, typing it in is the correct answer.
A typical 10-line receipt takes about 3 minutes to type accurately. That's fine once. It stops being fine around receipt ten of a monthly expense report.
If you're doing manual entry regularly, that's reason enough to spend 20 minutes testing the automated options above.
Which Method Should You Use?
| Your receipt type | Best method | Backup |
|---|---|---|
| Phone photo of receipt | AI converter (CleanTably) | Google Drive OCR |
| E-commerce PDF (Amazon, Shopify) | Excel PDF import or iLovePDF | AI converter |
| Scanned thermal receipt | AI converter | Google Drive OCR |
| Clear digital PDF receipt | Excel PDF import | iLovePDF |
| Handwritten receipt | Manual entry | AI converter (85% accuracy) |
| Mixed batch of any format | AI converter | — |
If you have a mix of receipt formats, or if your receipts are mostly photos or scans, an AI converter is the only method that doesn't have a hard format dependency. Start there.
If your receipts are consistently clean digital PDFs from the same source — Amazon order confirmations, SaaS invoices, that kind of thing — Excel's built-in import or iLovePDF is probably faster.
Convert Your Receipts to Excel Now
Upload any receipt — PDF, photo, scan — and download a clean spreadsheet. Free, no account required.
Try CleanTably FreeTips for Better Results with Any Method
- For phone photos: Lay the receipt flat on a contrasting surface. Even lighting without shadows over the text matters more than camera quality. If there's a glare spot on a number, retake the photo.
- For thermal receipts: These fade over time and the paper often curls. Scan or photograph them promptly. A flatbed scanner produces better input than a phone photo for faded thermal paper.
- For PDF receipts: Use the original PDF file rather than a screenshot. A screenshot introduces an unnecessary image compression step. The original PDF has better quality input for any conversion method.
- For batch processing: AI converters handle mixed formats in one workflow. If you're processing a batch with different receipt types, running them all through an AI converter is simpler than routing each to a different tool.
Frequently Asked Questions
How do I convert a receipt to Excel for free?
Upload your receipt to CleanTably at cleantably.com/receipts. The AI extracts the data and returns a downloadable .xlsx file, free, no account required. For phone photos: flat surface, even lighting, all four corners in frame.
Can I convert a phone photo of a receipt to Excel?
Yes. AI-based converters like CleanTably accept JPG and PNG photos directly. Google Drive OCR also works — upload the photo to Drive, open it with Google Docs, and copy the extracted text to Sheets. Quality depends on photo clarity: sharp focus and even lighting give the best results.
Does Excel have a built-in way to import receipts?
Excel can import from PDF files via Data → Get Data → From File → From PDF. This works for native digital PDFs with clear table structure, but does not work for scanned PDFs or photos of receipts. For those, you need an AI-based tool or OCR.
What's the fastest way to extract receipt data for expense tracking?
For individual receipts: AI converter, about 15 seconds per receipt. For ongoing expense tracking workflows, apps like Expensify or Dext automate this at scale. For one-off or batch conversion without a subscription, CleanTably handles up to 20 receipts per day for free.
Stop Retyping Receipts
Upload any receipt format — phone photo, PDF scan, e-commerce PDF — and get a clean, structured Excel file in seconds.
Convert Receipts Free