Excel Power Query Web Scraping, Custom Functions & Parameters - Part 3
Vložit
- čas přidán 7. 09. 2024
- Learn how to use Power Query in Excel for web scraping and get data from multiple web pages using custom functions in Power Query.
This tutorial is Part 3 from "Excel - Get Data From Web" series.
#excel #webscraping
Fantastic tutorial, thank you so much! This helped me a lot!
Awesome!! Thanks
Auto-refresh could save a lot of time and effort & probably make me happy 😀.
thank you very much that help me a lot ... really thanks
Thanks for explaining and showing this! Is there a way to speed up the proces? Because I have like 2300+ scraped links from items in a table which I use in the function. I takes about half an hour to get 1 item updated, I haven't test this yet if this can be done simultaneous when refreshing, but if not then I have to wait 10 times half an hour to update the list. That is way too long. With or without the possibility of simultaneous refreshing I was hoping to speed up the proces, is there any? Edit: Actually the proces freezes at 1009 rows...
while for this page, data query works just fine. what we need is an easy html table path on the financial statements. that would be like WOW!
Perfect Video!
Thank you a lot.
Please is it possible it does not work on MacBook (Apple)?
Thank you
Great instruction! is this also possible with google chrome? and what do I have to use then?
I notice that the url in a sense searched for for the data you wanted because the GOOGL and AMZON were apart of the URL and the set up for each were coded the same so the function found the data need all that was different was the entry or value. So in my case my URL won’t change. Multiple data entries or values and multiple pages in the same URL.
Very good video. Thank you 🙏
Thanks so much!
What if i need more than just stock price? How can we get that. Could you please explain?
Please make more tutorials on Google Data Studio
Do you show how to import financials with same method? Help please
that would be the holy grail.
How would one pull information from a page when you need to click a button before it shows up?
For example: there's a website I go to for sports stats. They have nicely formatted tables, but if I click a button that same table (with extra information I want to use) is available in .csv format. I'd love to scrape that .csv data, but I can't find it in the data I get from using the web source in Excel Power Query... is there a way to get Power Query to go to a url, then have it "click" a button (or three) for me and THEN let me browse the contents? For the life of me, I can't phrase a search criteria to find this information on my own.
Is there link to that csv? If so, copy the link to that CSV file and use the link to import the data to Power Query.
@@ExcelGoogleSheets Not that I can see. I only see it in the inspection report after I've clicked on the button, but the button seems to run a script on the page (I don't leave the url).
I doubt you can do it with Power Query in that case. You'll need to use something more advanced, like this czcams.com/play/PLRmEk9smitaXljDN2CjwZ96o4Aj87iuC5.html
In google sheets
Can you get a .jpg file ?
Hello sir need ur help, will u help????????
How to auto-refresh ...?
support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440
@@ExcelGoogleSheets thank u 😊👍
@@ExcelGoogleSheets Is it possible to create a web app using the web version of MS Office and like you did with Google Spreadsheet...?
You can use PowerApps.
currently the parameter is text, how to pass the parameter if it is number ? currently am seeing error "An error occurred in the ‘FindSector_num’ query. Expression.Error: We cannot apply operator & to types Text and Number."
this is google sheet circus