Data Import & Export

Fix an HTML Web Query File in Excel 2019 for Mac

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Run a saved HTML web query in Excel 2019 for Mac to retrieve webpage tables.

Product
Microsoft Excel 2019 for Mac
Device & OS
Mac, macOS version not provided
Scenario
The user wants to select a saved web query file and import data from a webpage.
Observed behavior
Excel disables the saved query file when it has a TXT extension, while From HTML may import the webpage address as text instead of retrieving tables.
Before you start

Locate the saved web query file in Finder and check that it contains a valid web query, not just an arbitrary text document. Only run queries from sources you trust.

Solution 1Recommended

Change the web query file extension from TXT to IQY

Use this method when Excel disables a saved web query because its filename ends in TXT.

Excel recognizes IQY as a web query file extension. Renaming a file changes its extension but does not turn arbitrary text into a valid web query.

1
Open file information

In Finder, select the saved query file and choose File > Get Info.

2
Change the extension

Under Name & Extension, replace .txt with .iqy, then confirm Use .iqy if Finder asks.

3
Run the query in Excel

In Excel, open the Run Web Query dialog, select the renamed .iqy file, and run it to retrieve the webpage data.

Change the web query file extension from TXT to IQY
Check the query contents: If the file still cannot run, check that its contents form a valid web query and that the target page is accessible.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files to move your spreadsheet work across without rebuilding it. WPS does not fix Excel's web query dialog.

Open and edit Microsoft Excel XLS and XLSX filesReview and work with spreadsheet data in WPS SpreadsheetUse a familiar interface for a smoother move from Microsoft OfficeGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is my web query file disabled in Excel for Mac?

Excel may not recognize the saved query when it has a .txt extension. In Finder, use File > Get Info to change the extension to .iqy, then select it in Excel's Run Web Query dialog.

Can I rename any TXT file to IQY and run it?

No. Changing the extension does not create a valid web query. The file must already contain a valid query for the target webpage.

What if From HTML imports the webpage address as text?

Instead of using From HTML on the address as text, open Excel's Run Web Query dialog and select the saved .iqy query file.

Does WPS Office fix the Run Web Query dialog in Excel?

No. The dialog is part of Microsoft Excel. WPS Office is an alternative for opening and editing compatible XLS and XLSX spreadsheets.