Data Import & Export

Fix Excel for Mac Web Query Returns No Data from IQY Files

Amos GikundaAmos Gikunda Oct 28, 2026 869 views

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.

How to Fix Excel for Mac Web Query Returning No Data from IQY Files
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.
Before you start

Ensure your Mac is connected to the internet and verify that the target website is currently accessible in your standard web browser.

Solution 1Recommended

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.

1
Open the URL in a browser

Open your web browser and navigate to the URL specified in your .iqy file.

2
Inspect the page source

Right-click on the data you want to import and select 'Inspect' or 'View Page Source'.

3
Search for table tags

Press Cmd+F and search for '<table'. If there are no table tags surrounding your data, the web query will not work.

Verify the Target Website's HTML Table Structure
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free version for Mac.
  2. 2. Install the application: Open the downloaded package and follow the prompts to install WPS Office on your Mac.
  3. 3. Open your spreadsheets: Launch WPS Spreadsheets and open your existing Excel files to continue working seamlessly.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight application that runs smoothly on all macOS versionsFamiliar user interface with zero learning curveBuilt-in robust data management and analysis tools
microsoft office alternative - wps office

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.