To convert an Excel image to Excel, run the screenshot through a picture-to-table reader such as Excel's own Data from Picture. It reads the visible values into rows and columns. What returns is only what the picture showed: displayed numbers and text, never the formulas, formats or hidden columns that sat behind them.
Can an Excel screenshot become cells again?
Yes. A screenshot of a spreadsheet is one of the easiest images to read back, because the grid is perfectly straight and the type is crisp screen font. A table reader finds the cell borders, recognizes the characters in each box and places them in matching cells of a new sheet.
The quickest tool is usually already installed. Microsoft describes how Excel can insert data from a picture, from a screen capture on the clipboard or an image file on Windows and Mac, from an image file on the web, and from the camera in the mobile apps. You review what it read, correct any flagged cells, then insert the data.
The same help page gives two tips that matter here. The image should show only the data you want, so crop away the ribbon and the taskbar. The picture should also be head-on, not taken at an angle. A true screenshot is head-on by nature. A phone photo of a monitor is not, and it adds glare and moiré stripes on top of the tilt.
If the picture came out of a PDF rather than straight from a screen, test the file first. Telling an image PDF from a text PDF takes ten seconds, and a PDF that already holds text skips this whole process.
Gridlines, row numbers and zoom in an Excel image
Gridlines help the reader; row numbers and column letters mostly get in the way. The faint lines between cells tell the recognizer exactly where one column ends, so a sheet captured with gridlines on splits more cleanly. The A, B, C header strip and the 1, 2, 3 margin come back as an extra row and column of junk.
Small habits before the capture make the output better:
- Zoom to 100 percent or higher. A sheet shrunk to 70 percent to fit the screen has tiny type, and tiny type is where 8 and 6 start to blur.
- Widen narrow columns. A column showing
####because the number does not fit gives the reader nothing to read. Excel shows hash marks when a value is too wide, and the picture freezes them. - Crop to the table. Leave the formula bar, sheet tabs and toolbar out of the frame.
- Keep one table per image. Two tables side by side with a gap between them can be read as one wide table.
If you are the one taking the screenshot, you may not need a picture at all. Copying the range and pasting it into an email gives the recipient real cells.
Why do formulas never return from an Excel image?
Formulas never return because a screenshot records pixels, and a formula is never drawn on the screen. The picture holds the result of =SUM(B2:B6), which is a number like 1,284.50. Nothing in the pixels says that the number was calculated, or from which cells.
The same is true of everything Excel keeps out of sight:
- Number formats. A cell showing 12% might hold 0.12 or 0.1249. The image only knows the rounded display.
- Hidden rows and columns. If the sender hid column D, column D is gone.
- Comments, validation lists and links. None of them appear in the picture.
- Full precision. A cell set to show two decimals may store many more.
So treat the result as a fresh table of typed values. Any calculation has to be written again by hand. Where a scan or image leaves letters inside numbers, such as an O standing in for a zero, finding and fixing OCR letters inside numbers walks through the cleanup.
Rebuilding totals after an Excel image conversion
Rebuilding totals is also the best accuracy test you have. Write a new SUM over the converted values and compare it with the total the screenshot showed. If they agree, the column almost certainly came across clean. If they differ, the gap points straight at the misread cell.
A worked example
The screenshot below is an example: a small expense list with a total row. The figures are made up.
| Row | Item | Amount in the image | Amount read back |
|---|---|---|---|
| 2 | Printer paper | 42.10 | 42.10 |
| 3 | Courier | 18.75 | 18.75 |
| 4 | Software licence | 129.00 | 129.00 |
| 5 | Train fares | 66.40 | 86.40 |
| 6 | Client lunch | 51.25 | 51.25 |
| 7 | Total (printed) | 307.50 | 307.50 |
A new formula, =SUM(D2:D6), gives 327.50. The printed total says 307.50. The difference is exactly 20.00, and a 6 read as an 8 in the tens place changes a value by 20. Looking at row 5 confirms it: the reader turned 66.40 into 86.40.
The steps, in order:
- Delete the total row that came in from the picture, or move it aside as a check value.
- Write a fresh SUM over the converted rows.
- Compare it with the printed total.
- If they differ, check the digits most often confused: 6 and 8, 1 and 7, 3 and 8.
- Once the totals match, convert any text that looks like a number into a real number.
When to ask for the workbook instead of the Excel image
Asking for the workbook beats converting its picture whenever the sender still has the file. One reply email saves you the recognition step, the review and the rebuilt formulas. It also brings back the hidden columns and full precision that no picture can carry.
Converting the image still makes sense in a few cases. The original is lost, or the sender only has a printout. A report system exports nothing but a picture. Or the table is short enough that a quick read and a SUM check take less time than waiting for an answer.
Sometimes the screenshot exists because the sender could not share the original. A workbook exported to a locked PDF is a common case. If you have the password or permission, converting a password protected PDF to Excel is cleaner than photographing its pages. When the image is a scanned paper table rather than a screen capture, ruled lines and print quality change the job, and converting a scanned table to Excel with its columns intact covers that case.
For bank statements, the PDF is always the better source than a picture of one. FastBankConvert is built to turn statement PDFs into Excel or CSV and to tell you when the balances do not add up. It is getting ready to open, and you can join through Get started.