Forum Discussion
Get external data from web not showing
Hello,
I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea why this might be happening?
See attached a screenshot of what I'm getting. Shouldn't that option be appearing between the "From HTML" and "From Text" options?
I'm on Microsoft Excel for Mac, version 16.23 (19.03.09)
Thanks in advance,
Pedro
pdramorim may be way late but I took the following steps on mac
Downloaded the Google Sheet file as Excel on mac
In Excel, selected data, then launch power query editor
In power query editor, get data and import the workbook you need
Then follow the same steps as here https://www.youtube.com/watch?v=hhfaOZUbrqw
Hope this helps!
pdramorim so I need help!!! I am trying to open a igy file in Excel. Excel says gathering data and after it is done, the file doesn’t show any data. Is this an Excel setting issue? Please help!!!
Hi
I don't know why there's suddenly activity on this very old thread, but much has changed since it originated. The current update is no longer 16.23. Now it's 16.63.1 so you can see there have many intervening updates.
I think the answer for version 16.23 and all versions including the current channel update version is to use the Menu Bar and choose Data > Get External Data > Run Web Query. For more information on how to build a web query, visit this page: Making and using Excel Web Queries (agentjim.com)
- As on Jan 2024, it worked for me. I had been struggling to import currency exchange rate data in Excel 2019 Mac version. Just follow the steps outlined in the above link.
JimGMac Thought we were talking Power Query here. "Run web query" isn't really that. Or did I miss something?
unfortunately this does not allow me to input a URL (I'm on mac), although it seems downloading HTML files and uploading them manually works for now (thank you for pointing this out though!) Riny_van_Eekelen
Hey JeanPaulGedeon did you read the other posts? We are looking for a solution to automatically pull data from a Google sheet to excel on Mac OSx
- Google sheets are not HTML tables, so web query will not work. Copy and paste from Google sheets does work. There is a web browser called OmniWeb that is scriptable. In theory, you could write an Applescript that copies a range from OmniWeb and pastes it into an Excel worksheet. I haven't test this, however.
I was having same problem after starting to use macbook. Although it can not completely be like directly importing from web page to excel, what you can do is- GO to webpage from where you want to import data from. Then right click( tap with both fingers in macbook) and choose save as button then save as html file after that you can import the page from data tab>>get access>>HTMl>>select the HTML file.
exactly the same problem! pdramorim
- Have you tried "From html"? Seems to me that is the one you need?
JKPieterse that was my first thought, but "from HTML" just prompts me to select an HTML file from a local folder. It doesn't give me the option to select a web link, which is what the "from Web" option allows.
This is so frustrating, every single tutorial I've been able to find clearly points users to the "from Web" option specifically, but it's simply nowhere to be found on my menu.
pdramorim , Get Data from Web is Power Query connector, I'm not sure it is supported for Mac
