Extract Text from an Image in Excel with Data from Picture

How-to basics · Updated November 20, 2026

To extract a table from a photo or screenshot in Excel for Microsoft 365 on Windows, choose Data > From Picture > Picture From File, select the image, review Excel’s recognition results, then choose Insert Data. Excel’s tool is designed for tables, not paragraphs of text; for ordinary text, use OCR such as OneNote’s Copy Text from Picture and paste the result into Excel.

What You’ll Need

  • Excel for Microsoft 365 on Windows, updated to a version that includes Data > From Picture. The feature needs an internet connection to process the image.
  • A clear image file of the table, such as a PNG or JPG, or a table image already copied to the clipboard.
  • Permission to use Microsoft’s connected experiences if your organization manages Office privacy settings. If the command is missing or disabled, check with your Microsoft 365 administrator.
  • For a screenshot or photo containing paragraphs rather than a table, OneNote desktop for Windows is a useful alternative OCR tool.

Step-by-Step

  1. Decide whether the image contains a table. Data from Picture recognizes rows and columns and turns them into cells. It works best on information arranged in a grid, such as a printed list with headings and values, a receipt table, or a spreadsheet screenshot. It is not a general-purpose tool for preserving the layout of a page of paragraphs. For paragraph text, skip to step 8.
  2. Prepare the image. Use a sharp, well-lit image with the whole table visible. Straighten a photo taken at an angle, crop away unrelated objects, and make sure the table’s borders and text are not cut off. If the source is a paper document, place it on a plain surface and avoid shadows or glare. A clean screenshot is usually preferable to photographing a monitor.
  3. Open the destination workbook and select a starting cell. Open the workbook in the Excel desktop app and select the cell where the top-left corner of the extracted table should go, for example A1 on a new worksheet. Excel inserts the recognized data starting at the active cell, so choose an empty area with room for the full table. If you are unsure how many rows it contains, use a blank sheet.
  4. Start the image import. On the ribbon, select Data > From Picture > Picture From File. Browse to the image, select it, and choose Open. If the table image is already copied, select Data > From Picture > Picture From Clipboard instead. The exact wording or placement may vary slightly with your Excel update, but look for From Picture on the Data tab.
  5. Wait for recognition to finish. Excel displays an import pane with a preview of the image and the cells it has recognized. Processing can take a little time, especially for a large picture or a slower connection. Keep the pane open until the results appear. If Excel asks you to select an image or confirm a source, follow the prompt and check that you chose the intended file.
  6. Review the recognized cells against the picture. Do not assume that OCR has read every character correctly. Excel may flag entries that need attention. Select each flagged result, compare it with the original image, and correct the value in the review pane. Pay particular attention to decimal points, minus signs, dates, similar-looking letters and digits, and values near faint gridlines. Check headings and the first and last rows too, since a missing column or cropped edge can affect the whole table.
  7. Insert the data. When the preview is accurate enough, choose Insert Data in the pane and confirm if Excel asks whether to insert the results. The table is placed in the worksheet starting at the cell you selected. Review the worksheet itself after insertion: verify that columns line up, all expected rows are present, and values have not been placed over existing information.
  8. Check and format the imported cells. OCR can identify what looks like a number or date but still assign it an unsuitable format. Select the relevant cells and use Home > Number Format to choose a suitable format, or adjust column widths so full values are visible. Check IDs, postal codes, product codes and account numbers carefully; Excel may remove leading zeros if it interprets them as numbers. If those characters matter, format the destination cells as Text before importing when practical, or correct the affected values afterward. Save the workbook when you are satisfied.
  9. For a paragraph or other non-table text, use OCR and paste into Excel. In OneNote desktop for Windows, insert the image on a page, right-click the image, and choose Copy Text from Picture. OCR may take a moment; then select a worksheet cell and press Ctrl+V. On Windows, Ctrl+V pastes from the clipboard. Review line breaks and punctuation, because OCR may split a sentence across rows or confuse characters. If you are using a Mac, the usual paste shortcut is Command+V. The OneNote command may not be available in every OneNote version or may take time to appear after inserting an image.

Platform note: The steps above are for Excel for Microsoft 365 on Windows. Excel for Microsoft 365 for Mac may also offer Data > From Picture; if available, choose the picture-from-file or clipboard option and review the results in the same way. Menu availability can depend on your update and account. Excel for the web does not provide the same desktop From Picture workflow, so open the workbook in the desktop app or use Excel’s mobile app if its image-to-data feature is available. On Mac, use Command+V to paste; on Windows, use Ctrl+V.

Common Mistakes

  • Expecting Excel to extract a page of prose as a table. From Picture is intended to recognize tabular data. For paragraphs, use an OCR option such as OneNote’s Copy Text from Picture, then paste the text into the worksheet.
  • Importing a blurry, tilted or cluttered photo. Small characters, glare, shadows and skew make recognition less reliable. Retake the photo or crop and straighten it before importing rather than trying to repair a large number of errors afterward.
  • Accepting the preview without checking it. A result can look plausible while containing a misplaced decimal, a mistaken minus sign or a wrong digit. Compare important entries with the source before using the data.
  • Ignoring Excel’s interpretation of values. Dates can be read in an unexpected day-month order, and codes with leading zeros can lose those zeros when treated as numbers. Check the values and formats after insertion.
  • Placing the result over existing cells. Excel inserts the recognized grid into the worksheet. Choose a clear starting cell or a new sheet so you do not overwrite data or formulas.
  • Assuming image import is a text-extraction archive. The imported worksheet contains recognized cell contents, not a dependable copy of the original image or its document layout. Keep the source image if you may need to verify the transcription later.

Tips

  • Use the original image or a direct screenshot rather than a compressed copy sent through a messaging app. Compression can blur small characters.
  • Crop tightly around the table, but leave a little space around its outer edges. Including nearby paragraphs, page numbers or another table can confuse the detected boundaries.
  • Make sure the text contrasts clearly with its background. Dark print on a light, even surface is easier to recognize than pale text, colored shading or handwriting.
  • If the table has no visible borders, keep the rows and columns evenly aligned in the image. Consistent spacing helps Excel infer the grid.
  • For a large table, import one clean section at a time if recognition struggles. Keep the sections in separate worksheet areas initially, then compare their headings and row order before combining them.
  • Preserve the image until the imported data has been checked. Keeping the source nearby makes it much easier to catch OCR errors and answer questions about where a value came from.
  • If you need to capture a table from paper regularly, Excel’s mobile app may offer Insert Data from Picture. Use its camera workflow, review the recognized entries, and then save or open the workbook on your computer.

Troubleshooting

  • From Picture is missing. Confirm that you are using the Excel desktop app rather than Excel for the web, and check for Office updates. The feature may also be unavailable under a particular license, installation, or organization policy. If your work account blocks connected experiences, ask your administrator whether the feature can be enabled.
  • Excel cannot process the image. Confirm that the file opens in an image viewer and try saving a fresh copy as PNG or JPG. Crop out unnecessary areas, reduce an unusually large image, and check your internet connection. If the image is from the clipboard, copy it again and choose the clipboard option; otherwise import the saved file.
  • The preview has too many mistakes. Cancel or leave the import without inserting, then improve the source image. Retake it straight-on with more light, remove glare, increase the image resolution, or crop to one table. If only a few cells are wrong, correct them in the review pane before insertion.
  • Rows or columns are combined or split incorrectly. Make the table boundaries clearer by cropping, straightening the image and including the complete table. Avoid cutting through a row or column. For an unbordered table, try an image where spacing between columns is consistent; if the structure still cannot be recognized, use OCR to copy the text and arrange it manually in Excel.
  • Text is missing, especially at the edges. Check whether the image clipped the first or last row, column, or character. Take a new image with the entire table visible and a small margin around it. Do not rely on recognition to reconstruct content that is absent from the picture.
  • Numbers, dates or codes changed after insertion. Compare the cell with the original image and correct the value. Set the appropriate number format after confirming the intended value. For identifiers where every character must be preserved, use Text formatting and verify that leading zeros remain.
  • OneNote does not show Copy Text from Picture. Make sure you are using a OneNote desktop version that supports the command, and allow time for image processing. Try right-clicking the image again after a pause. If the option remains unavailable, use another OCR tool available on your device or manually transcribe the image; then paste or type the result into Excel.

Frequently Asked Questions

Can Excel extract text from any picture?
Not reliably as general text. Excel’s From Picture feature is for tables and returns recognized rows and columns. For a paragraph, label or block of prose, use an OCR tool such as OneNote and paste its result into Excel.

Does Excel convert a photo of a printed table into editable cells?
Yes, Data > From Picture can recognize a clear photo of a printed table and insert the result as worksheet cells. Review the preview carefully, because lighting, angle, print quality and small text can affect accuracy.

Can I use a screenshot instead of a photo?
Yes. A clear screenshot of a table is often a suitable source. Save it as an image or copy it, then choose the file or clipboard option under Data > From Picture.

Why does Excel get some digits wrong?
OCR can confuse characters that look alike, such as 0 and O, 1 and I, or a decimal point and a speck in the image. Low resolution, glare and faint printing increase the chance of errors. Compare flagged and important values with the original.

Can I extract text from an image in Excel for the web?
The web version does not offer the same From Picture workflow as the desktop app. Open the workbook in Excel for Microsoft 365 on Windows or Mac if the command is available, or use an OCR tool and paste the extracted text into the web workbook.

Will the imported data keep the original formatting?
Do not count on it. From Picture is intended to transfer recognized data, not reproduce the source document’s full appearance. Apply number formats, column widths and other worksheet formatting after checking the inserted values.

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.