How to Restore Data from Picture in the Excel Ribbon

Diagnosing the Missing Data from Picture Feature

When you rely on extracting tables from screenshots, receipts, or scanned documents, a missing image extraction tool abruptly halts your productivity. The function that converts images to spreadsheet cells is highly specific and depends entirely on cloud-based AI services. If you are looking for restoring Data from Picture in the Excel Ribbon, the root cause almost always falls into one of three categories: restrictive privacy settings blocking cloud access, an accidental removal from your interface configuration, or an incompatible software license. This guide provides the exact diagnostic steps to reactivate the command.

Enabling Microsoft Connected Experiences

Because the image extraction tool relies on remote servers to analyze the text and structure of your picture, it requires your local software to communicate with external cloud services. If your privacy settings restrict this communication, the command will vanish entirely. Adjusting your Trust Center settings is the first required step when figuring out restoring Data from Picture in the Excel Ribbon.

1. Open your spreadsheet application and click File in the top-left corner of the window.
2. Select Options at the bottom of the left-hand navigation pane.
3. In the resulting dialog box, select Trust Center from the left menu.
4. Click the Trust Center Settings button located on the right side of the panel.
5. Navigate to Privacy Options in the new window, then click the Privacy Settings button.
6. Scroll down to the section labeled Experiences that analyze your content.
7. Check the box next to Turn on experiences that analyze your content.
8. Scroll further down to All connected experiences and ensure the box for Turn on all connected experiences is also checked.
9. Click OK on all open dialog boxes and restart the application.

Once the software reboots, navigate to the Data tab. In most cases, the extraction button will automatically reappear in the "Get & Transform Data" group. If the cloud connection is active but the button is still hidden, proceed to manual interface customization.

Customizing the Interface to Reveal the Command

Sometimes the underlying tool is fully functional but has simply been removed from your active view. This frequently happens after an update or if you are using a shared workstation. You can manually force the command back into your workspace. Following these interface modification steps is the most direct method for restoring Data from Picture in the Excel Ribbon.

1. Right-click anywhere on the empty gray space of your upper toolbar and select Customize the Ribbon from the context menu.
2. In the Excel Options window that opens, look at the right-hand column titled Customize the Ribbon and ensure Main Tabs is selected in the dropdown menu.
3. Expand the Data tab by clicking the + icon next to it.
4. Click the New Group button below the list to create a custom grouping. Right-click this new group, select Rename, and type "Image Extraction".
5. Move your attention to the left-hand column titled Choose commands from and select All Commands from the dropdown menu.
6. Scroll down the alphabetical list until you find Data from Picture.
7. Select Data from Picture, ensure your newly created "Image Extraction" group is highlighted on the right, and click the Add >> button in the middle.
8. Click OK to save your changes.

Navigate to your Data tab. You will now see your custom "Image Extraction" group housing the restored button. Click it to immediately launch the file selection dialog and begin converting your images.

Verifying Your Software License

If the command is entirely missing from the "All Commands" list during customization, you are facing a licensing limitation. The ability to extract tabular data from images is an exclusive feature of the Microsoft 365 subscription model. Standalone perpetual licenses, such as Office 2019 or Office 2021, do not contain the necessary code for this feature, regardless of how you configure the interface. To verify your current license, go to File, select Account, and review the information under Product Information. If it does not explicitly say "Microsoft 365", no amount of troubleshooting will enable the native tool.

Extracting Data from Images Using WPS Office

If your current license does not support cloud-based extraction, you can bypass the native constraints by switching to WPS Office. Rather than spending time working to restore Data from Picture in the Excel ribbon on an unsupported version, you can leverage WPS Spreadsheet's built-in Optical Character Recognition (OCR) tools. WPS Office natively integrates document scanning and data conversion without requiring an enterprise-tier cloud subscription.

1. Open your workbook in WPS Spreadsheet.
2. Navigate to the Tools tab located on the upper toolbar.
3. Click the Picture to Text button (or OCR depending on your regional version).
4. In the prompt that appears, click Select Image and browse your computer for the screenshot or scanned file containing your table.
5. Once the image loads in the preview window, select the Convert to Excel option at the bottom of the dialog.
6. Review the preview to ensure the columns align correctly with your image data.
7. Click Extract. WPS Office will process the image locally and insert the structured data directly into your active worksheet cells.

This alternative workflow provides the exact same result—turning static pixels into editable spreadsheet columns—without forcing you into a subscription upgrade or requiring complex privacy configuration changes.

Use Word, Excel, and PPT for FREE

Free Download

Frequently Asked Questions

Why is the extraction tool grayed out even after I add it to the interface?

A grayed-out command indicates that the application recognizes the tool but cannot currently execute it. This almost always means your computer has lost its active internet connection, or a firewall is blocking the software from reaching the external analysis servers. Verify your network connection and ensure no security software is restricting the application's outbound traffic.

Does the image data extraction process work without an internet connection?

No. The native extraction feature relies entirely on remote machine learning models to identify text characters and table borders. It does not perform local processing. If you are offline, the feature will not function, and you must wait until you reconnect to a network to convert your images.

Which file formats are recognized by the spreadsheet extraction tool?

The tool natively supports standard raster image formats, primarily JPG, JPEG, PNG, and BMP. It cannot directly extract tables from vector files like SVG or document formats like PDF. If your data is trapped in a PDF, you must first take a screenshot of the table and save it as a PNG or JPG before utilizing the command.

Is the extraction feature available on macOS versions of the software?

Yes, the command is available on macOS, provided you are running an updated version of Microsoft 365 for Mac. You can access it by going to the Data tab or by clicking Insert, selecting Pictures, and choosing the "Data from Picture" option. The same cloud connectivity and privacy setting requirements apply to the Mac environment.