Fix Excel Insert Data from Picture Feature Missing
Question details
The user is unable to locate or use the Insert Data from Picture feature in Microsoft Excel and needs to identify the system requirements or troubleshooting steps to enable it.

- Product
- Microsoft Excel
- Device & OS
- Windows 10 (1903 or later) or Windows 11
- Scenario
- Attempting to extract tabular data from an image file and import it directly into an Excel spreadsheet.
- Observed behavior
- The Insert Data from Picture command is missing from the Excel ribbon, preventing the user from converting images into spreadsheet data.
Ensure you are signed in with an active Microsoft 365 subscription, as this cloud-backed feature is not available in standalone perpetual versions like Office 2019 or 2021.
Verify Windows OS and Install Microsoft Edge WebView2
The image data extraction tool requires a modern Windows operating system and the WebView2 runtime to process cloud-based OCR requests properly.
Microsoft leverages the Microsoft Edge WebView2 Runtime to handle web-based cloud operations within Office desktop applications. Without it, the feature will remain hidden.
Press the Windows key + R, type 'winver', and press Enter. Confirm that you are running Windows 11 or Windows 10 version 1903 or newer.
Visit the official Microsoft Edge developer website and download the Microsoft Edge WebView2 Runtime installer.
Run the downloaded executable to install WebView2. Once the installation is complete, restart your computer and open Excel to see if the feature appears.

Run Excel in Safe Mode and Update
Conflicting add-ins or outdated Office builds can block the interface from displaying newly rolled-out features.
Repair or Reinstall Microsoft 365
A corrupted Office installation might fail to load specific cloud-connected features, requiring an online repair.
Use WPS Office to Extract Data from Pictures Easily
If Excel's feature is unavailable due to subscription restrictions or missing Windows components, WPS Spreadsheet offers a powerful, built-in OCR (Optical Character Recognition) tool to instantly convert images into editable tables.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new blank spreadsheet or your existing workbook.
- 2. Access the Picture to Text Tool: Navigate to the 'Tools' tab on the top ribbon and click on the 'Picture to Text' or 'OCR' option.
- 3. Import and Convert: Upload your image file. WPS Office will automatically scan the picture and populate your spreadsheet cells with the extracted data.

Frequently Asked Questions
Why is the Insert Data from Picture feature only available for Microsoft 365?
This feature relies on cloud-based AI services to process the image and accurately extract tabular data. Microsoft reserves these intelligent, cloud-connected features for active Microsoft 365 subscribers, meaning users with standalone versions like Office 2019 or 2021 will not have access to it.
Will joining the Office Insider program help me get this feature?
Yes. If the feature is currently undergoing a staged rollout or is limited to certain update channels, joining the Microsoft 365 Insider program might grant you early access. You can join by going to File > Account > Microsoft 365 Insider in Excel.
Does the Insert Data from Picture feature work on macOS?
Yes, the feature is available in Excel for Mac. As long as you have an active Microsoft 365 subscription and are running a supported version of macOS, you can use your device's camera or select an image file to insert data into your spreadsheet.




