Fix Excel Data from Picture Button Missing in Windows Version 2209
Question details
The user needs to find or restore the 'Data from Picture' feature to convert images into editable spreadsheet data.

- 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).
Ensure your computer is connected to the internet, as cloud-based OCR services require an active connection to process and convert images into data.
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.
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'.
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.
Once the updates are completely installed, close Excel entirely and relaunch the program to refresh the ribbon features.

Check and Customize the Excel Ribbon
The feature might be installed on your device but accidentally removed or hidden from your active Data tab.
Submit Direct Feedback to Microsoft
Since some guidance applies only to Excel for Mac and specific Windows builds have known feature absences, submitting feedback alerts the development team to your specific missing build.
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. Open WPS Spreadsheet: Launch WPS Office on your computer and open a new or existing spreadsheet document.
- 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. 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. 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.

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.




