Data Import & Export

Fix Excel Data from Picture Button Missing in Windows Version 2209

Steve KSteve K Oct 22, 2026 871 views

Question details

The user needs to find or restore the 'Data from Picture' feature to convert images into editable spreadsheet data.

How to Fix the Excel Data from Picture Button Missing in Windows Version 2209
Product
Microsoft Excel
Device & OS
Windows
Scenario
Attempting to extract tabular data from an image and insert it directly into a spreadsheet.
Observed behavior
The 'Data from Picture' button is entirely missing from the ribbon in Excel for Windows Version 2209 (Build 15629.20208).
Before you start

Ensure your computer is connected to the internet, as cloud-based OCR services require an active connection to process and convert images into data.

Solution 1Recommended

Update Office and Verify Account Licensing

The 'Data from Picture' feature requires a Microsoft 365 subscription and the latest updates. Checking these ensures the feature is properly rolled out to your account.

Microsoft often rolls out new features gradually. Even if you are on Windows version 2209, the feature might be gated by your subscription tier or pending a minor patch.

1
Check Subscription Status

Open Excel, click on 'File' in the top-left corner, and select 'Account' at the bottom of the menu. Ensure that your account shows 'Subscription Product for Microsoft 365'.

2
Install Latest Updates

Under the 'Product Information' section, click the 'Update Options' drop-down menu and select 'Update Now'. Wait for Excel to download and apply any available background updates.

3
Restart the Application

Once the updates are completely installed, close Excel entirely and relaunch the program to refresh the ribbon features.

Update Office and Verify Account Licensing
Staged Rollouts: If you are on an enterprise or school account, your IT administrator may manage update channels, potentially delaying the arrival of the Data from Picture feature.
Built-in OCR Alternative

Use WPS Office to Convert Pictures to Excel Data Instantly

If Excel's Data from Picture feature is missing or restricted by your subscription, WPS Spreadsheet provides a built-in, highly accurate 'Picture to Spreadsheet' OCR tool. It works seamlessly on Windows, converting images and screenshots into editable tabular data without requiring expensive subscriptions.

  1. 1. Open WPS Spreadsheet: Launch WPS Office on your computer and open a new or existing spreadsheet document.
  2. 2. Access the OCR Tool: Navigate to the 'Tools' or 'Data' tab on the top ribbon and click on the 'Picture to Spreadsheet' (or Screen to Excel) button.
  3. 3. Import Your Image: Upload your picture file (JPG, PNG) or use the built-in screen capture tool to select the table directly from your screen.
  4. 4. Convert and Edit: Wait a few seconds for the OCR engine to process the image. The tabular data will be automatically extracted and pasted into editable cells.
Native built-in Picture to Spreadsheet OCR toolFully compatible with Microsoft Excel (.xlsx) file formatsNo staged feature rollouts; OCR is available immediatelyLightweight, fast, and available as a free download
microsoft office alternative - wps office

Frequently Asked Questions

Is the 'Data from Picture' feature available on all versions of Excel?

No, this feature is exclusively available to Microsoft 365 subscribers. Users with one-time purchase licenses like Office 2019 or Office 2021 will not have access to this button.

Why does the 'Data from Picture' button appear on Mac but not Windows?

Microsoft often rolls out features to different platforms at varying times. Mac users received this specific feature earlier, while Windows users frequently experience staged rollouts or build-specific delays.

Can I extract data from a picture without a Microsoft 365 subscription?

Yes, you can use alternative office suites like WPS Office, which includes a robust and completely built-in 'Picture to Spreadsheet' OCR feature to achieve the same result.

What image formats are supported for Excel data extraction?

Most spreadsheet OCR tools, including Microsoft's and WPS Office's, support standard image formats such as JPG, JPEG, PNG, and BMP for extracting tabular data.