Share via

New Web Query issue - Microsoft Excel Mac Office 365

Anonymous
2018-05-15T05:23:14+00:00

I have problems getting External Data (for instance stock prices) from Web into Excel 2016 for Mac. 

Within the documentation that I found, you can use a Web query to retrieve refresh-able data that is stored on your intranet or the Internet, such as a single table, multiple tables, or al of the text on a webpage. This pulls the data from the webpage into an Excel workbook. It seems that the sequence of steps would be:

  • From the Data menu choose Get External Data > New Web query
  • Type the URL web address in the Address text box at the top of the Home page in the New Web Query dialog box
  • Find the web page containing the data you wish to import

According to MS there is nothing to install and New Web Query is accessable under the data tab. It's not like that in my case, See print screen

On the Mac, you can't use URL based web queries as described above. Choosing Run Saved Query instead of New Web Query is for an entirely different purpose. New web query isn't available. Run Saved Query from .iqy does work, but I have no clue on how to create and then saving the .iqy text file.

Please let me know if I need something additional (configuration or Add-In) to create a new query.

Regards

Dirk

MacBook AIR 2014 & macOS 10.13.4 (17E202)

Microsoft Office 365 Home Subscription for Mac (Build 16.14 20180507)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-05-17T15:55:34+00:00

    Hi Dirk,

    It is plain that Phillip does not have a clue about this feature of Excel.

    The "New Web Query" feature is available only in Excel for Windows. Mac users can request features on the UserVoice site. This feature request has been made previously, but appears to have been deleted by Microsoft. You can make it again here:

    Excel for Mac

    It is possible to make web queries manually, and you can use parameters. I made a web page with complete instructions:

    http://www.agentjim.com/MVP/Excel/WebQueryHowTo.html

    Before going through a lot of work, give the Stock Connector addin a try. It's by Michael Saunders, and it's free. On the Insert tab of the Ribbon, click the Store button. Search for Stock Connector.

    7 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-05-15T15:23:15+00:00

    is this what you're looking for:

    The highlighted item is called New Web Query.

    If the item above doesn't show, you're using a very old version of Excel 16. Or you haven't Gone to Excel Preferences Ribbon and Menu, and added it to Data ribbon.

    __________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

    0 comments
  2. Anonymous
    2018-05-15T17:51:56+00:00

    Hi Phillip.

    No, the option you highlighted is "New Database Query". 

    I'm looking for "New Web Query", allowing an connect to a web page, and download a product list straight into a spreadsheet. According to Microsoft in the following link Compare Excel 2016 for Mac with Excel 2013 for Windows you can:

    Connect to a SQL Server database with an ODBC driver installed with Excel

    Connect to other ODBC data sources **

    Import data from a text file

    Import data from a web query

    Import a file from FileMaker

    In my case, "New web queries" created in Excel 2016 for Mac can only reference my Office 365 locations (OneDrive and SharePoint), but not arbitrary web locations.

    Remember, I'm using Microsoft Office 365 Home Subscription for Mac (Build 16.14 - 2018 May 07)

    0 comments