To extract a table from a picture in Excel for Microsoft 365 on Windows, select Data > From Picture > Picture From File, choose the image, review Excel’s recognized data, correct any highlighted errors, and select Insert Data. You can also use Picture From Clipboard for an image you have copied. The feature converts a clear image of a table into editable worksheet cells; it does not reliably turn every kind of picture into structured data.
Before starting, make sure the image shows the complete table and that its text is readable. Excel uses optical character recognition (OCR), so you should treat the imported values as a draft and check them against the original picture—especially amounts, dates, identifiers, and figures that could be confused with letters.
What You’ll Need
- Excel for Microsoft 365 on Windows. The From Picture feature is available in supported, up-to-date Microsoft 365 versions. If your Excel edition or update channel does not include it, see Troubleshooting below.
- A picture of a table. Use a photo, scan, screenshot, or an image copied to the clipboard. A common image file, such as a PNG or JPG, is suitable.
- A clear, complete image. Text should be in focus, well lit, and large enough to read. Straight rows and columns help Excel identify the table.
- A blank worksheet area. The imported cells are placed in the workbook, so choose a destination without existing data that could be overwritten or confused with the result.
Step-by-Step
- Inspect and prepare the picture. Open the image or make sure you can locate it in File Explorer. Check that the table is not cut off at the edges and that headers, row labels, and values are visible. If it is a phone photo, crop away unrelated objects and rotate it so the table reads normally. Avoid editing away borders or symbols that help distinguish columns. A screenshot or scan is often easier for Excel to read than a photo taken at an angle.
- Open the destination workbook. Start Excel and open the workbook where you want the extracted information. Create a new worksheet if you want to keep the imported table separate from existing work. Click a blank cell near the top-left of the intended destination area. Leave enough empty space to the right and below for the full table; Excel needs room to place the recognized rows and columns.
- Choose the picture import command. On the ribbon, select Data > From Picture > Picture From File. In the file picker, find and select your image, then choose Insert or the equivalent open command shown in the dialog. To use an image already copied, select Data > From Picture > Picture From Clipboard instead. If the clipboard option is unavailable, copy the image itself—not just a file name or a link—then try again.
- Wait for Excel to analyze the image. Excel displays a pane with its interpretation of the table. Depending on the image and version, the pane may show recognized rows and columns alongside the source picture. Give the analysis time to finish. Do not assume the first preview is exact: OCR can mistake similar-looking characters, miss faint lines, or put a value in the wrong column.
- Review every flagged recognition issue. Excel may highlight cells that need attention. Select a highlighted item and compare it with the original image. Correct the text or number in the review pane where possible, then confirm the correction. Pay close attention to decimal points, minus signs, commas, currency symbols, and characters such as 0 and O or 1 and I. A plausible-looking result can still be wrong, so check unflagged cells in important columns too.
- Insert the recognized data. When the preview is acceptable, select Insert Data in the pane and confirm if Excel asks whether to proceed. The table is added to the worksheet as cell contents, not merely as a picture. If Excel inserts it somewhere other than your intended starting cell, select the resulting range and move or cut and paste it to the desired location. Check that the last row and column made it into the sheet.
- Check the imported values and layout. Compare the worksheet with the source image, working from the first row to the last. Confirm headings, row order, column placement, and totals. Look for numbers stored as text, dates interpreted in the wrong order, and leading zeros missing from codes or postal identifiers. If the table contains a total, recalculate or compare it with the pictured total as an extra check; do not rely on an image import to verify arithmetic.
- Apply any needed cleanup. Use normal Excel editing tools to adjust column widths, wrap long headings, set number or date formats, and remove blank rows or columns. If an identifier must retain leading zeros, format the relevant cells as Text before re-entering or correcting those values. Keep the original image until you have verified the worksheet. Save the workbook after checking the result.
Common Mistakes
Importing a blurry or angled photo: OCR works from the visible pixels. If characters are fuzzy or rows slope across the image, the tool may misread values or split the table incorrectly. Improve the image first rather than trying to fix dozens of errors after import.
Assuming the preview is proof of accuracy: Excel can recognize a cell without flagging it, even when a digit is wrong. This is particularly risky with prices, account numbers, dates, and small differences such as a decimal point. Compare the result with the picture before using it for calculations or sharing it.
Expecting a photograph of any content to become a spreadsheet: From Picture is intended to recognize tabular data. A chart, handwritten note, paragraph, or decorative graphic may not become useful rows and columns. For a chart, you may need to read and enter the values separately; for ordinary printed text, use a text OCR tool and review its output.
Overlooking data types and identifiers: Excel may interpret a recognizable string as a date or number. It can also discard leading zeros when a value is treated as numeric. Check codes and date formats before sorting, matching, or calculating with imported information.
Placing the result over existing cells: Choose a clear destination before inserting. If the target area contains content, pause and use a new worksheet or an empty range instead of risking an accidental overwrite or a confusing mix of old and new data.
Tips
Make the source as easy to read as possible. Photograph the table straight on, use even lighting, avoid glare and shadows, and fill most of the frame with the table. For printed material, a clean scan or direct screenshot often gives OCR more consistent edges and letter shapes than a handheld photo.
Include the full header row and any labels that explain the values. A cropped table may still import, but without headings you may not know what each column represents. Keep units such as “kg” or “%” visible if they are part of the table’s meaning, and do not crop off notes that change how values should be interpreted.
Review the most consequential fields first. For a sales table, check amounts, dates, and product identifiers. For a list of people, check names and any ID numbers character by character. If the image contains many rows, verify a sample near the top, middle, and bottom, then give particular attention to any cells Excel highlights.
For repeated work, preserve the source image with the workbook or in a clearly named folder. That makes later checks easier and helps another person understand where the imported values came from. If the image contains sensitive information, follow your organization’s rules for storing or uploading it; image recognition may involve connected Microsoft services depending on your Excel setup.
On Excel for Mac, the feature is also available in supported Microsoft 365 versions, though the ribbon layout and dialog labels can differ; look on the Data tab for From Picture. Excel for the web and older or differently licensed desktop editions may not show the same commands. If the feature is missing, check your version and updates or use a supported Excel app rather than assuming the image itself is the problem.
Troubleshooting
“From Picture” is missing: Confirm that you are using a supported Microsoft 365 version of Excel and that Office is updated. In Windows, check File > Account for product and update information; available update options depend on your organization. Work or school administrators may control feature updates. If you are using an older perpetual edition or a browser version without the command, try a supported Microsoft 365 desktop or mobile app.
The picture will not load: Try opening the image in a photo viewer and saving a fresh copy in a common image format such as PNG or JPG. Check that the file is not damaged, password-protected, or stored somewhere Excel cannot access. For clipboard import, recopy the image and select the picture-import command immediately; copying text or a web address will not provide an image for recognition.
Excel recognizes only part of the table: The source may be cropped, too small, or visually cluttered. Make a closer, sharper image that includes the full table, or split a very large table into smaller sections with repeated headings. Import each section separately and check that no rows are missing or duplicated when you combine them.
Values appear in the wrong columns or rows: Strong perspective, missing gridlines, merged cells, and tight spacing can make the table structure ambiguous. Straighten or crop the picture, increase its clarity, and try again. If only a few cells are misplaced, correct them in the review pane or worksheet, then compare the surrounding row and column labels with the original.
Numbers or dates look wrong after insertion: Determine whether the recognition is wrong or Excel has simply applied an unexpected format. Compare the cell’s displayed value with the picture and inspect the cell contents. Re-enter incorrect characters; for a correct value shown in an unsuitable format, change the number format. For leading-zero identifiers, use Text formatting and restore the zeros if they were dropped.
The review pane seems stuck: Allow a short time for processing, then close and reopen the import if it does not respond. Save the workbook first if it contains other work. Try a smaller or clearer image, and check that Excel is online if your organization’s setup requires connected services for the feature. If it continues, restart Excel and check for an Office update.
Frequently Asked Questions
Can Excel extract data from a screenshot?
Yes. Use Data > From Picture > Picture From File to select a saved screenshot, or copy the screenshot and choose Picture From Clipboard. A sharp screenshot of a simple table is usually easier to read than a low-quality photo.
Can I extract data from a picture on Excel for Mac?
Supported Microsoft 365 versions for Mac include From Picture, although the exact ribbon arrangement can vary. Check the Data tab for the command. If it is absent, confirm that Excel is updated and that your edition supports the feature.
Does this turn the picture into a live link to its source?
No. Excel reads the image and inserts recognized cell values. The worksheet does not automatically update if the original image changes, so you need to run the import again or edit the cells yourself.
Can Excel read handwriting or a chart?
It is designed for tables, especially clearly printed rows and columns. Handwriting, charts, and free-form layouts are less dependable. You may need another OCR or chart-reading method, followed by manual checks and corrections.
Why did Excel change a code such as 00427?
Excel may treat it as a number and remove leading zeros. Compare it with the source. If the code is an identifier rather than a quantity, set the destination cells to Text and restore any missing zeros.
Can I use the extracted data in formulas?
Yes. After insertion, the recognized values are worksheet cells, so you can sort, filter, format, and reference them in formulas. First check that numbers and dates are stored in the intended form; values imported as text may not behave like numeric data.
Related
- How to Duplicate a Text Box in Excel Without Rebuilding It
- How to Duplicate Microsoft Excel Files, Sheets, and Cells
- How to Duplicate an Excel Sheet in Excel for Windows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting in Excel: Color Coding GuideYes—conditional formatting in Excel automatically color-codes cells when their values meet rules you set. Select the cells, then…
- Excel Insert Shortcut: Add Cells, Rows, and ColumnsIn Excel for Microsoft 365 on Windows, select the cells, row, or column where you want space, then…
- Microsoft Excel Solver: How It Works and When to Use ItMicrosoft Excel Solver is an optimization add-in that finds values for selected cells to maximize or minimize a…
- How to Insert a Line in Word to Type On: Easy MethodsTo make a line you can type on in Word, insert a one-cell table, remove its borders, and…
- Google Sheets vs Excel: Which Spreadsheet Fits You?Google Sheets is usually the better choice for simple spreadsheets that people need to edit together online, while…
- Conditional Formatting Definition and Practical ExamplesConditional formatting is a spreadsheet feature that automatically changes a cell’s appearance when its value meets a condition.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.