Office Compatibility Issues

Why is the Data from Picture Feature Missing in Excel 2019?

Olivia Miller Oct 12, 2026 868 views

Question details

The user is trying to find the Data from Picture tool to convert image data into an Excel table, but the feature is completely absent from the ribbon.

Why the Data from Picture Feature is Missing in Excel 2019

Product: Microsoft Excel 2019
Device & OS: not provided
Scenario: Attempting to extract tabular data from an image directly into a spreadsheet.
Observed behavior: The Data from Picture button cannot be found anywhere under the Data tab or ribbon menus in Excel 2019.

Before you start

Verify your exact Microsoft Office version by navigating to File > Account in Excel to confirm whether you are using the standalone Office 2019 or a Microsoft 365 subscription.

Solution 1Recommended

Upgrade to a Microsoft 365 Subscription

The most direct way to get the feature natively in Excel is to switch from a standalone version to the subscription-based Microsoft 365.

The 'Data from Picture' feature relies on cloud-based AI processing and is exclusive to Microsoft 365. It is not included in standalone perpetual licenses like Office 2019 or Office 2021. Upgrading to a subscription unlocks this feature for desktop use.

Choose a Subscription

Visit the official Microsoft website and select a Microsoft 365 Personal or Family subscription plan.

Install the Update

Download and install the Microsoft 365 apps. Once installed, sign in with your subscribed Microsoft account.

Access the Feature

Open Excel, go to the 'Data' tab on the ribbon, and click 'From Picture' in the 'Get & Transform Data' group.

Version Requirement: You must be running Microsoft 365 build 15227.20000 or later to access this feature on Windows.

Solution 2

Use the Microsoft Office Mobile App Workaround

If you do not want to purchase a Microsoft 365 subscription, you can use the free mobile app to extract data from pictures and sync it to your PC.

Free Microsoft Office alternative

Extract Data from Images for Free with WPS Office

Since Excel 2019 lacks the Data from Picture feature, consider switching to WPS Office. As a free, lightweight, and highly compatible alternative to Microsoft Office, WPS Spreadsheet includes built-in OCR tools to instantly convert images into editable tables—no expensive subscription required.

1. Install WPS Office: Download and install the free WPS Office suite on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open any existing .xlsx files.
3. Use the OCR Feature: Navigate to the 'Tools' tab and use the 'Picture to Text' feature to seamlessly convert image data into your spreadsheet.

Seamless format compatibility with Microsoft Excel (.xlsx, .xls, .csv).Built-in Picture to Text and OCR technology to easily extract tabular data from images.Free, lightweight, and uses significantly fewer system resources.Familiar user interface ensuring a seamless migration with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I add the Data from Picture feature to Excel 2019 via an add-in?

No, the native Data from Picture feature relies on proprietary cloud-based AI processing exclusive to Microsoft 365. While third-party OCR add-ins may exist, the official Microsoft feature cannot be patched or downloaded into Office 2019.

Is the Data from Picture feature available in Office 2021?

No. Similar to Office 2019, Office 2021 is a perpetual (one-time purchase) license. Microsoft has kept the Data from Picture feature exclusive to their premium Microsoft 365 subscription service.

Where is the Data from Picture feature located in supported Excel versions?

If you are using an updated Microsoft 365 subscription, open your Excel workbook, click on the 'Data' tab on the top ribbon, and look for the 'From Picture' button located in the 'Get & Transform Data' section.

Office App Problems