Excel for Mac Power Query Web Connector Not Showing
Question details
The user needs to determine why the Power Query Web connector is unavailable in Excel for Mac and how to access this feature.
- Product
- Microsoft Excel for Mac with Power Query
- Device & OS
- macOS
- Scenario
- The user has reinstalled Office or uses a supported Microsoft 365 subscription but cannot find the Power Query Web connector.
- Observed behavior
- The Get & Transform or Power Query Web connector does not appear in Excel for Mac under the Data tab.
Check your Excel subscription and build under Excel > About Microsoft Excel, then open the Data tab to confirm whether Get Data or Power Query commands are available.
Confirm the Power Query commands and Mac support status
Use this check to distinguish a missing command from a feature that is not supported in the Mac version of Excel.
Launch Excel for Mac and select the Data tab on the ribbon.
Check the Get Data, Get & Transform, or Power Query commands on the Data tab.
Choose Excel > About Microsoft Excel and confirm that you are signed in with the expected Microsoft 365 account and using an up-to-date build.
Run Power Query Web Connector in Excel for Windows
Use Excel for Windows when the Web connector is required for importing data from websites.
Use WPS Office as a Lightweight Alternative for Excel Workbooks
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong compatibility with Microsoft Excel workbooks. It can help you continue editing and sharing XLSX files on Mac, although it does not add Microsoft Power Query Web Connector support.
Frequently Asked Questions
Where should Power Query appear in Excel for Mac?
In supported Microsoft 365 versions, open the Data tab and look for Get Data, Get & Transform, or Power Query commands. The exact labels depend on the Excel build and available features.
Can reinstalling Excel for Mac enable the Web connector?
No. Reinstalling Office can repair installation problems, but it cannot add a connector that the Mac version of Excel does not support.
What is the practical workaround for the Power Query Web connector on a Mac?
Use Excel for Windows on another computer or in a Windows virtual machine such as Parallels, then select Data > Get Data > From Web.
Does a Microsoft 365 subscription guarantee the Web connector on Mac?
No. A Microsoft 365 subscription may provide Power Query commands, but connector availability can still vary by platform. Excel for Mac may not currently support the Web connector.
Can WPS Office replace Power Query Web Connector?
WPS Office can open and edit compatible Excel workbooks, including XLSX files, but it does not provide Microsoft Power Query Web Connector functionality.
