How to Extract a Table From an Image Into Excel (5 Methods That Actually Work)

You've got a table — in a screenshot, a chart, a scanned PDF, a slide someone exported as a PNG — and you need it in Excel. You try to select it. Nothing highlights. Copy-paste gives you nothing, because to your computer that table isn't data: it's a picture of data.

If you've ever found yourself re-typing numbers off your screen cell by cell, this post is for you. Here are five methods to extract a table from an image into Excel, with the honest pros and cons of each.

Method 1 — Excel's built-in "Data from Picture" (mobile)

Microsoft quietly shipped this in the Excel mobile app and it's genuinely useful when it works.

Steps:

1. Open the Excel app on your phone (iOS/Android).
2. Tap Insert → Data from Picture.
3. Photograph your screen (or pick the image from your gallery).
4. Review Excel's guesses, fix flagged cells, tap Insert.

Pros: free, built into Excel, no extra tools.
Cons: mobile-only — there's no desktop equivalent, so you end up photographing your own monitor, which is as silly as it sounds. It also struggles with dense tables, merged cells, and low-contrast screenshots, and every mis-read cell needs manual review on a phone keyboard.

Best for: paper documents you can photograph, occasional one-offs.

Method 2 — The Google Drive OCR trick

Google Docs has hidden OCR: upload an image to Drive, right-click it, Open with → Google Docs, and Google appends the recognized text under the image. Copy that text into Sheets and use Data → Split text to columns.

Pros: free, works on desktop, surprisingly good character recognition.
Cons: it outputs a wall of text, not a table. Column boundaries are lost, so you spend your saved time splitting text back into columns and re-aligning rows. Multi-line cells and numbers with thousands separators get mangled.

Best for: paragraphs of scanned text. Weak for real tables.

Method 3 — A drag-select browser extension (the quick one-off king)

This is the method I use daily, mostly because I got tired of the other four and built it: Snap to Data, a Chrome extension.

Steps:

1. Press Alt+S on any page (or click the extension icon).
2. Drag a box over the table — it can be an image, a chart, a scanned page, anything visible.
3. Get back plain text, markdown, or a CSV, and paste it straight into Excel or Google Sheets.

That's the whole workflow: drag, copy, paste. It reads the pixels, so it doesn't matter whether the table is real HTML, an image, a canvas chart, or a screenshot in a PDF viewer.

Pros: works on desktop right where the table is (your browser), keeps rows and columns aligned, outputs paste-ready CSV, handles images and scans — exactly where the copy-paste approach dies.
Cons: Chrome-family browsers only; the free tier covers 5 snaps a month (Pro is $9.99/mo if you live in spreadsheets).

Best for: the "I just need THIS table in Excel, now" moment.

Method 4 — Dedicated OCR services (for bulk jobs)

If you have fifty scanned PDFs of tables, one-off tools stop making sense.

• Tabula (free, open source) — excellent for native PDF tables; it does not OCR scanned images.
• Online OCR converters (Smallpdf, Adobe's online tools, OCR.space, etc.) — upload the file, download an .xlsx. Quality varies wildly with scan quality.
• Cloud OCR APIs (Google Vision, AWS Textract) — the industrial option if you can script; Textract in particular returns real table structure.

Pros: built for volume, some preserve table structure well.
Cons: setup friction, per-page pricing on the good ones, privacy questions when uploading sensitive documents to random converter sites.

Best for: batch processing, recurring pipelines.

Method 5 — Re-typing it by hand

The fallback nobody wants. For a 5×4 table it's honestly fine — two minutes and you're done, no tools. For anything bigger it's slow and, worse, error-prone: transposed digits in a table you'll base decisions on are far more expensive than any tool.

If you catch yourself doing this weekly, you're the exact person methods 3 and 4 exist for.

Comparison

Method	Works on images?	Keeps table structure?	Desktop?	Free?	Best for
Excel "Data from Picture"	✅	Mostly	❌ mobile only	✅	Photographed paper docs
Google Drive OCR	✅	❌ loses columns	✅	✅	Scanned prose, not tables
Snap to Data extension	✅	✅	✅	5/mo free	Quick one-off tables in the browser
OCR services / Textract	✅	Varies–✅	✅	Partly	Bulk / recurring jobs
Manual retype	✅	✅	✅	✅	Tiny tables only

The bottom line

To extract a table from an image into Excel: for a quick one-off in your browser, a drag-select tool like Snap to Data gets you a clean CSV in seconds; for bulk scanned documents, use a proper OCR service; and if you're on your phone with a paper document, Excel's own Data from Picture is right there. Whatever you pick — stop re-typing data off your screen. Life's too short.

Built something similar or found a better workflow? I'd genuinely like to hear it — I built Snap to Data because of this exact headache and I'm still improving the messy-table handling.