Insert Text From Image in Excel: Step-by-Step

To insert text from an image into Excel for Microsoft 365 on Windows, select a blank cell, choose Data > From Picture > Picture From File (or Picture From Clipboard), review Excel’s recognition, and select Insert Data. This feature works best with tables: it turns photographed or screenshot table content into editable cells, but it may not preserve ordinary paragraphs as intended.

What You’ll Need

Excel for Microsoft 365 on Windows, with the From Picture command available on the Data tab. Some Excel builds and organizational settings may not show the feature.
A clear image file or a picture copied to your clipboard. A straight-on, well-lit image of a table usually gives the best result.
A blank area in the worksheet where Excel can place the recognized data. Check that the destination cells will not overwrite existing information.
An internet connection may be needed for image recognition, depending on your Excel build and setup. Follow your organization’s rules before sending sensitive images to an online service.

Step-by-Step

Prepare the image. Choose a photo or screenshot where the table is fully visible, not cropped at the edges, and large enough to read. If possible, retake a photo from directly above the page or screen rather than at an angle. Good lighting, sharp focus, and clear separation between rows and columns help Excel identify the structure. Crop out unrelated material, but leave a little space around the table so borders or labels are not cut off.
Open the destination workbook and choose a starting cell. Open the worksheet where you want the result. Click a blank cell at the upper-left corner of the intended output area. Excel generally places the converted table beginning at the active cell and fills cells to the right and below it. Leave enough empty space for the full table, and avoid selecting a cell inside another table or a range containing data you need to keep.
Start the import from an image file. On the ribbon, select Data > From Picture > Picture From File. Browse to the image, select it, and choose Open. If the From Picture button is shown as an icon or its wording differs slightly in your build, look on the Data tab for the picture-to-data command. Excel will analyze the image and display a preview of the data it recognized.
Or, start from a picture on the clipboard. If you have a screenshot or copied image, use the Windows Snipping Tool with Windows logo key + Shift + S to capture the table. The snip is copied to the clipboard. In Excel, select a blank starting cell, then choose Data > From Picture > Picture From Clipboard. If the copied image does not appear, recapture it and make sure the snip was copied rather than only saved as a file. You can use the Picture From File route instead if the screenshot was saved.
Check the recognition preview carefully. Excel displays the image alongside the table it has interpreted. Compare the preview with the original, checking column order, row boundaries, headings, and every value. Pay particular attention to characters that look alike, such as 0 and O, 1 and l, commas and decimal points, or minus signs and dashes. Also check whether a value that belongs in one cell has been split across two cells, or whether adjacent columns have been combined.
Review items Excel flags. If Excel marks a cell or provides a Review option, select the item and compare the suggested value with the source image. Correct the text or number when the source is clear. If you cannot tell what a character should be, zoom in on the original image or retake it rather than guessing. The review interface can vary between Excel builds, so use the preview and any prompts shown in your version.
Insert the corrected data. When the preview is acceptable, choose Insert Data and confirm if Excel asks whether to proceed. The recognized information is placed in the worksheet as cells, not as a single picture. Wait for the import to finish, then look at the resulting range to confirm the table starts in the intended location and that rows and columns line up.
Check the inserted values and formatting. Compare the worksheet with the image once more. Excel may recognize text that looks like a date, percentage, or number and store it using a corresponding data type or format. Check long numbers, leading zeros, dates, and decimal values especially carefully. If a code such as 00427 must retain its leading zeros, confirm that Excel has not treated it as the number 427; correct the cell format or enter the value as text when that is necessary for your data.
Make the data usable. Adjust column widths, add or restore headings, and apply suitable number formats if needed. If you plan to sort or filter the result, make sure each column has one consistent type of information and that the header row is distinct. Save the workbook after checking the import. Keep the source image until you are satisfied that the worksheet contains an accurate copy.

Common Mistakes

Expecting a photo of a paragraph to become a perfectly arranged worksheet. From Picture is intended for recognizing tabular data. A block of prose may be split into unexpected rows or columns. For ordinary paragraphs, use an OCR tool that copies text, such as OneNote’s picture-text recognition where available, then paste the extracted text into Excel and arrange it as needed.
Importing a blurry, angled, or low-contrast image. OCR can mistake characters or fail to detect cell boundaries when the image is difficult to read. Retaking the photo straight-on, improving the light, or using a sharper screenshot is often more useful than correcting a long list of recognition errors.
Clicking Insert Data without checking the preview. A conversion can look plausible while containing a wrong digit, missing minus sign, or misplaced decimal point. A single incorrect value can matter in a stock list, inventory count, or other operational record, so compare the imported cells against the source.
Choosing a destination that is not empty. The converted range can extend across multiple columns and rows. Start in a clear part of the sheet and leave room for the full table to reduce the risk of overwriting existing cells or creating an untidy overlap.
Assuming Excel will preserve the original appearance. The feature extracts data, not the image’s exact layout, fonts, colors, or merged-cell design. Reapply formatting in Excel if you need a presentation-ready table.
Ignoring leading zeros or text-like numbers. Product IDs, postal codes, and account references may be interpreted as numeric values. Check them after insertion and preserve them as text if the zeros or exact character sequence are meaningful.

Tips

For a printed table, place the page flat and take the photo from directly above. Keep the whole table in frame, including column headings and any row labels needed to interpret the values.
For a table on a screen, use a screenshot rather than photographing the monitor. A screenshot avoids glare, moiré patterns, and perspective distortion. On Windows, Windows logo key + Shift + S opens the screen snipping overlay.
Use one image per table when possible. If the image contains several unrelated tables, crop and import them separately so you can check each result and place it where it belongs.
Keep the source visible while reviewing the result. If Excel’s preview is too small, enlarge the image in a separate window or recapture a closer, sharper image. Do not rely on memory to verify numbers.
When a table contains important totals, counts, or identifiers, verify those values individually after insertion. OCR is a time-saving aid, not a guarantee that every character is correct.
For a sensitive document, consider whether its contents may be processed by a connected service before importing. If you are unsure, check your organization’s data-handling policy or use an approved offline OCR method.

Troubleshooting

There is no From Picture option. Confirm that you are using a Microsoft 365 version of Excel on Windows and that the Data tab is visible. Install available Office updates, restart Excel, and check whether your organization controls connected experiences or disables particular features. If the command remains unavailable, your build or account may not support it. You can use an approved OCR alternative to extract the text and paste it into the worksheet.

Excel does not recognize the image or produces an empty preview. Try a clearer image with more contrast and less background clutter. Make sure the table is not cut off, the text is large enough to read, and the image is not heavily tilted. For a screenshot, capture only the relevant area. If you imported from the clipboard, recopy the image or save it and try Picture From File.

Rows or columns are in the wrong places. The image may not show clear separation between the table’s cells, or Excel may have mistaken lines, spacing, or nearby text for part of the table. Review the preview and correct individual entries when possible. If the structure is substantially wrong, cancel or start over with a tighter crop, straighter image, or clearer table boundaries rather than trying to repair every cell afterward.

Some characters or numbers are wrong. Compare each questionable cell with the original at a larger zoom. Re-enter ambiguous values manually, especially decimal points, signs, and characters in IDs. If Excel interpreted a value as a date or removed leading zeros, correct its format and content after insertion. Formatting alone will not restore characters that OCR failed to capture.

The inserted table overwrote or collided with other content. Use Undo immediately if the insertion has just happened and the result is not what you want. Then repeat the import with a blank starting cell and enough clear space. If you notice the issue later, restore the affected information from a saved copy or version history if available; do not assume that rearranging the new cells will restore overwritten data.

The feature behaves differently on a Mac or in Excel for the web. Ribbon options and availability depend on the Excel edition and build. On a Mac, check the Data tab for From Picture; if it is present, follow the on-screen file or clipboard choices, and use the Mac screenshot controls if you need to copy an image. If the command is missing, use a supported desktop build or an OCR workflow available to you. Excel for the web may not offer the same import controls as the Windows desktop app, so do not rely on identical steps there.

Frequently Asked Questions

Can Excel turn a photo of a table into cells?
Yes. In supported Microsoft 365 builds, use Data > From Picture, review the recognized table, and choose Insert Data. Check the result because recognition can make mistakes.

Can I extract text from an image directly into Excel?
You can use From Picture for text arranged in a table. For a paragraph or a page of continuous text, Excel may not preserve the reading order or layout. Use an OCR tool to copy the wording, then paste and organize it in Excel.

Can I use a screenshot instead of an image file?
Yes, if the screenshot is copied to the clipboard. Select a starting cell and choose Data > From Picture > Picture From Clipboard. You can also save the screenshot and import it with Picture From File.

Does Excel recognize handwriting?
Handwriting can be difficult to read consistently, especially if it is cursive or uneven. Results depend on how clear the writing is and the recognition support available in your Excel build. Review every entry and manually correct anything uncertain.

Why did Excel remove a leading zero?
Excel may have interpreted the recognized entry as a number, and numeric values do not retain leading zeros by default. Check the cell after import and store identifiers as text when their zeros are part of the value. Recheck the exact characters against the image.

Can I undo an image import?
Usually, you can use Ctrl + Z in Excel for Windows immediately after inserting the data. On Mac, use Command + Z. If you have made more changes since the import, undo may also reverse those changes, so consider saving a copy before editing an important workbook.

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.