Fix Excel for Mac Power Query That Returns Only a URL
Question details
The user needs to resolve an issue in Excel for Mac version 16.36 where Power Query returns only the URL from a TXT or IQY file instead of importing the webpage data.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS (Excel for Mac version 16.36)
- Scenario
- The user is trying to import webpage data from a TXT or IQY file into Excel for Mac by using Power Query.
- Observed behavior
- Power Query returns only the URL stored in the file instead of importing the external webpage data because Power Query support for external web data sources was limited on Mac at that time.
Confirm your Excel for Mac version and identify whether the source is a TXT or IQY web query file. If you only need the data loaded into the worksheet grid, prepare an available ODBC data source that can connect to the supported external data.
Import Supported Data with an ODBC Connection in Excel for Mac
Use this when you only need the data placed into a regular Excel worksheet and your source has an available ODBC driver.
Power Query for external web data was not supported in Excel for Mac 16.36, but ODBC data connections can bring supported data into the Excel grid. ODBC imports use the regular worksheet row and column limits.
In Excel for Mac, go to the Data tab and locate the Get External Data or ODBC connection option.
Select the ODBC connection that matches your supported external data source, then follow the connection dialog to authenticate.
Choose the table or query result to import, select the destination worksheet, and confirm the import to place data into the Excel grid.

Use Windows Excel for Web Data Transformation or Vote for the Feature Request
Use this if you need full Power Query transformation of webpage data, because Excel for Mac 16.36 cannot perform it.
Use WPS Office as a Free, Lightweight Excel Alternative
If Excel for Mac Power Query still blocks your web data workflow, WPS Office offers a free, lightweight way to open and edit Excel files with familiar spreadsheet tools, strong Microsoft Office format compatibility, and seamless migration from Excel for Mac.
- 1. Download WPS Office: Go to the WPS Office download page and click Download WPS Office Free to install it on your Mac or Windows PC.
- 2. Open your Excel file in WPS Spreadsheets: Launch WPS Office, open WPS Spreadsheets, and open the .xlsx or .csv file you need to continue editing.
- 3. Use familiar spreadsheet tools: Use the ribbon-based formulas, filters, and data tools to work with your data without subscription restrictions.

Frequently Asked Questions
Why does Excel for Mac Power Query return only a URL?
Excel for Mac version 16.36 had limited Power Query support for external web data sources. A TXT or IQY file may expose only the stored URL instead of importing the webpage data.
Can I import data from a TXT or IQY file on Mac without Power Query?
You can use an available ODBC connection to import supported data into the regular Excel grid. This loads data into worksheet rows and columns, so it has row and column limits and does not replace web data transformation.
Does WPS Office include Power Query for web queries?
WPS Office is not a direct fix for Microsoft Excel's Power Query limitation, but it can open and edit Excel files as a free alternative for everyday spreadsheet work.
Which Excel version can import webpage data with Power Query?
Use a supported Windows version of Excel to perform full Power Query import and transformation from web data sources.




