Data Import & Export

Fix 'Data from Picture' Missing in Excel: Causes & Solutions

Ayan Masood Oct 9, 2026 868 views

Question details

The user is unable to find the 'Data from Picture' feature in Microsoft Excel despite having a Microsoft 365 subscription.

How to Fix 'Data from Picture' Missing in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Importing tabular data from a printed image or screenshot directly into an Excel spreadsheet.
Observed behavior: The 'Data from Picture' option is completely absent from the Data tab ribbon.

Before you start

Ensure you have an active internet connection, as Microsoft 365 relies on online cloud services to process image-to-data conversions.

Solution 1Recommended

Update Microsoft 365 to the Latest Version

The 'Data from Picture' feature was rolled out incrementally. Older builds (such as version 1808) do not include this functionality and must be updated.

Since Data from Picture is an exclusive Microsoft 365 feature, it requires a relatively recent build on the Current Channel. Volume-licensed versions (like Office 2019 or 2021) or older Semi-Annual Enterprise channels often lack this feature.

Open Account Settings

Open Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' at the bottom of the left-hand menu.

Check for Updates

Under the 'Product Information' section, click on the 'Update Options' dropdown button.

Apply Updates

Select 'Update Now'. Excel will check for and download the latest Microsoft 365 updates. Once completed, restart Excel and check the Data tab.

Update Microsoft 365 to the Latest Version

Check Your Update Channel: If you are on an enterprise network, your IT administrator may have locked your update channel to an older version. You will need to request an update from your IT department.

Solution 2

Verify Platform and Account Type Requirements

Verify that your specific device, region, and account license support the Data from Picture feature.

Solution 3

Use a Third-Party OCR Tool as an Alternative

If you cannot update your Excel version, you can use external Optical Character Recognition (OCR) tools to extract text from images.

Picture to Excel in WPS Office

Extract Data from Pictures Instantly with WPS Office

Don't let missing Excel features slow you down. WPS Office provides a built-in, highly accurate 'Picture to Excel' tool that seamlessly converts images into editable spreadsheet data without requiring expensive subscriptions.

1. Open WPS Spreadsheet: Download and launch WPS Office, then open a new or existing Spreadsheet.
2. Navigate to the Tools Tab: Click on the 'Tools' tab located on the top ribbon menu.
3. Select Picture to Excel: Click on the 'Picture to Excel' icon and upload the image containing your tabular data.
4. Convert and Review: Let the built-in OCR extract the data. Review the generated spreadsheet for accuracy and save your work as an .xlsx file.

Built-in OCR technology for instant image-to-data conversion.Seamless compatibility with Microsoft Excel (.xlsx) file formats.Lightweight and free alternative to complex Microsoft 365 subscriptions.Works reliably across Windows, Mac, and mobile platforms.

microsoft office alternative - wps office

Frequently Asked Questions

Why is 'Data from Picture' missing in my Excel 2019 or 2021?

The 'Data from Picture' feature is exclusive to Microsoft 365 subscribers. Perpetual, one-time purchase versions like Office 2019 and Office 2021 do not receive these continuous cloud-based feature updates.

Can I use Data from Picture on Excel for Mac?

Yes, the feature is available for Microsoft 365 subscribers on Mac. You can find it by navigating to the Data tab and selecting 'Data from Picture' if your software is fully updated.

What should I do if my Excel version is 1808 and the feature is missing?

Version 1808 is an older build (often associated with Office 2019 or older enterprise channels). You must update to a newer Microsoft 365 build to access this feature, or use alternative OCR software.

Excel & Data Problems