Fix Excel Power Query IQY Files Saved with a TXT Extension
Question details
The user needs to correct an IQY web query file that was saved with a .txt extension so Excel can recognize and run it as a Power Query web query.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- A user saved a web query file from a text editor and Windows appended .txt to the IQY extension, producing a file named MTUM.iqy.txt.
- Observed behavior
- Excel cannot recognize the file as an IQY web query because the visible extension is .txt instead of .iqy.
Make sure you can see the full file name in File Explorer. Open the folder containing the IQY file and note the exact file name before renaming.
Rename the IQY File in Windows File Explorer
Use this when Windows has appended .txt to a web query file, such as MTUM.iqy.txt, and Excel cannot recognize it.
Windows hides known file extensions by default, so the real file name may be different from what is displayed. Showing extensions makes the unwanted .txt suffix visible and allows a clean rename.
Press Windows + E to open File Explorer and go to the folder containing the file MTUM.iqy.txt.
Select the View tab in File Explorer, then check the File name extensions box in the Show/hide group so the full name including .txt is visible.
Right-click MTUM.iqy.txt, choose Rename, delete only the .txt at the end, and type MTUM.iqy.
Press Enter and click Yes when Windows asks whether you want to change the file name extension.
Open Excel, go to Data > Get Data, select From Other Sources, then choose From Web Query or Existing Connections and browse to the renamed .iqy file.

Save the IQY File Correctly from a Text Editor
Use this when creating or editing a web query file so Windows does not append .txt in the first place.
Switch to WPS Office for a Free, Lightweight Excel-Compatible Spreadsheet
If the IQY and Power Query workflow is tied to Microsoft Excel, WPS Office offers a free, lightweight spreadsheet application with familiar menus, strong .xlsx and .xls compatibility, and simple data import tools without requiring a Microsoft 365 subscription.
- 1. Download WPS Office: Click Download WPS Office Free and install the latest version on your Windows PC.
- 2. Open Excel-compatible files: Launch WPS Office and use the WPS Spreadsheets app to open .xlsx, .xls, or .csv files directly.
- 3. Use built-in data import: Go to Data > Import Data to bring in text or web data without requiring a Microsoft Power Query IQY extension.

Frequently Asked Questions
Why does my IQY file show as MTUM.iqy.txt?
Windows often hides known file extensions, and Notepad may append .txt when saving as a text document. Enable File name extensions in File Explorer to see the full name and confirm whether .txt was added.
How do I show file name extensions in Windows 11?
Open File Explorer, click View, select Show, and then choose File name extensions. In Windows 10, open the View tab and check File name extensions in the Show/hide group.
Can I change the file extension from .txt to .iqy inside Excel?
No, Excel does not normally convert a text file into an IQY web query. Rename the file in Windows File Explorer first, then open or connect to it from Excel using Data > Get Data options.
What encoding should I use for an IQY web query file?
Use UTF-8 or ANSI depending on the source. If Excel shows garbled characters, save the file again from a plain text editor with UTF-8 with BOM or ANSI.
Will WPS Office open IQY Power Query files?
WPS Office is not a Microsoft Power Query replacement, but it can open Excel workbooks and import text, CSV, and web data through its own Data tools. For IQY-specific Power Query workflows, continue using Microsoft Excel.




