absolutely life saver.. like you did pass url dynamically, is there a way to key in some number in input box on page and then get results based on that?
Thank you for a wonderful explanation. Can you kindly help me with a problem. After using the Import from Table and adding a custom column, the new column shows errors in some places (even though the urls are correct). How can i rectify this?
Thanks for sharing. I was wondering how could I easily extract the web links from the "href" in the source code (I'm trying to extract the web links from a list of thousands of links from a Wiktionary frequency word list).
Hey I have a question If I data scrape from a site that is a paid subscription when the subscription ended does the data still save in your excel or will it say #ref
Hello! I am using Microsoft office professional Plus 2016 and in that In the Data tab under get and transform data I am not bale to find the option "From Table/ Range" . May I please know where is this option of "From Table/ Range"
Hello, any have this error "An error occurred in the ‘fResults’ query. Expression.Error: The column '...' of the table wasn't found." ? How can I fix this ? Thank you guys
@@HowToExcelBlog Hi Sir, After following thru all the steps, the query is able to load only 1 table of the one link and shows "Error" in all other links. Could you please help me soon on this.
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
Thanks for sharing. A simple explanation and very helpful 😄
I've been using Excel since 1993 (ver. 5.0) & am still learning. Your videos are excellent!!
In Excel, there's always more to learn.
Glad you're enjoying the videos!
Thank you for sharing your knowledge! Regards from Brazil.
You're welcome! 😃 🇧🇷 🖐️
Brilliant 😊thank you
Well explained. Thanks.
This is the best video regarding web scrapping with power query. You really save my time. THANK YOU VERY MUCH!
Glad it helped you out!
Thank you very much, this was extremely useful
absolutely life saver.. like you did pass url dynamically, is there a way to key in some number in input box on page and then get results based on that?
Thank you for a wonderful explanation. Can you kindly help me with a problem. After using the Import from Table and adding a custom column, the new column shows errors in some places (even though the urls are correct). How can i rectify this?
It's SO COOL!!! EXCITED! Thank you!
😃
How do you deal with the various/ changing headers from the different url ?
Thanks for sharing. I was wondering how could I easily extract the web links from the "href" in the source code (I'm trying to extract the web links from a list of thousands of links from a Wiktionary frequency word list).
Is it possible to adda secondary parameter to the query?
Brilliant - ty
Hi,Thanks for sharing.I ran this process on 500 links but at some point it error and stops itself.Is it possible to bypass this error and continue?
is it possible to do this using only xpath and regex?
Hey I have a question If I data scrape from a site that is a paid subscription when the subscription ended does the data still save in your excel or will it say #ref
Hello! I am using Microsoft office professional Plus 2016 and in that In the Data tab under get and transform data I am not bale to find the option
"From Table/ Range" . May I please know where is this option of "From Table/ Range"
you are the best
Thanks 😀 🏆
if one of url has empty table, scpraping stops there. How can we pass this problem. thanks
Hello, any have this error "An error occurred in the ‘fResults’ query. Expression.Error: The column '...' of the table wasn't found." ? How can I fix this ? Thank you guys
thanks!
No problem!
Excel keeps freezing when I try this. What can I do?
Get less pages.
hi how to excel i have a question
Excel loads only tables for two links and then freezes. What could the problem be?
Not sure, how many rows is it trying to load?
@@HowToExcelBlog Hi Sir, After following thru all the steps, the query is able to load only 1 table of the one link and shows "Error" in all other links.
Could you please help me soon on this.
Same problem is been faced by me also can you pls guide me how to fix it ??
Like and subscribe - You do cool things!!