'%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)
Fix Get Data Disabled in Excel for the Web
Question details
The user needs to know why the Get Data function is unavailable in the browser version of Excel and how to enable or bypass it.
- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to import external data or connect to web sources using a browser-based Excel workbook.
- Observed behavior
- The Get Data command is grayed out, disabled, or completely missing from the Data ribbon.
Verify that your Microsoft 365 subscription includes access to the desktop version of Excel, as you will likely need to switch from the browser app to the full Windows application.
Switch to the Excel Desktop App for Windows
Because Excel for the Web and Excel for Mac do not support all Power Query connectors, using the Windows desktop app is the primary method to access all Get Data features.
Many advanced data-import features and connectors require the full Excel desktop environment for Windows. These features are intentionally disabled in the browser version due to platform limitations.
Launch the Microsoft Excel desktop application on a Windows PC.
Create a new blank .xlsx workbook or open the specific file you were trying to edit on the web.
Click on the 'Data' tab located in the top ribbon menu.
Click on 'Get Data' and select your preferred connector, such as 'From Web' or 'From Database', which should now be fully active.
Verify Microsoft 365 License and Admin Settings
If the feature remains disabled even in the desktop app, it may be restricted by your organization's IT policies or your specific Microsoft 365 license.
Try WPS Office for a Powerful Desktop Spreadsheet Experience
If you are frustrated by the feature limitations of web-based spreadsheet apps, WPS Office provides a robust, desktop-level alternative for free. Enjoy powerful data management without expensive subscription tiers.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Install the software: Run the installer and follow the quick on-screen instructions to set up the software on your computer.
- 3. Open WPS Spreadsheets: Launch WPS Spreadsheets, open your Excel files, and manage your data with comprehensive desktop tools.
Frequently Asked Questions
Why is the Get Data from Web command missing in Excel for Mac?
Excel for Mac does not yet support the full range of Power Query and Get Data connectors available in the Windows version. While Microsoft is gradually rolling out new data features to Mac users, you may still need a Windows PC or virtual machine for certain advanced data imports.
Can I refresh existing data connections in Excel for the Web?
Yes, Excel for the Web allows you to refresh certain types of existing data connections that were previously configured in the desktop app. However, creating new, complex data connections directly in the browser is generally restricted.
Does Power Query work in Excel online?
Power Query functionality in Excel for the Web is currently very limited. To utilize full Power Query capabilities—such as creating, editing, and merging advanced data queries—you must use the full Excel desktop application for Windows.
