Fix Excel for Mac Web Query Returns No Data from IQY Files
Question details
The user is unable to import data into Excel for Mac using .iqy web query files, receiving an error that the query returned no data.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Importing external web data into a spreadsheet using an IQY file.
- Observed behavior
- Excel reports that the query returned no data, failing to import the expected web content.
Ensure your Mac is connected to the internet and verify that the target website is currently accessible in your standard web browser.
Verify the Target Website's HTML Table Structure
Web queries rely on specific HTML tags. If the website was updated, it might no longer support Excel's web query feature.
Excel web queries generally require the target data to be enclosed within standard HTML <TABLE> tags. Modern websites frequently update their underlying code to use dynamic frameworks or CSS grids instead of traditional tables.
If the website has recently changed its structure, the .iqy file will no longer be able to locate the data, resulting in a 'no data' error.
Open your web browser and navigate to the URL specified in your .iqy file.
Right-click on the data you want to import and select 'Inspect' or 'View Page Source'.
Press Cmd+F and search for '<table'. If there are no table tags surrounding your data, the web query will not work.

Restore a Previous Version of Excel for Mac
If the issue started immediately after an Office update, reverting to the previous build can help determine if the update caused the bug.
Try WPS Office for Seamless Data Management on Mac
Struggling with Excel for Mac web query errors? WPS Office offers a free, lightweight, and highly compatible alternative. With a familiar interface and robust spreadsheet tools, you can manage your data effortlessly without dealing with complex update bugs.
- 1. Download WPS Office: Visit the official WPS website and download the free version for Mac.
- 2. Install the application: Open the downloaded package and follow the prompts to install WPS Office on your Mac.
- 3. Open your spreadsheets: Launch WPS Spreadsheets and open your existing Excel files to continue working seamlessly.

Frequently Asked Questions
What is an IQY file in Excel?
An IQY (Internet Query) file is a simple text file used by Microsoft Excel to download data from the internet. It contains the URL of the target website and parameters instructing Excel to fetch specific data, typically formatted in HTML tables.
Why did my Excel web query suddenly stop working?
The most common reason a web query stops working is that the target website updated its design. If the website replaced traditional HTML <TABLE> tags with modern dynamic coding, Excel can no longer identify and extract the data.
Does clearing the Mac cache fix the Excel web query 'no data' error?
Usually, no. While clearing cache or creating a new user account can fix local corruption, a 'no data' error across multiple devices points to either a structural change on the target website or a specific bug introduced in a recent Excel update.




