Fix an HTML Web Query File in Excel 2019 for Mac
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.
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.
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.
In Finder, select the saved query file and choose File > Get Info.
Under Name & Extension, replace .txt with .iqy, then confirm Use .iqy if Finder asks.
In Excel, open the Run Web Query dialog, select the renamed .iqy file, and run it to retrieve the webpage data.

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.

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.




