Web Queries With Excel For Mac

Posted on 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.

Notes: Excel 2011 for Mac cannot import data from OLE DB or OLAP data sources. By default, Excel for Mac uses tables to import data. To turn off tables when importing data, in the Returning External Data to Microsoft Excel dialog box, click Properties, and then clear the Use Table check box. If the external data source you want to access is not on your local computer, you might need to. Your Mac must have a live internet connection to run queries on web pages that are found on the internet. There are three ways to run a web query in Excel 2011. Excel comes with some example web queries. To try one of the example queries, run the MSN MoneyCentral Currencies query using the first method described below. Dec 20, 2016 I have a question involving using web queries in the Mac version of Excel 2008 and Excel in Office 2011 or 2016. I have written some web queries for use in in Excel 2008. These queries get stock.

You can easily make Web queries for Microsoft Excel in Microsoft Word. Follow these steps:

WebExcelWeb queries with excel for mac downloadExcel mac web query

  1. Go to a Web page that has the Web tables that you want to put in Excel.

  2. Highlight the Web address in the address field and choose Edit→Copy.

  3. Switch to Microsoft Word and open a new document.

    Launch Word if it’s not open already.

  4. Choose Edit→Paste.

    The URL is pasted into the Word document.

  5. In Word, choose File→Save As.

    The Save As dialog appears.

  6. Click Format and choose Plain Text (.txt) from the pop-up menu that appears.

  7. 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.

  8. Select the Documents folder.

  9. Click the Save button.

Excel

After you save your Web query, follow these steps to run the Web query:

Web Queries With Excel For Mac Versions

  1. Open Excel.

  2. Choose Data→Get External Data→Run Saved Query.

  3. Open the .iqy file you saved in Word.

Web Queries With Excel For Mac Os

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.

Web Queries With Excel For Macbook Pro

You can refresh a Web query quickly by first positioning the selection cursor anywhere in the data table and then choosing Data→Refresh Data.