logo
search
Office Compatibility Issues

Fix Excel Insert Data from Picture Feature Missing

Nimra MalikNimra Malik Oct 12, 2026 868 views

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.

How to Fix Excel Insert Data from Picture Feature Missing
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.
Before you start

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.

Solution 1Recommended

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.

1
Check your Windows version

Press the Windows key + R, type 'winver', and press Enter. Confirm that you are running Windows 11 or Windows 10 version 1903 or newer.

2
Download the WebView2 Runtime

Visit the official Microsoft Edge developer website and download the Microsoft Edge WebView2 Runtime installer.

3
Install and restart Excel

Run the downloaded executable to install WebView2. Once the installation is complete, restart your computer and open Excel to see if the feature appears.

Verify Windows OS and Install Microsoft Edge WebView2
Requirement Check: If you meet all system requirements but still don't see the feature, your Microsoft 365 update channel might be on a delayed release schedule.
Built-in OCR Alternative

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. 1. Open WPS Spreadsheet: Launch WPS Office and open a new blank spreadsheet or your existing workbook.
  2. 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. 3. Import and Convert: Upload your image file. WPS Office will automatically scan the picture and populate your spreadsheet cells with the extracted data.
Extract tables and text from images with high accuracy without needing extra runtimesFully compatible with Microsoft Excel (.xlsx) file formatsLightweight application that works smoothly on older Windows versionsFree to download with a familiar, easy-to-navigate tabbed interface
QA img-9

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.