How to Restore Missing Data from Picture Feature in Excel for Mac
Question details
The user needs to restore or find a workaround for the 'Data from Picture' command that is missing from the Excel for Mac ribbon.
- Product
- Microsoft Excel for Mac
- Device & OS
- Mac
- Scenario
- Trying to extract data from an image into a spreadsheet, but the necessary command button is absent from the Insert tab or ribbon.
- Observed behavior
- The 'Data from Picture' command does not appear on the ribbon, even after reinstalling Microsoft 365, removing other commands, or attempting to customize the ribbon interface.
Ensure you have an active Microsoft 365 subscription, as 'Data from Picture' is a premium feature, and check that your macOS and Excel applications are updated to their latest versions.
Assign a Custom Keyboard Shortcut
Bypass the missing ribbon button by creating a custom keyboard shortcut to access the feature directly from the tools menu.
Even when the command is missing from the main visual ribbon, the underlying function often remains accessible through the application's core command list. Assigning a dedicated shortcut key is the most reliable workaround.
Launch Excel for Mac, navigate to the top Apple menu bar, click on 'Tools', and select 'Customize Keyboard'.
In the 'Categories' list on the left, select 'Insert'. In the 'Commands' list on the right, find and select 'Picture From File' or 'Data from Picture'.
Click inside the 'Press new keyboard shortcut' box, press your preferred key combination (e.g., Command + Shift + P), and click 'Assign'.
Click 'OK' to save your changes. Return to your spreadsheet and press your new keyboard shortcut to trigger the image extraction tool.
Add the Command to the Quick Access Toolbar
Pin the feature to the very top of your Excel window so it is always accessible regardless of the ribbon's status.
Update Excel to the Latest Available Version
Microsoft frequently releases software patches that fix missing ribbon commands and user interface bugs.
Easily Extract Data from Images Using WPS Office
If Excel for Mac is missing the Data from Picture feature, WPS Office provides a robust, built-in 'Picture to Text/Table' tool to instantly convert image data into editable spreadsheets.
- 1. Open WPS Spreadsheets: Launch WPS Office on your Mac and create a new blank workbook or open an existing file.
- 2. Access the OCR tool: Navigate to the 'Tools' tab on the top ribbon and click on 'Picture to Text' or 'Picture to Table'.
- 3. Upload your image: Select the image file from your Mac or take a direct screenshot of the data you want to extract.
- 4. Convert to spreadsheet: Click 'Convert' to let the OCR engine process the image and automatically populate your spreadsheet cells with the extracted data.
Frequently Asked Questions
Why is the Data from Picture feature missing in my Excel for Mac?
This feature requires an active Microsoft 365 subscription and an internet connection. It may also disappear due to temporary UI bugs, an outdated application version, or phased regional feature rollouts by Microsoft.
Does the Data from Picture tool work on older macOS versions?
No, the feature generally requires macOS Catalina or later. Ensure your operating system meets the minimum requirements for the latest Microsoft 365 intelligent features.
Can I extract data from an image on a Mac without using Excel?
Yes, Apple's built-in Live Text feature in macOS Monterey and later allows you to highlight and copy text or basic tables directly from images in the Preview or Photos app, which you can then paste into any spreadsheet.
How do I submit feedback to Microsoft about this missing feature?
You can report missing features directly to the developers by opening Excel, clicking on 'Help' in the top menu bar, and selecting 'Feedback'. Choose 'I don't like something' to detail the missing button issue.
