By In Office 2011 for Mac, Excel can try to load tables from a Web page directly from the Internet via a Web query process. A Web query is simple: It’s just a Web-page address saved as a text file, using the.iqy, rather than.txt, file extension. You use Word to save a text file that contains just a hyperlink and has a.iqy file extension.

Excel reads that file and performs a Web query on the URL that is within the.iqy text file and then displays the query results. You can easily make Web queries for Microsoft Excel in Microsoft Word. Follow these steps: • Go to a Web page that has the Web tables that you want to put in Excel. • Highlight the Web address in the address field and choose Edit→Copy.

By Greg Harvey. To make a web page query in Excel 2016, you click the From Web command button on the Data tab of the Ribbon or press Alt+AFW. Excel then opens the New Web Query dialog box containing the Home page for your computer’s default web browser (Internet Explorer 10 in most cases).

• Switch to Microsoft Word and open a new document. Launch Word if it’s not open already. • Choose Edit→Paste. The URL is pasted into the Word document. • In Word, choose File→Save As. The Save As dialog appears. • Click Format and choose Plain Text (.txt) from the pop-up menu that appears.

• Type a filename, replacing.txt with.iqy as the file extension. Don’t use the.txt extension. The.iqy file extension signifies that the file is a Web query for Microsoft Excel. If you encounter the File Conversion dialog, select the MS_DOS radio button, and then click OK.

• Select the Documents folder. • Click the Save button. After you save your Web query, follow these steps to run the Web query.

• Open Excel. • Choose Data→Get External Data→Run Saved Query.

• Open the.iqy file you saved in Word. Excel attempts to open the Web page for you, which creates a query range formatted as a table. Web queries work with HTML tables, not pictures of tables, Adobe Flash, PDF, or other formats. The fancy Web query browser found in Excel for Windows is not available in Excel for Mac. You can refresh a Web query quickly by first positioning the selection cursor anywhere in the data table and then choosing Data→Refresh Data.

By Jon Wittwer, Vertex42 LLC Excel Web Query - What in the world is that? If you are like the other 99.9% of MS Excel users, you probably have never heard of microsoft excel web queries (note: statistic made up). Excel web queries are powerful! Web queries are basically like having a web browser built into Excel that attempts to format the content, putting individual pieces of data into separate cells. You can then use Excel formulas (like =A1/B2) to work directly with the data you've downloaded.

And you don't have to know anything about perl, cgi, php, javascript, etc. Getting Started with Sample Excel Web Queries The example web queries that come with Excel are usually for importing stock quote data into Excel.

For more information about using web queries to download Stock Quotes into Excel, take a look at the. Internet explorer for mac os x download free. Although importing stock quotes into Excel happened to be the reason I came across Excel web queries, I have since found many other ways to use them. It is not the web query itself that is the secret that this article is about. Instead, it's the ability to make a DYNAMIC Web Query! By dynamic, I'm not talking about using 'refresh' to update the data. What I mean is the ability to change the parameters of the web query, such as typing in a new stock symbol into a cell and having the table update automatically. If you find yourself using the internet to gather data by filling out forms and copying and pasting data over and over, an excel web query might be the solution to your monotonous woes.

It's not always going to be better, and it's not always going to work, but it's worth a try, especially since a simple web query could boost your productivity! Excel Web Query '.iqy' Files The real key to creating a dynamic excel web query is to create your own '.iqy' file. In it's basic form, the '.iqy' file is simply a TEXT file with three main lines: WEB 1? Paramname= value ¶m2=value2 You can create the file using a simple text editor! Most text editors will save a new file with the.txt extension, but you can change the extension to.iqy after you create your text file.