Insert Data from an Image in Excel: Step-by-Step

How-to basics · Updated November 20, 2026

To insert data from an image in Excel for Microsoft 365 on Windows, open the worksheet, select Data > From Picture > Picture From File or Picture From Clipboard, choose the image, review Excel’s recognized data, correct any errors, and select Insert Data. Excel converts a clear picture of a table into editable cells, but you should check the imported values before relying on them.

What You’ll Need

  • Excel for Microsoft 365 on Windows, updated to a build that includes Data > From Picture. The command may not appear in every Excel edition or update channel.
  • A photo, scan, or screenshot showing a readable table. A straight, well-lit image with visible row and column boundaries usually gives better recognition.
  • Permission to access the image file or clipboard, and a worksheet with room for the imported table.

If you are using Excel for Mac, look for Data > From Picture; the available picture-source options can differ by version. Excel for the web may not offer the same import command, so use the desktop app or the Excel mobile app if you cannot find it.

Step-by-Step

  1. Prepare the image. Find the original file or take a new photo of the table. Include the complete table, including its headings, but avoid unnecessary background. Make sure the text is sharp enough to read when enlarged. If the picture is angled, rotate or crop it in an image editor first. Avoid cutting off minus signs, decimal points, dates, or the first and last columns; these small details can change the meaning of a value.
  2. Choose the destination worksheet. Open the workbook and select the worksheet where you want the extracted information. Click the upper-left cell where the imported table should begin, such as A1 or D4. Excel inserts the recognized rows and columns starting at your selection, so choose a blank area with enough space. Check that existing information will not be overwritten or obscured by the new table.
  3. Open the picture import command. On the ribbon, select Data > From Picture. Choose Picture From File to browse for a saved image. If you have copied a screenshot or image, choose Picture From Clipboard instead. If the command is missing, check that Excel is updated and that you are using a supported desktop or mobile version. The name or placement of the command can vary slightly between platforms.
  4. Select and load the image. For a file, browse to the image, select it, and choose Open. Excel analyzes the picture and displays a preview with the extracted table. For a clipboard image, confirm that you copied the image itself—not a file name or text—and start the clipboard option. Allow the recognition process to finish before changing windows or trying the import again.
  5. Review the recognized cells. Excel presents the detected table and flags entries that may need attention. Select a flagged item to inspect the image and the proposed value. Compare each questionable entry against the source, paying particular attention to similar-looking characters, such as 0 and O, 1 and I, a decimal point and a speck, or a minus sign and a dash. A warning is a prompt to check the value, not proof that the value is wrong.
  6. Correct errors before importing. Edit any misread cell in the review pane if that option is available, or use the pane’s controls to go back and correct the affected entries. Check that the number of rows and columns matches the picture and that values sit under the right headings. Also look for split or combined cells: a long label may be divided into two columns, or adjacent values may have been joined. Fix what you can while the source image is visible.
  7. Insert the table. When the preview is acceptable, select Insert Data and confirm if Excel asks whether to replace existing content. The cells are added to the worksheet as editable data, rather than as a single picture. If you started in the wrong cell, use Undo immediately or remove the imported range and repeat the process at the correct starting position. Check for nearby content before deleting anything.
  8. Verify and format the result. Compare the imported table with the image from top to bottom. Check headings, row order, empty cells, totals, dates, and values with symbols or punctuation. If a number appears as text or a date is interpreted incorrectly, select the affected cells and use the number-format controls on the Home tab, or correct the entry to match the intended data. Save the workbook after checking it.

For example, if a printed list has columns for item, quantity, and price, check that each price remains in the price column and that a value such as 12.50 has not become 1250 or 12,50. Do not assume a visually tidy import is accurate: Excel can arrange recognized text into neat cells even when one character or column assignment is wrong.

Common Mistakes

  • Using a blurry or angled photo. Small text, glare, shadows, and perspective distortion make characters harder to distinguish. Retake the photo straight-on, move to even lighting, and crop to the table before importing.
  • Skipping the review pane. Importing immediately can carry recognition errors into calculations, sorting, or reports. Inspect flagged entries and compare important values with the source image.
  • Choosing a starting cell without checking the space. The imported table can cover existing worksheet content. Pick an empty area and make sure the full table will fit.
  • Assuming the picture itself becomes a table. The command extracts data from a picture; it does not simply attach the image to the sheet. To keep the original picture as a reference, insert or retain it separately.
  • Ignoring number and date interpretation. Depending on the text and regional settings, Excel may interpret a date, decimal, or leading zero differently than intended. Compare these values with the source and correct their cell contents or formats.

Tips

  • Crop the image close to the table, but keep all headings, values, and useful row or column separators in frame. Cropping away clutter can help recognition; cropping away context can make the table harder to interpret.
  • Use the original, highest-resolution image rather than a thumbnail pasted into a document. If you take a phone photo, hold the camera parallel to the page and avoid flash glare on glossy paper.
  • Import one table at a time when a page contains several unrelated tables. Separate imports make it easier to place each dataset and spot a missing row.
  • Keep the source image open beside Excel during review. For a long table, compare it in sections and follow the same row order, rather than checking only the first few lines.
  • Preserve the original data when accuracy matters. Import to a new worksheet or an unused range first, then compare and replace existing information only after checking the result.
  • Remember that image recognition reads visible characters; it does not know what a value is supposed to mean. A plausible-looking total, code, or date can still be incorrect, so verify important entries against the original.

Troubleshooting

There is no From Picture command. Confirm that you are in the Excel desktop app and check for Office updates. Some perpetual-license editions, older builds, or managed workplace installations may not include the feature. On a Mac, look under Data > From Picture; on the web, switch to a supported desktop or mobile app if the command is unavailable. If your organization controls updates, ask its Microsoft 365 administrator about feature availability.

Excel cannot read the image or the preview is blank. Try a common image format such as PNG or JPEG, reopen the file, and make sure it displays correctly outside Excel. Crop out blank margins and improve contrast or sharpness. If the image is a screenshot, recapture it at a larger size rather than enlarging a small, blurry copy.

Rows or columns are missing or joined together. The source may have faint borders, tightly packed text, or an irregular layout. Crop to one table, ensure its edges and headings are visible, and retry. If recognition still merges entries, correct them in the review pane where possible, or import smaller portions and compare the row order carefully.

Values look wrong after insertion. Compare the cell contents with the picture, not just the display format. A cell may contain text where you expected a number, or Excel may interpret a date according to your regional settings. Correct the underlying entry and, where appropriate, change the cell format using the Home tab. Check leading zeros on identifiers because number formatting can hide or remove them.

The import overwrote or landed beside the wrong data. Use Undo immediately if available, then inspect the worksheet before trying again. Select a clear destination cell and confirm the surrounding range is empty. If you have already made further changes, do not delete a broad range without checking whether it contains other work; restore from a saved copy or version history if necessary.

Frequently Asked Questions

Can Excel turn a photo of a table into editable cells?
Yes. With a supported version, use Data > From Picture to recognize a table in a photo or screenshot. Review the extracted data and select Insert Data to put it in the worksheet.

Can I extract data from a screenshot?
Yes. Save the screenshot as an image and use Picture From File, or copy the image and choose Picture From Clipboard when that option is available. A clear screenshot with legible text usually works better than a compressed or enlarged copy.

Does From Picture work with handwriting?
It is intended for recognizing tabular data in images, and handwritten entries are less dependable than clear printed text. If you try handwriting, expect to check and correct every value rather than assuming the recognition is accurate.

Can I use this feature in Excel on a Mac?
Some Microsoft 365 for Mac versions include Data > From Picture. The source choices and exact interface can differ from Windows. Update Excel and check the Data tab; if the command is not present, use a supported Windows or mobile version.

Will Excel keep the original image in the worksheet?
No. From Picture extracts the detected table into cells; it does not automatically preserve the source picture as an image on the sheet. Keep the original file separately or insert the picture into the worksheet as a reference if needed.

Can I convert a whole page or a complicated report?
You can try, but recognition is most useful when the image contains a clear table. A page with multiple tables, notes, merged headings, or decorative formatting may be interpreted inconsistently. Crop and import one table at a time, then verify the complete result.

Related

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.