'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Why SharePoint Export to Excel Downloads an IQY File and How to Open It
Question details
Users exporting data from a SharePoint list are receiving an .iqy file instead of a standard .xlsx or .csv spreadsheet file.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Exporting list data from a SharePoint environment to analyze locally.
- Observed behavior
- The system downloads an .iqy (Internet Query) file, which requires specific handling to view the data, rather than a standalone Excel workbook.
Verify whether you need a live, automatically updating connection to your SharePoint list, or just a one-time static copy of the data.
Open the IQY File to Create a Live Data Connection
Downloading an .iqy file is expected behavior for the "Export to Excel" feature. It establishes a dynamic link so your spreadsheet stays synced with SharePoint.
The .iqy (Internet Query) file acts as a bridge between your spreadsheet software and SharePoint. When opened, it fetches the latest list data directly from the server.
Click the 'Export to Excel' button in your SharePoint list and allow your browser to download the resulting .iqy file.
Locate the downloaded file in your system's Downloads folder and double-click it. Ensure your default application is set to a compatible spreadsheet program.
When prompted with a security warning about external data connections, click 'Enable' or 'OK' to allow the program to retrieve the SharePoint list data.
Export the SharePoint List as a CSV File Instead
If you prefer a standard, static file format that does not require external data connections, use the CSV export option.
Easily Manage Your Exported Data with WPS Office
If you've exported your SharePoint data as a CSV file and need a powerful, lightweight application to analyze it, WPS Office offers a complete, free alternative to Microsoft Office. Enjoy a familiar interface and seamless compatibility without the expensive subscription fees.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open your exported CSV: Launch WPS Spreadsheet, go to Menu > Open, and select the CSV file you downloaded from SharePoint.
- 3. Save as Workbook: After organizing your data, click Menu > Save As, and choose the 'Microsoft Excel Workbook (*.xlsx)' format.
Frequently Asked Questions
What exactly is an IQY file?
An IQY (Internet Query) file is a simple text file utilized by spreadsheet applications to download data from the internet or an intranet securely. It contains the web address and parameters needed to maintain a live connection to the source data in SharePoint.
Can I convert an IQY file into a standard XLSX file?
Yes. Once you open the IQY file in your spreadsheet program and allow the data to load completely, you can navigate to 'File' > 'Save As' and select the standard Excel Workbook (.xlsx) format to create a static copy.
Why does my IQY file open as a text document?
If your default application for .iqy files is accidentally set to Notepad or another text editor, it will display the raw URL and query text. To fix this, right-click the .iqy file, select 'Open with', and choose your preferred spreadsheet software.
How do I stop SharePoint from downloading an IQY file?
The 'Export to Excel' command in SharePoint is strictly designed to produce an .iqy file for live syncing. To prevent this, you must choose the 'Export to CSV' option from the export menu, which downloads a static, plain-text data file.
