Saving Web Queries

When you create a Web query, it is automatically saved for use in the current workbook. If you need the same query in another workbook, you can save the Web query in a separate file. When you save a query, the file uses the .iqy extension, which you can import into another workbook.

Save a Web Query

Click the Data menu, point to Import External Data, and then click Edit Query.

Click the Save Query button.

Select the drive and folder in which you want to save the query.

Type a name for the query.

Click Save.

Click Cancel.

Import a Query

Click the Data menu, point to Import External Data, and then click Import Data.

Locate and select the query file (.iqy).

Click Open.