Insert Data From Image in Excel: A Step-by-Step Guide

To insert data from an image in Excel for Microsoft 365 on Windows, open the worksheet, choose Data > From Picture, select a photo or screenshot, review the recognized table, correct any errors, and select Insert Data. Excel converts the table in the image into editable cells; it does not simply place the picture on the sheet. A clear, straight-on image of printed rows and columns gives the best starting point.

What You’ll Need

Excel for Microsoft 365 on Windows. The Data from Picture feature may not appear in older Excel versions or some managed work accounts. If you cannot find it, check for Office updates or use a supported Excel version.
A table image. You can use an image file or a screenshot copied to the clipboard. A sharp, well-lit image with visible cell boundaries and readable text is easier to recognize.
An open workbook and a destination worksheet. Choose where you want the converted cells to go and make sure there is enough blank space for the table.

Step-by-Step

Prepare the worksheet. Open the workbook and select the worksheet where the data should appear. Click the cell that will be the table’s upper-left corner, or leave the sheet ready to choose a location after reviewing the conversion. Keep a few empty columns and rows around the destination so the new data will not overwrite existing content. If the workbook contains important information, save it before starting.
Choose a clean image of the table. Use a scan, screenshot, or photograph that shows the complete table, including column headings and any final rows. Crop away unrelated page content, but do not cut off labels or values. If you are taking a photo, hold the camera parallel to the page, use even light, and avoid shadows, glare, fingers, or strong perspective. The text should be large enough to read when you view the image at normal size.
Start Data from Picture. In the Excel ribbon, open the Data tab and select From Picture. Choose Picture From File to browse for a saved image. To use an image already copied to the clipboard, choose Picture From Clipboard if that option is available. If you do not see From Picture, confirm that you are using a supported Microsoft 365 version and that the ribbon is not simplified or customized to hide the command.
Load the picture. For a file, locate and select the image, then choose the command to open or insert it. Excel analyzes the table and displays a data review pane. For a clipboard image, first copy the screenshot or picture, then choose the clipboard option. Wait for recognition to finish before editing; large or detailed images may take longer. If the selected picture includes several separate tables, crop or prepare a separate image for each table for a more predictable result.
Review the recognized cells. Excel shows the extracted table and may flag cells that need attention. Select each flagged item and compare it with the original image. Check easily confused characters such as 0 and O, 1 and l, decimal points and commas, minus signs, and dates. Do not assume an unflagged cell is correct: OCR can make a plausible but incorrect substitution without marking it. Scan the headings, first and last rows, and any unusually large or small values closely.
Correct mistakes before inserting. Use the review pane’s available controls to edit a cell or accept the recognition as shown. Refer to the original image rather than guessing from nearby values. Check that words have not been split between columns and that each number or date is in the intended column. If several adjacent cells are wrong, it may be faster to improve the source image and run recognition again than to repair many entries individually.
Insert the table into the sheet. When the preview looks right, select Insert Data in the review pane and confirm if Excel asks whether to proceed. The recognized values are placed into worksheet cells, where you can edit, sort, filter, and format them like other data. If you did not choose a destination beforehand, click the cell where the table should begin and insert or move the results as needed. Check that the inserted range has not replaced existing content.
Verify the result in Excel. Compare the inserted table with the image, row by row for critical data. Check the total number of columns and rows, headings, signs, decimal places, and values at the edges of the table. Excel may interpret a value as text or apply a date or number format that differs from the source. Correct those cells and set an appropriate number format from the Home tab. Save the workbook after verification.
Use the alternate path on other devices when needed. On Excel for Mac, the feature and menu wording can differ by release; look on the Data tab for Data From Picture or a similarly named picture command. On Excel for the web, availability can depend on the account and current interface. If the command is missing, try the updated desktop Microsoft 365 app rather than assuming that inserting a picture with Insert > Pictures will convert it. Inserting a normal picture only places an image on the sheet.

Common Mistakes

Choosing Insert Picture instead of From Picture: Insert > Pictures adds a visual image to the worksheet, but its contents remain pixels rather than cell values. Use Data > From Picture to recognize a table and create editable cells.

Accepting the preview without checking it: OCR is not guaranteed to read every character correctly. A value such as 8,000 might become 8.000, a minus sign can disappear, or a date can be misread. Check every field that matters, especially amounts, identifiers, and totals.

Using a low-quality or incomplete source: A blurry, angled, overexposed, or tightly cropped image makes recognition harder. Make sure the full table is visible, including headings and the ends of long entries. A crisp screenshot is often preferable to a photo of a screen.

Ignoring the destination range: Inserting into a populated area can overwrite or disrupt existing worksheet data. Select a blank location, or use a new worksheet, and confirm the table’s footprint before inserting. Also check for hidden columns or rows that could make the result seem incomplete.

Assuming the image’s appearance becomes formatting: Data from Picture is meant to extract table content. It may not reproduce colors, borders, merged headings, or layout exactly as shown. Apply Excel formatting separately after the values have been inserted.

Tips

Crop the source to one table and leave a small margin around its outside edge. Extra paragraphs, page numbers, and nearby tables can confuse the detected layout.
Use a direct screenshot of a digital table whenever possible. For paper, scan at a readable resolution or take a steady, straight-on photograph in bright, even light.
Keep the review pane open and compare suspicious cells with the image before selecting Insert Data. Correcting errors at this stage is easier than tracking them down later.
For long tables, verify the first few and last few rows as well as any row with unusual characters. OCR errors can be scattered, so a quick glance at only the headings is not enough.
After insertion, use Excel’s ordinary tools to format the range, freeze headings, or turn it into a filterable table. These steps organize the extracted values; they do not change what the original image contained.
If the source has multiple tables, process each separately and label the resulting ranges. This reduces the chance that Excel combines adjacent sections or interprets a note as a data row.

Troubleshooting

From Picture is missing: Confirm that Excel is signed in to the Microsoft 365 account that has the feature, install available Office updates, and check the full Data tab. An older perpetual-license edition, a restricted work installation, or a different Excel platform may not offer the same command. As a practical alternative, try the current Microsoft 365 desktop app or use a supported device. Do not use Insert > Pictures as a substitute if you need editable cells.

Excel recognizes only part of the table: Make sure the image includes every row and column, and recapture or crop it so the table is not cut off. Remove surrounding text and avoid a crop that trims the outside border or the first character in a cell. For a very long table, split the source into smaller sections and convert them one at a time.

The extracted columns or rows are jumbled: Check for skewed text, faint gridlines, narrow spacing, merged cells, and overlapping notes. Try a straighter, sharper image with the table isolated. If the table has a complex layout, simplify the source when possible or correct the preview carefully; a layout designed for printing may not map neatly to a rectangular cell range.

Some characters or numbers are wrong: Compare the flagged cells with the original and edit the preview if the controls allow it. If many errors share a cause, such as blur or glare, create a better image and run Data from Picture again. After insertion, inspect number formats: a string of digits may be interpreted as a number, while dates and decimal separators can be affected by regional settings. Preserve codes with leading zeros as text if those zeros are part of the value.

Nothing appears after selecting Insert Data: Check whether Excel is still processing or whether the table was inserted farther down or across the sheet than expected. Look at the selected cell and the surrounding range, and check for hidden rows or columns. If the results landed in the wrong place, undo the insertion if it is the most recent action, choose a clear destination, and insert again. Save a copy before making extensive corrections.

Frequently Asked Questions

Can Excel turn a photo of a printed table into cells?
Yes. Use Data > From Picture and review the recognized values before inserting them. The feature works best with clear, printed text and a simple table. It may need extra correction when the photo is blurry, angled, or contains handwriting.

Does Data from Picture work with screenshots?
Yes. You can use a saved screenshot with Picture From File or, where offered, copy it and choose Picture From Clipboard. A screenshot that closely crops the table and keeps text sharp usually gives the clearest preview.

Can I convert a picture already sitting in a worksheet?
The normal picture-insertion command does not convert its contents. Start Data from Picture from the Data tab and select or copy the image as its source. If the picture is embedded in the sheet, you may need to save or copy it first, depending on the commands available in your Excel version.

Will Excel preserve the table’s colors and borders?
Do not rely on it to reproduce the original design. The feature extracts table data; formatting such as shading, font styles, and decorative borders may need to be applied again in Excel after insertion.

What should I do if my numbers appear as text?
Select the affected cells and use the number-format options on the Home tab, or correct the values as needed. Before converting text to numbers, check that punctuation and leading zeros are meaningful: product codes and account identifiers often need to remain text rather than numeric values.

Can Excel read handwriting in a table?
Recognition is intended for printed text and may not reliably interpret handwriting. If handwritten entries are important, verify and enter them manually rather than trusting the preview. Clear printed labels and numbers around them can still be extracted and checked separately.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.