Excel Data from Picture: Turn a Screenshot Into a Checked Table

This workflow uses Excel for Microsoft 365 on Windows 11. Check that From Picture appears on your Data tab before starting. Microsoft documents separate instructions for web, Mac and mobile versions.

Check the language of the source image before importing it. Microsoft’s listed character sets include English and Spanish, but not Hindi or Arabic. The language of this guide does not change which characters the feature supports.

Prepare one clear table

Use a public sample or an image you’re authorised to process. Keep the original unchanged. Crop a working copy around the table, preserving every heading and row. Microsoft recommends a focused, head-on image. If a screenshot cuts off values, request the complete source rather than guessing.

For a first test, choose around ten rows with a mix of text and quantities. Note the expected row count separately.

Import into a blank worksheet

Choose Data > From Picture > Picture From File. Select your image and wait for the analysis. If the table is already on your clipboard, use Picture From Clipboard instead.

Review the conversion and correct errors before choosing Insert Data. Use a new worksheet so you can check the result without disturbing an existing tracker. Microsoft’s feature guide

Compare every row with the image

Keep the source visible beside the worksheet. Check headings, row alignment, missing entries and duplicate rows. Pay particular attention to decimal points, minus signs, units and similar-looking characters.

For a short table, inspect every cell. Don’t assume an unflagged value is correct. If a figure is unreadable in the original, mark it for clarification. An apparently tidy spreadsheet can still contain an incorrect quantity.

Protect product codes and dates

Separate identifiers from values you calculate with. A product code such as 00127 should retain its leading zeros. Excel can remove those zeros when it treats a code as a number.

Check each identifier against the image. If digits were lost, format the destination cells as Text and re-enter the verified codes. Changing the format after conversion does not recover missing information. Microsoft’s leading-zero guidance

For dates such as 04/05/2026, confirm whether the source uses day/month or month/day. Keep ambiguous entries unresolved until you can verify their meaning.

Reconcile quantities before using the table

If quantities were imported as text, use Excel’s Convert to Number option where its error indicator offers it. Apply this only to genuine numeric columns, leaving identifiers alone. Microsoft’s conversion instructions

Calculate a quantity total and compare it with the source total, if provided. Also confirm the row count and check item-and-quantity pairs. A matching total alone cannot prove that quantities were assigned to the correct products.

Keep the original image and a short correction log with your working files. Copy the checked rows into the final tracker only when outstanding questions are resolved.

Limits worth knowing

The Windows feature also requires Microsoft Edge WebView2 Runtime. Check the official requirements if the command is missing. Product support for an older Windows release should not be read as a recommendation to use an unsupported operating system. Microsoft’s feature guide

For a large or repeatedly updated table, ask for the original spreadsheet or CSV. Image conversion is most useful when the image is the only practical source and the output is small enough to verify carefully.

Official sources

• Microsoft’s feature guide
• Microsoft’s leading-zero guidance
• Microsoft’s conversion instructions

Research note: documentation for Excel Data from Picture checked table was checked on 29 October 2026. Data from Picture does not list Hindi or Arabic character support; successful conversion does not prove that rows, codes or quantities are correct. No hands-on product test was performed. The cover is an AI-generated illustration, not a software screenshot.