Data Import & Export

How to Fix Missing Get Data from Picture in Excel Version 2407

Maira Mehtab Sep 27, 2026 873 views

Question details

The user is trying to locate and use the Get Data from Picture command, but it is currently missing from the Excel interface.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to extract data or tables from an image using the Get Data from Picture feature in Excel version 2407.
Observed behavior: The Get Data from Picture feature is completely missing or not visible on the Data tab due to potential account, region, or settings restrictions.

Before you start

Ensure you have an active internet connection, as Microsoft's image recognition services require an online connection to process and extract data from your pictures.

Solution 1Recommended

Verify Account and Connected Experiences Settings

The Get Data from Picture feature requires a Microsoft 365 subscription and connected experiences to be actively enabled in your privacy settings.

Microsoft restricts certain cloud-based features if privacy settings disable optional connected experiences. Checking these settings often resolves missing feature issues.

Check Account Subscription

Open Excel, click on 'File', and select 'Account'. Verify that your product information displays a Microsoft 365 Subscription.

Open Privacy Settings

Under the Account menu, click on the 'Manage Settings' button located in the Account Privacy section.

Enable Connected Experiences

Scroll down to 'Optional connected experiences', check the box to turn them on, and click 'OK'. Restart Excel for the changes to take effect.

Regional Restrictions: If the feature is still missing, your computer's region settings may not support it yet. Ensure your Windows region is set to a supported locale (like the United States).

Solution 2

Update or Repair Microsoft 365

Installing the latest updates or repairing the Office installation can restore missing ribbon commands and fix corrupt files.

Smart OCR Tool

Extract Data from Pictures Instantly with WPS Office

If you are struggling with missing features or subscription restrictions in Microsoft Excel, WPS Office provides a built-in, highly accurate Picture-to-Excel OCR tool. You can easily convert image-based tables directly into editable spreadsheets for free.

1. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet or open an existing workbook.
2. Access the OCR Tool: Navigate to the 'Tools' tab on the ribbon and click on the 'Picture to Text' or 'Picture to Excel' option.
3. Upload and Convert: Select the image containing your data. WPS will automatically recognize the table layout and insert the editable data directly into your current sheet.

Built-in smart OCR for converting pictures to editable tables instantlyFully compatible with Microsoft Excel (.xlsx, .xls) document formatsNo complex privacy settings or connected-experience configurations requiredLightweight, fast, and free to download

microsoft office alternative - wps office

Frequently Asked Questions

Why is 'Get Data from Picture' missing from my Data tab?

This feature may be hidden if you are not signed in with a Microsoft 365 account, if 'Optional connected experiences' are disabled in your Trust Center privacy settings, or if your Office installation needs an update.

Is Get Data from Picture available in Excel 2019 or 2021?

No, the Get Data from Picture feature is exclusive to Microsoft 365 subscribers. Standalone perpetual versions like Office 2019 and Office 2021 do not include this cloud-based tool.

Can I manually add the Get Data from Picture button to the ribbon?

Yes. If the feature is supported by your license but just hidden, you can go to 'File' > 'Options' > 'Customize Ribbon', select 'All Commands', find 'Data from Picture', and add it to your preferred tab.

Excel & Data Problems