'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Why Excel Is Missing the Insert Data from Image Feature and How to Fix It
Question details
The user cannot find the Insert Data from Image feature in their Excel installation and needs to know which version or update enables it.
- Product
- Excel for Microsoft 365 Apps for Enterprise
- Device & OS
- Windows 10
- Scenario
- Trying to use the Insert Data from Image function to quickly extract tabular data from a picture into a spreadsheet.
- Observed behavior
- The feature is completely missing from the Excel ribbon interface, despite the user expecting it to be available in their Microsoft 365 Apps for Enterprise version.
Ensure your computer has an active internet connection, as updating Microsoft 365 and verifying connected cloud experiences both require online access.
Update Microsoft 365 Apps to the Latest Version
Manually trigger an update to ensure you have the latest features released for your specific Microsoft 365 update channel.
Microsoft releases features gradually across different update channels. If you are on an enterprise channel, you might be running a slightly older build that does not yet include the Insert Data from Image functionality.
Launch Microsoft Excel and open a blank workbook. Click on the 'File' tab in the top left corner, then select 'Account' from the menu on the bottom left.
Locate the 'Product Information' section on the right side of the screen and click on the 'Update Options' dropdown menu.
Select 'Update Now'. Excel will check for and download any pending updates. Restart Excel once the update process is complete to see if the feature appears.
Verify Connected Experiences and Administrator Policies
If updating does not restore the feature, your organization's IT policies or your privacy settings might be restricting access to cloud-based tools.
Extract Data from Images Easily with WPS Office
If Microsoft 365 updates are restricted by your organization or you are tied to a slow update channel, consider switching to WPS Office. WPS offers powerful built-in OCR (Optical Character Recognition) to quickly convert images into editable spreadsheets without the hassle of complex enterprise policies.
Frequently Asked Questions
Which versions of Excel support the Insert Data from Image feature?
This feature is available in Microsoft 365 subscriptions for Windows and Mac, as well as Excel for the Web. It is generally not available in older standalone perpetual versions like Office 2016 or Office 2019.
Why is the Data from Picture button greyed out in my Excel ribbon?
This usually occurs if your privacy settings restrict cloud connectivity. You can fix this by going to File > Account > Manage Settings, and enabling 'Turn on optional connected experiences'.
Can I extract data from an image if my IT admin blocks the Excel feature?
Yes. If your enterprise policies block Microsoft's cloud services, you can use a free alternative like WPS Spreadsheet, which features built-in Picture to Text and Picture to Table OCR tools to achieve the exact same result.
