1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Web Query to load tables in Excel 2008 for Mac

Discussion in 'Business Applications' started by swimmer32, Jun 7, 2018.

Thread Status:
Not open for further replies.
  1. swimmer32

    swimmer32 Thread Starter

    Jun 7, 2018
    I have Macbook Pro with High Sierra OS, version 10.13.4 with Excel 2008 for Mac. At one time I was able to
    use a web query to load tables in Excel for a spreadsheet that I created.
    For some reason, unknown to me, I am no longer able to use this
    feature in Excel.
    Is there some workaround that you are aware of that I can use to restore
    this great feature?
  2. swimmer32

    swimmer32 Thread Starter

    Jun 7, 2018
    Using a Web Query to Load Tables in Excel 2011 for Mac

    By Geetesh Bajajand James Gordonfrom Office 2011 for Mac All-in-One For Dummies

    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 queryis 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:

    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.

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

    1.Open Excel.

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

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

    swimmer32 Thread Starter

    Jun 7, 2018
    will this procedure work with microsoft office 2008 for mac??
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1211303

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice