Office Compatibility Issues

Why Excel 2019 Is Missing the Data from Picture Feature

Chanuka Geekiyanage Oct 16, 2026 868 views

Question details

The user is attempting to use the Insert Data from Picture feature but cannot find it on the Excel ribbon.

Why Excel 2019 Is Missing the Data from Picture Feature

Product: Microsoft Excel 2019
Device & OS: not provided
Scenario: Trying to extract data from an image and insert it directly into a spreadsheet.
Observed behavior: The Data from Picture tool is missing from the Excel interface because Excel 2019 is a perpetual license product and does not support this newer Microsoft 365 feature.

Before you start

Verify your exact Office version by opening Excel and navigating to File > Account to check the Product Information section.

Solution 1Recommended

Upgrade to a Supported Microsoft 365 Version

The Data from Picture feature is exclusive to Microsoft 365 subscribers and is not available in perpetual licenses like Excel 2019.

Excel 2019 and Microsoft 365 are separate products. Because Excel 2019 is a perpetual (one-time purchase) product, it only includes the features available at its initial release. It does not receive new feature updates like Data from Picture, which require Microsoft's cloud services.

Check current license

Open Excel, click on 'File', and select 'Account'. Look under 'Product Information' to confirm whether your license is Excel 2019 or Microsoft 365.

Upgrade to Microsoft 365

If you are using Excel 2019, you must purchase and install a Microsoft 365 subscription from the official Microsoft website to access cloud-based features.

Use Data from Picture

Once you have installed a supported Microsoft 365 version, go to the 'Data' tab on the ribbon, click 'From Picture', and select an image to extract your data.

Upgrade to a Supported Microsoft 365 Version

Version Requirements: Ensure you are using the latest build of Microsoft 365 on Windows or Mac, and that you have an active internet connection, as the feature requires online services to process the image.

Try WPS Office

Easily Extract Data from Pictures Using WPS Office

WPS Office Spreadsheet includes a powerful built-in OCR feature that allows you to extract tables and text from images directly into your worksheet, without needing a premium Microsoft 365 subscription.

1. Download and open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet.
2. Access the OCR tool: Navigate to the 'Tools' tab on the top ribbon and select 'Picture to Table' or 'Picture to Text'.
3. Upload your image: Select the picture containing the data you want to extract from your local files or clipboard.
4. Convert and insert: Click 'Convert'. WPS will automatically recognize the table structure and insert the data directly into your spreadsheet cells.

Free and lightweight Office suiteBuilt-in Picture to Text and Picture to Table OCR toolsFully compatible with Microsoft Excel (.xlsx) formatsAvailable on Windows, Mac, iOS, and Android

microsoft office alternative - wps office

Frequently Asked Questions

Can I get the Data from Picture feature in Excel 2019 via an update?

No. Excel 2019 is a perpetual version that only receives security and bug-fix updates. It does not receive new feature updates like Data from Picture.

What versions of Excel support Insert Data from Picture?

This feature is currently available to Microsoft 365 subscribers using Excel for Windows, Excel for Mac, and Excel for the web.

Why do I not see the feature even if I have a Microsoft 365 subscription?

If you have an active Microsoft 365 subscription but still do not see the feature, ensure you have installed the latest Office updates via File > Account > Update Options, and verify that you are signed in with the correct subscription account.

Are there any free ways to extract data from an image to Excel?

Yes. You can use free alternatives like WPS Office, which has built-in Picture to Table OCR capabilities, or use various online image-to-Excel converter tools to generate a compatible spreadsheet file.

Office App Problems