If you want to save a web query for future use in other worksheets and workbooks, right click on the imported data range, and select Edit Query from the menu that appears. This will cause the Edit Web Query window to appear, which is exactly similar to the New Web Query window.

 

 

In this window you can click the save button to save the web query in the Queries folder.

 

If you click the save button, you can use the Save Query dialogue box to specify a name for your web query and a location to save it in. For consistency, you should save all your queries in the default Queries folder.

 

You can also save your query when you create it, by clicking the save button in the New Web Query window before you click the Import button. In this example, the web query was saved as rates_1.iqy.

 

After you have saved your query, you can easily access it from any Excel workbook by choosing Data->Import External Data->Import Data from the menu bar.

 

 

In the Select Data Source box, just select the name of your query, and click the Open button to import the data.