Power Query Problems

Fix Excel Power Query IQY Files Saved with a TXT Extension

Steven ParkerSteven Parker Nov 13, 2026 868 views

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.

Fix Excel Power Query IQY Files Saved with a TXT Extension
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.
Before you start

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.

Solution 1Recommended

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.

1
Open File Explorer

Press Windows + E to open File Explorer and go to the folder containing the file MTUM.iqy.txt.

2
Show file name extensions

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.

3
Rename the file

Right-click MTUM.iqy.txt, choose Rename, delete only the .txt at the end, and type MTUM.iqy.

4
Confirm the extension change

Press Enter and click Yes when Windows asks whether you want to change the file name extension.

5
Test in Excel

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.

Rename the IQY File in Windows File Explorer
Rename works immediately: Excel can now see the .iqy extension and should treat the file as a web query instead of a text file.
Free Microsoft Office alternative

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. 1. Download WPS Office: Click Download WPS Office Free and install the latest version on your Windows PC.
  2. 2. Open Excel-compatible files: Launch WPS Office and use the WPS Spreadsheets app to open .xlsx, .xls, or .csv files directly.
  3. 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.
Avoid Excel extension and Power Query import bottlenecks with a simpler spreadsheet data workflowOpens, edits, and saves .xlsx, .xls, and .csv files for Microsoft Office compatibilityFree to use with no Microsoft 365 subscription requiredFamiliar ribbon-style interface for easy migration from ExcelBuilt-in data import tools for text and web sources
microsoft office alternative - wps office

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.