Insert Data from Picture in Excel: Turn Printed Tables into Editable Spreadsheets

Excel can now help you digitize tables from photos, screenshots, and image files—saving time on manual data entry while still giving you a chance to review the results before they are inserted.

What is Data from Picture in Excel?

Data from Picture is an Excel feature that uses image recognition to detect a table in an image and convert it into editable spreadsheet data. It is useful when you receive information on paper, in a PDF screenshot, on a whiteboard, or in a photo and need to work with it in Excel. Common examples include printed price lists, inventory sheets, schedules, event rosters, handouts, receipts, and tables copied from a screen.

Where the feature is available in 2026

Data from Picture is no longer just an Android preview feature. It is available in current Excel experiences across supported Microsoft 365 Apps, including Excel on mobile and supported desktop clients. Exact availability can vary by platform, app version, update channel, region, and organizational policy. If you do not see the option, update Excel, confirm that you are signed in, check whether your Microsoft 365 Apps update channel has received the feature, or try the Excel mobile app.

Before you start

Use a clear image with the table fully visible, good lighting, and minimal glare or shadows. Keep the camera as straight as possible so rows and columns are not skewed. For desktop use, you can typically start from an image file or clipboard image where supported. For mobile use, you can take a new photo or use an existing image, depending on the app and device permissions. For business users, make sure Microsoft 365 Apps are properly licensed and kept current; subscriptions purchased through Cloud Solution Provider licensing are managed under Microsoft’s New Commerce Experience terms.

How to insert data from a picture on mobile

Open Excel on your iPhone, iPad, or Android device and open the workbook where the data should go. Choose the Data from Picture or Insert Data from Picture option, then take a photo or select an existing image. Crop the image so Excel focuses only on the table. Excel will analyze the image and show a preview of the detected data. Review highlighted cells carefully, correct any values that were misread, and then insert the data into your worksheet.

How to use Data from Picture on desktop

In supported Excel desktop clients, open the workbook and go to the Data tab. Look for From Picture, then choose a source such as Picture From File or Picture From Clipboard if those options are available in your version. Select the image and let Excel process it. Review the extracted table, resolve any flagged items, and insert the results into the worksheet only after validating the data.

Always review the results

Data from Picture can save time, but it should not be treated as a guaranteed perfect import. Excel may flag uncertain cells for review, and it may occasionally misread numbers, dates, punctuation, headers, or merged cells. Before using the data for reporting, billing, compliance, or operational decisions, compare the imported table against the original source and verify formulas, totals, dates, and identifiers.

Limitations to expect

The feature works best with clean, simple tables. Complex layouts, nested tables, rotated text, handwritten notes, low-resolution images, watermarks, stamps, heavy formatting, or poor lighting can reduce accuracy. Handwriting recognition may vary and should be checked especially carefully. If the source is a long document or a complex PDF, you may get better results by using a more structured capture process, Power Query, Power Automate, or a document processing workflow.

Business productivity opportunities

For individuals, Data from Picture is a quick way to reduce repetitive data entry. For teams, it can be part of a broader Microsoft 365 productivity approach: standardizing Excel templates, storing source files in OneDrive or SharePoint, automating follow-up steps with Power Automate, and using Microsoft 365 Copilot where appropriate to summarize, clean up, or analyze workbook data after it has been verified.

Key takeaways

• Excel’s Data from Picture feature converts tables in images into editable worksheet data.
• The feature has expanded beyond the original Android preview and is available in current supported Microsoft 365 Excel experiences, though availability can vary by platform and update channel.
• Good image quality improves results, but users should always review and validate the extracted data before relying on it.
• For repeatable business processes, combine Excel with OneDrive, SharePoint, Power Automate, and Microsoft 365 Copilot rather than depending on one-off manual imports.

Need help keeping Microsoft 365 Apps current, managing licensing under NCE, or improving Excel-based workflows? IT Partner can help you deploy, support, and optimize Microsoft 365 productivity tools for your organization.