Microsoft Excel · Advanced modeling and platform-dependent features · Intermediate
Import a table from a picture and check recognition errors
Import a self-made table image, review OCR results, and reconcile identifiers and numeric totals before trusting the cells.
Official documentation reviewed; synthetic fixtures checked independently; not executed in Excel · Editorial standards
Quick answer: Choose Data > From Picture > Picture From File, review the recognized cells, correct discrepancies, and only then insert the data. After insertion, compare every identifier and amount with the image; an unflagged cell can still be wrong.
Requirements and a complete source image
Use English Excel for Microsoft 365 desktop on Windows 11, or Windows 10 version 1903 or later, with Microsoft Edge WebView2 Runtime installed. Microsoft’s documentation lists these Windows prerequisites. Mac, web, and mobile entry points differ and are not the instructions below. If the feature is absent, check your supported installation rather than assuming an Excel 2013 or perpetual-license equivalent exists.
Create your own simple table in a document or worksheet and capture a tight, head-on image of only this content:
| Code | Units | Amount |
|---|---|---|
| O01 | 10 | 12.50 |
| I02 | 1 | 7.50 |
| Z03 | 20 | 30.00 |
The first code begins with uppercase letter O, the second with uppercase letter I. Neither is a number. Save the image as ocr-practice.png. It is a practice input image, not evidence that OCR has already been executed. Use no receipts, identity documents, or confidential material. Keep the original text/table as the ground truth for checking recognition.
The expected Units total is 31, Amount total is 50.00, and there are exactly three data records. These checks are useful but insufficient alone: swapping two codes could leave both totals unchanged.
Recognize and review
- Open a blank worksheet and select A1, with enough empty space for three columns and four rows.
- Choose Data > From Picture > Picture From File and select ocr-practice.png. If your source is on the clipboard instead, the Windows alternative is Picture From Clipboard.
- Wait for Excel to analyze the picture and display its recognition results.
- Review the complete preview. Correct any indicated uncertainty and compare other cells as well, including the header row, decimal separators, and each code.
- Choose Insert Data only after the recognized grid matches your source.
The image should contain only the table and should not be skewed or out of focus. A cropped, readable source is preferable to trying to infer a missing decimal point afterward. The supported character sets are limited; this English example stays within Microsoft’s documented set.
Audit the inserted cells
Verify A1:C4 contains the headers and exactly the three records above. Inspect Code as text. Distinguish O01 from 001 and I02 from 102, even when the font makes them look similar.
In E1 type Units check and in E2 enter =SUM(B2:B4); expect 31. In F1 type Amount check and in F2 enter =SUM(C2:C4); expect 50. In G2 enter =COUNT(C2:C4); expect 3 numeric amounts. A formatted value of 12.50 is not proof that it is numeric. See COUNT for the numeric check.
Change the source and repeat separately
Change the source table’s I02 Units value from 1 to 2, create a new image, and import it on a new blank sheet rather than overwriting your first result. The new Units total is 32; Amount remains 50 and all three codes remain unchanged. This checks both changed-input recognition and preservation of unaffected values.
Save the workbook as XLSX and keep the source image for audit. Reopen and compare the stored result once more. Picture import is a conversion, not a live link: editing the image does not refresh previously inserted cells automatically. If totals disagree, inspect individual cells and types instead of adjusting the total formula to conceal an OCR error.