How to Convert a Screenshot of a Table into Excel

Updated July 14, 2026 · Written by a working indie developer, tested in Chrome 130+ and Excel for Microsoft 365

The short answer: plain OCR is the wrong tool — it reads the words but throws away the rows and columns, so you get a text soup that takes longer to fix than retyping. Use something that rebuilds the table structure: Excel's built-in Data from Picture if you already have Microsoft 365, or a screenshot OCR tool with a table mode if the table is on your screen right now. Both give you an editable grid, not a paragraph.

Why normal OCR mangles tables

A table is two things at once: the text in the cells, and the grid that says which cell each word belongs to. Generic OCR only recovers the first. Columns get merged, numbers drift into the wrong row, and a 40-cell table becomes 15 lines of text you have to re-split by hand. Tools built for tables run a second model that detects the grid — that's the difference that matters, and it's why the methods below are ranked by how well they preserve structure.

1. Excel's built-in "Data from Picture" — best if you live in Excel

Excel for Microsoft 365 (Windows and Mac) and the Excel mobile app can import a table directly from an image:

Save your screenshot as an image file (or take the photo with your phone in the mobile app).
In Excel: Insert → Data From Picture → Picture From File.
Review the preview — Excel flags low-confidence cells for you to check — then click Insert Data.

It handles clean tables well. Its weak spots in our testing: merged cells, dense grids with small fonts, and anything with mixed languages in one cell. It also requires a Microsoft 365 subscription — the one-time-purchase Office versions don't include it — and you have to leave the browser, save a file, and switch apps for every table.

2. Online "image to Excel" converters — fine for public data, think twice for internal data

Plenty of websites convert an uploaded screenshot to an .xlsx for free. For a public timetable or a stats table from a news article, they're perfectly reasonable. Two honest caveats:

Your table leaves your machine. The screenshots people most often need converted — ERP screens, payroll runs, price lists, internal reports — are exactly the ones you shouldn't upload to a stranger's server. Check what the converter's privacy policy says about retention before you feed it anything sensitive.
Free tiers are metered. Most cap pages per day and watermark or queue you after a few conversions.

3. Retype it — seriously, for small tables

For a 3×4 table, typing it out takes two minutes and produces zero errors to proofread. Every conversion tool needs a review pass; below roughly a dozen cells, the review costs more than the typing. This is the honest baseline every tool on this page has to beat.

4. A screenshot OCR extension with table mode — best when the table is on your screen

Disclosure: ShotMagic is our own product, so judge this section accordingly.

If the table is in your browser — a dashboard, a legacy ERP screen with export disabled, a PDF report, a picture on a wiki — a table-aware screenshot extension skips the save-file-switch-apps loop entirely:

Press the shortcut, drag a box over the table.
The rows and columns are rebuilt and shown in a preview popup — a real grid, not text soup.
Paste into Excel, Google Sheets or Numbers (it's already on your clipboard as TSV), or export as .xlsx / CSV.

ShotMagic does this with one property the other methods can't offer: recognition runs 100% on your device — the screenshot never leaves your browser, which is the whole point when the table is an internal system you're not allowed to upload anywhere. Table capture is free with 3 table exports per day; unlimited exports are part of the one-time $9.99 Pro purchase.

Which one should you use?

Already in Excel, table is in a photo or file: Data from Picture (1).
Public, non-sensitive table, no tools installed: an online converter (2).
Tiny table: just retype it (3).
Table is on your screen, especially from an internal system: a table-mode screenshot extension (4) — nothing gets uploaded.

Questions or corrections

Found a case where one of these fails, or a method that works better? Email [email protected] and we'll update this page — it's only useful if it stays accurate.