Manually typing data from a printout or a screenshot into Excel is time-consuming and error-prone, but you can skip the data entry grind by letting Excel do the heavy lifting. Whether you’re on your phone or your computer, the Data from Picture tool turns image rows into digital cells in seconds.

How the Data from Picture feature works in Excel

Converting physical clutter and static images into digital cells

If you’ve ever stared at a printed table and sighed at the prospect of transcribing it, you’re exactly the kind of person Microsoft had in mind when it developed the Data from Picture tool. It uses optical character recognition (OCR) to analyze the layout and structure of a photo or screenshot.

When you feed an image into Excel, the OCR engine looks for lines, spacing, and alignment to determine where columns and rows begin and end. The result is a structured preview that turns a flat image into an editable spreadsheet, meaning you can bypass the grunt work of data entry and move straight to analysis.

Things you should know before starting your first scan

Where the tool shines and how to capture the best image

While the OCR technology is impressive, its accuracy depends heavily on the quality of your source. Think of it like a pair of glasses: if the view is blurry, Excel will struggle to read the fine print.

If you’re taking a photo of some data to upload to Excel:

• Prioritize high contrast: Black text on a crisp white background produces the best results.
• Flatten your paper: Ensure physical documents are as flat as possible to avoid distorted rows.
• Avoid shadows and glare: Uneven lighting can create artifacts that confuse character recognition.
• Hold steady: Even slight motion blur can turn a “0” into an “8.”

And if you’re taking a screenshot:

• Zoom in first: Before snapping your screenshot, zoom in on the web page or PDF so the text is large and high-resolution.
• Crop out the UI: Don’t include browser tabs, scroll bars, or nearby buttons. Grab only the table itself.
• Avoid dark mode: OCR often performs better with traditional black text on a light background.
• Match the scale: If the table is wide, try to capture it in a single shot rather than stitching multiple small screenshots together.

How to use Data from Picture in the Excel desktop app

Importing images and screenshots from your computer

In the desktop version of Excel (Microsoft 365 for Windows and Mac), you can either import an image file or, in some versions, paste a screenshot from your clipboard.

1. Open your Excel workbook and select the cell where you want to begin.
2. Navigate to the Data tab on the ribbon, then click From Picture.
3. If you’re using a saved image, click Picture From File, and if you just took a screenshot, click Picture From Clipboard.
4. If using a file, browse to your image, select it, and click Insert.

Once selected or pasted, Excel builds a preview of your dataset in a review pane. Depending on your device and the complexity of the image, this usually takes a few seconds.

Because the images aren’t always perfect, don’t insert the data right away. First, follow the review steps below to confirm everything was interpreted correctly.

How to turn physical documents into data in the Excel mobile app

Capturing photos of tables directly into your spreadsheet

The mobile experience is even more powerful because it lets you digitize data in real time. If you’re standing in front of a whiteboard or holding a printed receipt, your phone is the fastest way to get that information into Excel. You can also take a photo and import it later.

1. Open a new worksheet in the Excel mobile app (iPhone or Android), then select the cell where you want the data to go.
2. Tap the Data from Picture icon, which is usually found in the toolbar or the Insert menu.
3. Tap either the shutter button to capture an image, or Import to upload a picture from your gallery.
4. Use the cropping handles to isolate only the table you want to import, then tap Review and Edit or Review (depending on your version).

Just like on the desktop app, you’ll then see a review screen where you can check for and correct errors (see below).

Reviewing and cleaning up your data after the import

Using the panel to fix errors before committing to the sheet

Even strong OCR systems aren’t perfect, and results are rarely 100% accurate on the first pass. Before Excel places the data into your spreadsheet, it opens a review interface designed to catch and fix potential errors.

In the review area, cells highlighted in red indicate uncertain OCR results. Select one of these to compare the original image snippet with the interpreted text. Then:

• On desktop, if the conversion is inaccurate, type the correction into the text box, then click Accept.
• On mobile, tap Edit, correct an error, and tap Done. Otherwise, tap Ignore to move on.

Once Excel indicates there are no more items to review—and you’ve run a final manual pass on things like header spellings, differentiation between “0” and “O”, decimals, negative signs, and parentheses—select Insert Data or Insert (depending on your version) to place the cleaned results onto your worksheet.

Finally, you can format the data as an Excel table (Ctrl+T) to formalize the structure and ensure the correct number formats are applied to each column.

Converting static images and screenshots into digital Excel data is a major productivity boost, but the process isn’t complete until you’ve verified the results. Once your data is clean, instead of straining your eyes by jumping between your paper and your monitor, you can get Excel to read the cells back to you. This hands-free auditing method ensures your new digital copy matches your original source perfectly.

OS

Windows, macOS, iPhone, iPad, Android

Free trial

1 month

Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.