How to Open an IQY File in Excel and Load Web Data

How-to basics · Updated November 21, 2026

To open an IQY file in Excel for Microsoft 365 on Windows, choose File > Open > Browse, change the file-type filter to All Files if needed, select the .iqy file, and open it. Excel should use the file’s web-query instructions to retrieve data from its source; you may need to confirm a security prompt or sign in. An IQY file is a query definition, not a spreadsheet of results, so it needs a working internet connection and an accessible source.

What You’ll Need

  • Excel for Microsoft 365 desktop on Windows. Direct support for opening IQY files differs across Excel versions and platforms.
  • The .iqy file saved on your computer, and permission to access the website or server named in the query.
  • An internet connection. If the source requires an account, have the appropriate sign-in details ready.
  • A trusted copy of the file. An IQY query can contact an external website, so do not run one from an unknown sender without checking its source.

Step-by-Step

  1. Save the file locally. If the IQY file arrived as an email attachment or download, save it to a folder you can find, such as Downloads or Documents. Confirm that its full name ends in .iqy. Windows may hide known file extensions, so check the file’s Properties if you are unsure. Do not rename a different file type to .iqy; changing the extension does not convert the contents.
  2. Check that the file is from a source you trust. An IQY file can contain a web address and instructions that cause Excel to retrieve outside content. If you did not expect the file, ask the sender what site it connects to and what data it will return. You can inspect a copy with a plain-text editor to see whether it includes a URL, but do not edit unfamiliar query instructions casually. A URL that looks familiar does not by itself prove that the file is safe.
  3. Open Excel desktop. Start Excel for Microsoft 365 on Windows and open a blank workbook or another workbook if you prefer. Using Excel’s Open command makes it easier to choose the correct file type than relying on a Windows double-click association. If you have several Excel versions installed, opening Excel first also helps you use the version you intended.
  4. Browse to the IQY file. Select File > Open > Browse. In the Open dialog, navigate to the folder where you saved the file. If the file is not shown, use the file-type dropdown and choose All Files (*.*), or the equivalent All Files option. Select the .iqy file and choose Open. Do not select an Excel workbook just because it is in the same folder.
  5. Respond to Excel’s prompts carefully. Depending on the file and your security settings, Excel may warn that the query connects to external data, ask whether to enable content, or request credentials. Continue only if you recognize and trust the source. If Excel presents a sign-in window, use the account the website or organization expects. Avoid changing Trust Center settings to allow every external connection just to get past one warning.
  6. Wait for the query to run and inspect the result. Excel may take a moment to contact the website and load the returned data into a worksheet. The result may be a table or a range, depending on how the query was created. Check the column headings, a few sample rows, and any date or number formats. Compare the result with what you expected from the source before using it in calculations or reports.
  7. Save the result as an Excel workbook. An IQY file describes a query; it is not the usual format for keeping a workbook with sheets. Choose File > Save As, select a folder, and save as Excel Workbook (*.xlsx). Keep the original .iqy file as well if you may need it again. If Excel asks about preserving a connection or external data, read the message and choose the option that fits your need; after saving, confirm the workbook opens and the data is still there.
  8. Refresh later when you need updated data. If the saved workbook retains a refreshable connection, use Data > Refresh All to request the latest available result. You can also right-click the returned data and choose Refresh if that option is available. Refreshing contacts the source again, so the result may change or the connection may fail if the page, permissions, credentials, or network access have changed.

If Excel does not recognize the file through File > Open, try opening a trusted copy from File Explorer by right-clicking it and choosing Open with > Excel. This is an alternative, not a conversion method: if Excel still treats it as an unsupported file, use the troubleshooting steps below rather than forcing the extension or changing security protections.

Common Mistakes

  • Expecting the IQY file to contain the data. It generally stores instructions for retrieving data from a web source. If the source is offline or the query no longer works, the file alone may not provide a usable data table. Ask the sender for a current export such as an .xlsx or .csv file if you need a static copy.
  • Opening it in Excel for the web. Excel for the web is designed to open workbooks, not to act as a reliable direct importer for an IQY query file. Download the file and use Excel desktop on Windows where possible. A workbook created in desktop Excel may still open online, but refreshing its external connection there may not be supported.
  • Ignoring the file filter. The Open dialog may hide .iqy files because it is showing only workbook formats. Selecting All Files lets you locate the query file; it does not make an incompatible file compatible.
  • Allowing every external connection to run. An external-data warning is a security check, not an error to bypass automatically. Approve only a query from a source you trust, and do not turn off security controls globally.
  • Saving over the original or assuming results are live. Save the returned data as a separate .xlsx workbook and retain the IQY source. A worksheet can show a retrieved snapshot even when its connection later stops refreshing; check the refresh behavior before relying on it for recurring reports.

Tips

  • Keep the .iqy file, the saved .xlsx workbook, and any notes about the source together. A useful filename can include the source and retrieval date, such as WebsiteData-2026-11-03.xlsx.
  • After loading, use the worksheet’s column headings to identify what the query returned. Check whether dates are actual Excel dates or text, and whether values that look numeric have imported as text before sorting or calculating.
  • If you need a repeatable update, test Refresh All on a copy of the workbook first. Confirm that Excel can still reach the source and that a refresh does not replace manually added information beside or within the returned range.
  • If the query is part of a work process, ask the file’s owner whether the source requires a particular network, account, or permission. An IQY file cannot grant access that your account does not have.
  • On a Mac, Excel’s available external-data features and the handling of existing IQY files can differ by version. If the file does not open as a query, try a Windows desktop version of Excel or request that the sender provide the results as .xlsx or .csv.

Troubleshooting

The IQY file does not appear in the Open dialog. Check that you are browsing the right folder and set the file-type filter to All Files. Verify the extension in File Explorer: right-click the file, choose Properties, and check its name and type. If the actual name ends in .iqy.txt, it is a text file with an extra extension; renaming should only be considered after confirming that the contents really are an IQY query.

Excel says it cannot open the file or the format is not supported. Confirm that you are using Excel desktop on Windows and that the file is a genuine IQY file rather than a web page, shortcut, or renamed text document. Try a current Microsoft 365 update if your organization permits it. If it still fails, ask the sender to recreate the query or send the returned data as an Excel workbook or CSV. Do not change the file extension repeatedly in the hope that Excel will convert it.

The query is blocked or Excel shows a security warning. First verify the source and ask your organization’s IT administrator if the file came from work. Company policy can block external data connections. Excel’s Trust Center controls may affect external-content behavior, but changing them can weaken protection for other files too; do not broadly enable connections or lower security settings without authorization. A file downloaded from the internet may also be marked as coming from another computer. Follow your organization’s safe-file process rather than unblocking an unknown query.

The query opens but returns an error, blank data, or a sign-in page. Check your internet connection and whether the URL is still available in a browser. A website may have changed its layout, moved the data, started requiring a login, or stopped supporting the query format. If a sign-in is requested, use the correct account only when you trust the destination. If the site requires a method the query cannot supply, the file’s owner may need to provide a replacement query or export.

Refresh fails after the first successful load. In the saved workbook, try Data > Refresh All and note the exact error. Check whether you are connected to the required work network or VPN, and whether your credentials have expired. If you moved or renamed the workbook, that usually should not change the web address in the query, but access policies or the source itself may have changed. Contact the query owner or IT support with the error text rather than repeatedly approving prompts.

Frequently Asked Questions

What is an IQY file?
An IQY file is a web query file that tells compatible spreadsheet software how to request data from a web source. It is not normally a workbook containing a complete set of results. Excel uses its instructions to retrieve data when the query can connect and is allowed to run.

Can I open an IQY file by double-clicking it?
Sometimes, if Windows associates .iqy files with Excel, double-clicking may launch Excel and process it. If it opens in a text editor, prompts for an app, or does nothing useful, open Excel first and use File > Open > Browse instead. The exact behavior depends on Windows file associations and security settings.

Can I open an IQY file in Excel for Mac?
Support for directly opening existing IQY files is not consistent across Mac Excel versions. If the file is not recognized, use Excel desktop on Windows or ask the sender to provide an .xlsx or .csv export. Excel for the web is not a dependable substitute for importing the IQY file directly.

Will the data update automatically?
Not necessarily. The first load retrieves data, but later updates depend on whether the saved workbook retains a working connection and whether Excel is configured and permitted to refresh it. Use Data > Refresh All when you want to request an update, then check the returned values and any error messages.

Can I convert an IQY file to XLSX?
You do not usually convert the IQY file itself. Open it in compatible desktop Excel, let the query retrieve its data, and save the resulting workbook with File > Save As > Excel Workbook (*.xlsx). Keep the original IQY file if you want to retain the query instructions separately.

Is it safe to open an IQY file?
It depends on who supplied it and which external source it contacts. Treat it like a file that can initiate an outside connection: confirm its origin, inspect the destination if appropriate, and approve prompts only when you trust the query. If uncertain, ask for a static .xlsx or .csv copy instead.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.