Converting a table photo is the first step; checking the extracted values is the part that makes it useful. A spreadsheet can calculate perfectly from a number the image tool read incorrectly.
Keep the original photo beside the sheet until the check is complete. Use a non-sensitive example while learning, and review the privacy terms before sending personal or confidential documents to an unfamiliar conversion service.
1. Take a photo that is easy to read
Place the page flat, light it evenly and hold the camera as square to the table as possible. Include the column headers, all intended rows and any relevant units or footnotes.
Crop away unrelated material without clipping the last column or row. Zoom into the image before importing. If decimal points or minus signs are unclear in the photo, retake it rather than asking the converter to guess.
For an existing digital table, try obtaining the original spreadsheet or structured export first. A photograph is useful when the table exists only as an image, but it adds an avoidable recognition step when editable data is already available.
2. Use a supported import tool
Microsoft documents Data from Picture in supported Excel versions. On desktop, look under Data for the picture-import command; on mobile, the documented route is Insert → Data from Picture. Exact labels and availability depend on your platform and version.
Select or capture the image, crop to the intended table, and review the recognized results before inserting. Microsoft lists supported character sets, so do not assume every language or handwritten table will work.
If the command is absent, check the current support page for your Excel setup. For a short table, careful manual entry can be more useful than repeatedly trying unsupported tools. Do not assume a different spreadsheet app has the same image-import command.
3. Check structure before doing calculations
Compare the first and last row with the source, then count the data rows. Check that a long description has not pushed a quantity into the wrong column or created an extra row.
- Headers and units: quantity, price and amount must stay distinct.
- Codes: preserve identifiers such as 0012 as text when leading zeros matter.
- Decimals and signs: inspect punctuation, parentheses and minus signs individually.
- Dates: keep ambiguous text such as 03/04 unresolved until you know the source format.
- Totals and notes: do not accidentally treat a subtotal or footnote as another transaction.
Apply display formats after understanding the source. Adding a currency format does not correct a wrong value, and changing a column to text after import may not restore leading zeros that have already been lost.
A worked two-row verification
This is an invented source table for checking arithmetic, not the result of a real OCR test:
| Code | Item | Qty | Unit price | Amount |
|---|---|---|---|---|
| 0012 | Clips | 2 | 1.50 | 3.00 |
| 0013 | Folders | 3 | 2.00 | 6.00 |
If columns A–E hold code, item, quantity, unit price and amount, use =C2*D2 in a separate check cell for the first row. It should produce 3.00. Check the second row similarly, then use =SUM(E2:E3) for the source amounts: the total is 9.00.
A hypothetical misread of 1.50 as 150 would produce 300 for the first row. Comparing that with the source amount of 3.00 exposes a problem. Do not simply replace the amount with the formula and assume the source was wrong.
4. Reconcile, then save both the sheet and its source
Check every value if the table is small or the numbers matter. For a larger table, a sample check alone does not establish that all rows are correct. Use row counts, category totals and source totals to investigate gaps, then verify unresolved rows individually.
Keep a short check record: Source filename / page or table / rows imported / fields checked / differences fixed / remaining uncertainties. Save the photo alongside the working file with a clear name.
Do not call the sheet verified while any important number is still a guess. Once it is checked, you can use it for tasks such as comparing offers on a consistent basis.
Official references
Checked October 31, 2026: Microsoft: insert data from picture; Excel SUM. All example values and hypothetical recognition errors above are illustrative.
Images are AI-generated illustrations, not screenshots, measured product tests or photographs of an actual installation or data-extraction result.