file extension IQY

File extension IQY description:

With Microsoft Excel 2002, you can reach out to the Web and include data you find there in your spreadsheets, without having to understand how the page was created, or how to create a query file. You select only the data you want, and once imported the data can be refreshed with a single click of a button, automatically whenever the workbook opens, or at a specific time interval. For example, you can use a Web query to select data from a financial Web site to track stock market values or an internal Web site that lists sales statistics.

To create a Web query, you use the Import External Data | New Web Query command (Data menu) in Excel. When you choose this option, a dialog box opens with your Internet Explorer home page displayed. You can select areas of the page to import, or switch to another page to import data.

With Excel 2002 and Internet Explorer 4.0 or later, you can also create a Web query directly from a Web page. Menu items have been added to Internet Explorer (Edit in Microsoft Excel on the Internet Explorer toolbar and Export to Microsoft Excel on the right-click context menu) to allow users to export Web page content or an entire Web page to Excel. When you choose these commands, Excel opens, creates a new blank workbook, and automatically imports the data you clicked.