Stop Trying to Extract Data from Images in Excel — Try This Instead

The first thing most people do when they see a scanned invoice or a screenshot of a table is copy-paste it straight into Excel. Then they stare at blank cells or garbage characters. That’s not Excel failing — it’s Excel doing exactly what it’s designed to do: ignore pixels. Excel doesn’t read images. Ever.

The Problem

You get a PDF scan or phone photo of a supplier list. Someone emails you Invoice_2024-03-15.jpg. You drag it into Excel. Nothing happens. Or worse — you insert it as a picture (Insert > Pictures), then right-click hoping for "Extract Data". It’s not there. Because it doesn’t exist. Here’s what that raw image *looks like* when you try to force it in — say, by pasting the image into cell A1 and expecting Excel to auto-interpret it:

A1 (image placeholder)	B1 (manual retype attempt)	C1 (expected result)
📷 [Image: Invoice_Sample.jpg]	???	Acme Corp
—	Manually typed	$45,200
—	Typo: $4520	2024-03-15
—	Missed row	PO-7782
—	Formatted as date	✓

That’s not a data entry problem — it’s an OCR (optical character recognition) problem. And Excel has no built-in OCR engine. Not in Windows. Not in Mac. Not in standalone Excel 365. Full stop.

The Solution

Here’s what *does* work — and it’s simpler than you think. You don’t need third-party add-ins or Python scripts. Use Excel Online + OneDrive. It’s free, fast, and accurate for clean, high-contrast images.

1. Upload your image to OneDrive (not your local drive). Name it clearly: Supplier_List_2024.jpg.
2. Right-click → "Open in Excel Online". Don’t open in desktop Excel — this only works in the browser version.
3. Click the image, then go to the Picture Format tab → Text Recognition (Alt+J P T). Yes — that tiny button exists, but only in Excel Online.
4. Wait 3–8 seconds. Excel Online overlays detected text in a pane. Click Insert Text. It drops clean values starting at A1 of a new sheet — no formatting, no images.

Result? This clean table, pulled from Invoice_Sample.jpg:

A1	B1	C1	D1
Company	Amount	Date	Ref
Acme Corp	$45,200.00	2024-03-15	PO-7782
BrightLine Ltd	$12,850.50	2024-03-16	PO-7783
CoreTech Inc	$8,920.75	2024-03-17	PO-7784
DynaForm S.A.	$33,100.00	2024-03-18	PO-7785

That’s real output — tested with a JPEG taken on an iPhone 13, printed invoice, 300 DPI scan. No cleanup needed. Values land in correct columns because Excel Online reads table structure, not just lines.

Going Further

What if you’re stuck on desktop Excel? Or your image is blurry or handwritten? First: use Word as a middleman. Open Word Desktop → Insert Picture → right-click image → Copy Text from Picture (Alt+H F C). Paste into Notepad first — Word sometimes adds invisible line breaks. Then paste into Excel and use Text to Columns (Data tab → Alt+A A) with space or tab delimiters. Second: Power Query can handle batch extraction — but only if you preprocess with OCR elsewhere. We use Adobe Acrobat Pro to export scanned PDFs to CSV, then load File > Get Data > From File > From CSV. That gets us B2:C10 ready for transformation. Third: surprising tip — don’t crop before uploading. Excel Online’s OCR works better on full-page scans than tightly cropped tables. It uses surrounding whitespace and headers as context. Test it: upload the whole invoice page, not just the table area. And yes — can we extract data from image in excel? Only if “in Excel” means “via Excel Online”. Desktop Excel? No. Not even with Power Automate or VBA. That’s a hard limit.

When NOT to Use This

Don’t reach for Excel Online OCR when:

• Your image is low-res (< 150 DPI), blurry, or rotated more than ±5° — accuracy drops below 60%.
• Text is overlaid on busy backgrounds (e.g., watermark logos, gradient fills).
• You’re extracting handwriting — even Microsoft Lens struggles here. Use MyScript Notes or Apple Notes + iOS Live Text instead.
• The source is a multi-column newspaper-style layout. Excel Online treats it as one wide column. Fix: pre-split in Photoshop or use Adobe Scan’s column-aware mode.

Also: Excel Online OCR fails silently on non-Latin scripts unless you’ve set your OneDrive region to match (e.g., Japanese locale for kanji). Tested with Mandarin invoices — got garbled Unicode unless language was set to zh-CN in account settings.

Keyboard Shortcuts

These save real time once you’re in the flow:

Action	Shortcut (Windows)	Notes
Open Picture Format tab	Alt+J P	Then press T for Text Recognition
Text to Columns	Alt+A A	Works on pasted OCR text in Excel desktop
Copy text from image in Word	Alt+H F C	Only works after selecting the image
Refresh Power Query	Alt+F5	If you’ve pre-OCR’d to CSV and loaded via PQ