'%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)
How to Fix Excel Import Data from Picture Grayed Out
Question details
The user is unable to use the 'Data from Picture' feature because the option is completely grayed out and unclickable.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to insert structured tabular data into a worksheet using an image or screenshot.
- Observed behavior
- The 'Data from Picture' button is disabled, preventing the user from extracting and importing data from images.
Ensure your device is connected to a stable internet network, as image-based data recognition requires online cloud processing to function.
Enable Optional Connected Experiences in Privacy Settings
Disabling data sharing during the initial Office installation turns off smart features. You must manually re-enable connected experiences to restore the Data from Picture capability.
Microsoft 365 relies on cloud-based AI to analyze images and extract data. If you declined optional data sharing for privacy reasons, Excel automatically disables these online-dependent tools.
Open Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.
Under the Account Privacy section, click the 'Manage Settings' button to open the privacy configuration dialog.
Scroll down to find the 'Optional connected experiences' section. Check the box that says 'Turn on optional connected experiences'.
Click 'OK' to save your changes, then completely close and reopen Excel to apply the new privacy settings.
Verify Microsoft 365 Subscription and Update Excel
The Import Data from Picture feature is exclusive to active Microsoft 365 Premium subscribers and is not available in older standalone versions.
Disable Conflicting Excel Add-ins
Certain third-party add-ins can interfere with Excel's native features. Temporarily disabling them can help isolate the problem.
Use WPS Spreadsheet to Convert Pictures to Tabular Data
If you are unable to restore Excel's feature or do not have a premium subscription, WPS Office provides a powerful, built-in OCR (Optical Character Recognition) tool. It accurately extracts data from images directly into your spreadsheet without requiring complex privacy configurations.
- 1. Open WPS Spreadsheet: Launch WPS Office on your device and create a new blank spreadsheet.
- 2. Access the OCR Tool: Navigate to the 'Tools' tab on the top ribbon menu and click on 'Picture to Text' or 'Screen Extract'.
- 3. Upload Your Image: Select the screenshot or image file containing the tabular data you want to import.
- 4. Review the Extracted Data: Wait a few seconds for the smart engine to process the image and display a preview of the recognized text and columns.
- 5. Insert into Spreadsheet: Click 'Save to Spreadsheet' to instantly format and insert the extracted data into your active worksheet.
Frequently Asked Questions
Why does the Data from Picture feature require internet access?
The feature uses Microsoft's cloud-based AI servers to analyze the image, detect tabular structures, and convert pixels into readable text. Without an active internet connection, Excel cannot perform this complex processing locally.
Is Import Data from Picture available in Excel 2019 or Excel 2021?
No. The Data from Picture functionality is a premium smart feature exclusive to Microsoft 365 subscriptions. It is not included in perpetual, one-time purchase versions of Office like 2019 or 2021.
I enabled Connected Experiences, but the feature is still missing. What else could be wrong?
If you are on an enterprise network, your IT administrator may have disabled connected experiences globally via Group Policy. Additionally, ensure your system language and regional settings are supported by the feature, as some languages are not yet compatible with the OCR engine.
