A photograph of a table is easy to save but awkward to calculate with: its numbers are still pixels. To bring a scanned table into Excel as editable data, capture a clear image and use a table-recognition tool. Then compare the resulting cells with the paper before trusting the numbers.
Scan Into Excel With Data From Picture
Excel for Microsoft 365 offers Data from Picture for converting a table image into cells. On a supported Windows computer, transfer your photo or scan to the computer, open a workbook, and select the cell where the table should start. Then follow these steps:
- Choose Data > From Picture > Picture From File and open the image.
- Wait while Excel analyzes the table.
- Review the preview and correct any entries the program flags as uncertain.
- Select Insert Data to place the recognized values in the worksheet.
You can also use a screenshot on the clipboard through Data > From Picture > Picture From Clipboard. The scan to Excel process creates editable cells; simply inserting the picture through the Pictures menu leaves you with an image instead. Keep the original image available for comparison.
On a phone or tablet with the supported Excel app, choose Insert > Data from Picture, capture the table, adjust the crop, and review the recognized values before inserting them. Menu names and availability depend on your version and platform. Microsoft’s Data from Picture guide lists supported systems and character sets.
Make the Image Easy to Read
Place the paper flat and photograph it straight on in even light. Avoid shadows, glare, folds, and fingers covering the edges. Crop the image to the table you want, while keeping its headers and all rows visible. If the text is too small to read when you zoom in, move closer or scan at a higher resolution and try again.
If you scan to Excel from a long table, capture it in sections with complete rows and column headings. Import each section into the spreadsheet in order, then check the joins between sections. This can be easier than asking the software to read one distant photo of a large page. If a table has complex merged cells or handwritten notes, expect more manual correction.
A clean source makes it easier to scan into Excel, but recognition still needs a human check. For sensitive records, review the service’s data-handling terms and your organization’s rules before using a recognition feature or uploading an image to an outside converter.
Correct the Data, Not Just the Highlights
Compare the imported worksheet against the paper row by row. Excel may flag uncertain entries, but an unflagged value can also be wrong. Watch for zeros read as the letter O, ones mistaken for lowercase l, missing decimal points, and minus signs that disappear. Check dates and identifiers too: an account number with a leading zero should retain that zero.
Make sure every value sits under the correct heading. A shifted column can turn an accurate number into the wrong answer. Count the rows, compare the first and last entry, and inspect section boundaries if you imported multiple images. If the source contains a printed total, use a spreadsheet formula to compare it with the sum of the imported values; a match is helpful but does not replace checking individual entries.
If the recognition tool is unavailable, use a compatible table OCR service or enter a small table manually. Check its export format and review its privacy terms before uploading. Either way, verify the cells against the source.
Check Before Saving
Before you save the workbook, confirm the headings, row count, numbers, dates, and column alignment against the original. Recheck any corrected cells and a few totals, then save an .xlsx copy with a clear name. Retain the source image so you can resolve questions later.