Data Import & Export

How to Use Excel IQY Web Queries with Legacy Servers

Olivia MillerOlivia Miller Oct 20, 2026 871 views

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.

How to Use Excel IQY Web Queries with Legacy Servers
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the IQY File

Open a plain text editor like Notepad. Type the target legacy server URL along with any necessary query parameters on the first line.

2
Save with the Correct Extension

Save the text file to your computer, ensuring you change the file extension from .txt to .iqy (for example, legacy_report.iqy).

3
Import into the Spreadsheet

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.

4
Select the Target Table

Once the web query dialog loads the page, select the specific HTML table you wish to import and click 'Load' to populate your worksheet.

Test and Implement an IQY Web Query
Limitations of IQY Files: IQY files are not full browser automation frameworks like Selenium. If the legacy server requires an interactive browser session, complex authentication workflows, or JavaScript execution to render tables, the IQY query will likely fail.

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. 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing workbook where you want the external data to appear.
  2. 2. Access the Data Tab: Navigate to the 'Data' tab located on the top ribbon menu.
  3. 3. Select Import Web Data: Click on 'Import Data' and select the 'Import Web Data' option from the dropdown menu.
  4. 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.
Easily import web tables directly into your spreadsheet without writing code or formatting text files.Fully compatible with Microsoft Excel document formats (.xlsx, .xls, .csv).Lightweight application that processes external datasets quickly and smoothly on any system.
QA img-9

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.