Skip to main content
GridFiller
Sign inGet started

How to convert a screenshot to Excel

Published

You have a screenshot of a table and you need it in Excel as real cells. Here are the options, when each one is worth using, and how to avoid the mistakes that cost more time than they save.

First, why pasting doesn't work

Dropping a screenshot into a worksheet inserts a picture object. It sits above the grid, it is not attached to any cell, and no formula can reference it. Sorting the sheet moves nothing inside it. For anything beyond looking at the numbers, it is a dead end.

So the real task is not getting the image into Excel — it is getting the values out of the image and into cells.

Option 1: retype it

For a five-row table this is genuinely the fastest route. For anything larger the arithmetic turns against you quickly: a hundred rows of five columns is five hundred chances to make a transcription error, and errors in the middle of a numeric column are very hard to spot afterwards.

If you do retype, work in pairs — one person reads, one types — or read the totals back against the source when you are done.

Option 2: Excel's built-in picture import

Some Excel editions offer data-from-picture features. When they are available they work reasonably on simple, clean tables, but availability depends on your platform and edition, they handle one image at a time, and they tend to struggle with dark themes and tables without ruled borders.

It is worth trying if you already have it. It is not something to plan a recurring workflow around.

Option 3: AI extraction with GridFiller

  1. 1. Capture the table properly

    Take the screenshot at full zoom, include the header row, and crop out sidebars and toolbars.

  2. 2. Upload it

    Drag the PNG, JPG, WEBP, or PDF into GridFiller. Files up to 20MB, and up to 20 per job.

  3. 3. Choose how sources combine

    For one file, nothing to do. For several, append rows for continuations of one table, align by headers for tables that share columns, keep separate for unrelated tables.

  4. 4. Review the grid

    The extraction opens in an editor. Scan the numeric columns, correct anything misread, and rename headers.

  5. 5. Export .xlsx

    Download and open in Excel. Formulas, filters, and pivot tables work immediately.

What to check before you trust the numbers

  • Row count against the original capture — a partially scrolled last row is the usual casualty.
  • Decimal separators, especially in files that mix European and US formatting.
  • Columns with narrow characters, where 1, 7 and l can be confused at low resolution.
  • Repeated header rows from paginated tables, which are usually best deleted.
  • Merged cells, which have to be assigned to one column or the other.

When the result is wrong

Almost every bad extraction traces back to the source image. Re-capture at a higher zoom level, save as PNG rather than JPG, and crop tightly around the table. A screenshot resized by a chat app is a common culprit — find the original.

If the layout was read correctly but combined the wrong way, re-run the same files with a different merge strategy instead of uploading them again.

Try it on your own file

Upload a screenshot, image, or PDF and GridFiller returns an editable table you can export to CSV or XLSX.

Open GridFiller

Related reading