How to Use Excel IQY Web Queries with Legacy Servers
Question details
The user needs to understand how Excel IQY files work to retrieve web data from legacy servers and how to troubleshoot connection limitations.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Importing data from legacy reporting systems (like Oracle Discoverer) into a spreadsheet when modern tools like Power Query cannot connect directly.
- Observed behavior
- IQY files use URLs and parameters to fetch HTML table data but may fail if the target server requires complex browser automation, authentication workflows, or JavaScript execution.
Ensure you have the exact URL and any required query parameters for the legacy system, and verify that the target endpoint outputs data in a standard, static HTML table format.
Test and Implement an IQY Web Query
Create and run a basic IQY file to pull HTML data directly from your legacy server into the spreadsheet.
Excel IQY files are simple plain-text files containing web query definitions. They are highly effective for pulling data from static HTML tables generated by legacy systems like Oracle Discoverer, especially as a workaround when Power Query cannot establish a direct connection.
Open a plain text editor like Notepad. Type the target legacy server URL along with any necessary query parameters on the first line.
Save the text file to your computer, ensuring you change the file extension from .txt to .iqy (for example, legacy_report.iqy).
Open your spreadsheet software, navigate to the 'Data' tab, and select 'Get Data'. Choose the option to import from a file or run a web query, and select your saved IQY file.
Once the web query dialog loads the page, select the specific HTML table you wish to import and click 'Load' to populate your worksheet.

Use Alternative Connections for Complex Servers
Bypass the limitations of IQY web queries by connecting directly to the legacy database using dedicated drivers or APIs.
How to Import Web Data Seamlessly in WPS Spreadsheet
If you need to retrieve HTML table data from external web pages without dealing with manual text files and legacy IQY configurations, WPS Spreadsheet offers a built-in 'Import Web Data' feature. This tool allows you to pull external web data directly into your worksheets easily.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing workbook where you want the external data to appear.
- 2. Access the Data Tab: Navigate to the 'Data' tab located on the top ribbon menu.
- 3. Select Import Web Data: Click on 'Import Data' and select the 'Import Web Data' option from the dropdown menu.
- 4. Enter the URL and Import: Paste the target URL of the web page containing your data table, navigate to the table in the preview window, and click 'Import' to load it into your selected cells.

Frequently Asked Questions
What exactly does an IQY file do in a spreadsheet?
An IQY (Web Query) file is a plain text file containing a web URL and parameters. It instructs the spreadsheet software to fetch data from standard HTML tables on a webpage and import it directly into a worksheet, saving you from manually copying and pasting.
Why is my IQY query not returning data from Oracle Discoverer?
If the legacy server requires interactive authentication, uses JavaScript to render its tables, or relies on a full browser session cookie, a basic IQY web query cannot process it. IQY files only read and interpret static HTML output.
Are there better alternatives to IQY for legacy reporting systems?
Yes. If IQY fails due to technical limitations, consider connecting directly to the database using an ODBC connection, utilizing dedicated database connectors, calling a REST API, or scheduling automatic CSV exports directly from the legacy system.
Can Power Query completely replace IQY files?
While Power Query is significantly more advanced for data transformation and modern web scraping, it sometimes struggles with specific legacy authentication protocols. In rare cases, simple IQY files can bypass these issues via basic URL parameters, making them a useful fallback for older systems.




