Extract a table from a screenshot to Excel

Here is how to extract a table from a screenshot to Excel without retyping a single cell: drop the image onto the tables reader, it reads the grid into real rows and columns, and you download a CSV that opens straight in Excel or Sheets. It works on screenshots, dashboards, and photos of a slide or a printed page. The piece below shows how to capture the table cleanly and turn a screenshot to Excel in a couple of steps, free to try.

The Table You Cannot Copy

It always arrives the same way. A table you need, sitting somewhere you cannot get at it. A screenshot a colleague dropped into a chat. A figure in a report that will not let you select a thing. A dashboard that shows you the numbers and offers you no way to take them. A photograph of a slide from a meeting you could not attend.

You can see every cell. You just cannot have any of them. And so you do the thing everyone does, the thing nobody admits to. You put the image up on one side of the screen and the empty spreadsheet on the other, and you start typing it across by hand, glancing back and forth, losing your place, fairly sure you have transposed two figures somewhere around the eighth row.

It is not difficult. It is just a small, daily tax on your attention, and it is the kind of friction that you stop noticing only because it happens so often.

Capture the Table Cleanly

The better way starts with the picture. The clearer the screenshot, the cleaner the result, so it is worth half a thought before you grab it.

Capture the table on its own where you can, rather than the whole screen with the table buried in a corner. A tight, square image of just the grid reads far better than a wide shot where the figures are small. If the table is long and you have to scroll, take it in a couple of overlapping pieces rather than one cramped strip, and keep the text a comfortable size on screen before you capture. A screenshot taken at a sensible zoom holds its detail. One shrunk down to fit everything in does not.

If it is a photograph of a screen or a printed page rather than a clean screenshot, the same care that helps any image helps here. Straight on, good light, no glare bouncing off the glass and swallowing a column of numbers.

Screenshot to Excel: Pixels into Rows and Columns

Then you hand the image to the tables tool, and the part that used to be twenty minutes of squinting becomes a couple of steps. It reads the grid. Not as a picture of a table, but as the actual rows and columns, the headers along the top, the figures in their cells, lifted out and rebuilt as structure you can use.

The whole thing is three steps:

1. Capture a tight, clear screenshot of just the table, taken at a comfortable zoom.
2. Drop it onto the tables tool; it reads the grid into real rows and columns, headers and all.
3. Glance over the figures, check anything flagged, then download the CSV and open it in Excel or Sheets.

You look it over, because you always should with numbers. Then you take it as a spreadsheet, a CSV that drops straight into Excel or Sheets or whatever you keep your figures in, and it is a working table again. Sortable. Sum-able. Ready to become the thing you actually needed it for, instead of a screenshot you were going to retype the moment you found ten free minutes.

Where the image is ambiguous, two columns that run close together, a smudged figure in a photograph, a cell that could be a five or a six, it is flagged rather than guessed at. With numbers, that honesty is the whole point. You would far rather be told check this one than discover a quietly wrong figure three meetings later. You stay the one who signs off the data.

To read the grid, the image is sent to a model that does the reading, and we do not keep your images or use them to train anything. Tables tend to hold the sort of numbers you would rather keep in the room.

!A tidy spreadsheet filling a screen, with city light reflected faintly in the glass

Five Minutes You Get Back

None of this is dramatic. That is rather the appeal. It is not a grand new way of working, it is the quiet removal of a small, repeated annoyance, the sort that adds up without your ever quite logging it.

The table you could see but not touch is now a table you can sort. The screenshot a colleague pasted in becomes a column you can add up. The figures off the slide are in your sheet, in the right cells, and you did not transpose two of them around the eighth row, because you did not type them at all.

You started before the kettle boiled. By the time it has, the table is in your spreadsheet and you are getting on with the actual work, which was never the typing. It was always the thinking the numbers were for.

A Few Questions People Ask

Will the columns line up properly?
That is the job. It reads the table as rows and columns rather than as loose text, so the structure comes across and the figures land in the right cells. You can glance over it and adjust before you export, which with numbers is always worth doing.

Can I open it in Excel?
Yes. You can take the result as a CSV, which opens cleanly in Excel, Google Sheets and anything else that handles spreadsheets, so it slots straight into wherever you already keep your figures.

What about a photo rather than a screenshot?
It reads photographs of tables as well as clean screenshots, a printed report, a slide on a wall, a page on a desk. Straight on and in good light gives the best read, the same as with anything on paper.

Got a table stuck in an image? Tables to CSV, free to try.