Import Multiple Pages from Web with One Query in Excel
ฝัง
- เผยแพร่เมื่อ 15 ส.ค. 2024
- In this video, we import multiple pages of data from a website with one Excel query using Power Query.
We create a table of URL's that can automatically update on a sheet, import data from the web and then turn it into a function with some M code.
We then create a custom column to use this function and feed it the URLs from the table to import as many pages as we want.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1 - แนวปฏิบัติและการใช้ชีวิต
![เหนื่อยหน่อยนะ (SOMEONE LIKE ME) - GEMINI Prod. by URBOYTJ [ OFFICIAL MV ]](http://i.ytimg.com/vi/M55XjfhbrNw/mqdefault.jpg)
Not only this is incredibly useful, but is also wonderfully explained. Thanks man!
My pleasure. Thank you very much.
SAME HERE...BUT UR REACTION..WHILE DELETING URLs IN TABLE..!!!!
This video tutorial is now about 16 months old, but it's going to help me in pulling in the needed data from my UberEats Deliveries. I realized I needed to automate the data to help maximize my taxes, and the Power Query as a function to bring in multiple pages is really what I need. So thank you very much. I look forward to getting it implemented, so that I can link the Excel files in MS Access for further data analysis.
Excellent! Thank you.
You, sir, ARE A LEGEND. Searched for ages to accomplish what this allows me and came up empty. When I landed on you, I was home free. Thank YOU!!!
Great to hear, Kurt. Happy to help.
Dude these steps still works until now and easy to understand. Thanks man!
Glad it helped!
Become one of my top instructors and youtube channels with only one single video! thanks a million!
Thank you Isparoz.
Searched for this all over . This has been the best example I've seen and very well explained. Thank you very much
Glad it was helpful! Thank you 😊
I can't thank you enough for this detailed video (step by step). Its 3 years old but still valid and valuable. God Bless you!
Glad it helped! Thank you 💓
I'm overwhelmed by the incredible level of clarity this tutorial displays! Kudos
Wow, thanks!
Hello.
I had difficulty in self-study because there were not many Korean books that taught me about power query editing or parameters.
Thanks to your video, I have integrated multiple APIs into a single query.
I clicked Like and Subscribe.
Have a nice day!!
I never see videos with this many views that have 0 dislikes but after trying this solution, I understand why. Great video!
Thank you very much.
I am also REALLY happy as it helped me with the following use case.
I have addresses I want to scrape off web. They are nicely in a table but there is hiearchy as such: umbrella company -> daugther companies -> branch addresses. I got url's from a sitemap and needed to load everything at once...and this helped me to do exactly that. Hopefully it helps someone else too!
Awesome! Thank you for leaving that comment.
This Video is still the best when it comes to Excel Web Scraping! For me it was a breakthrough. Many thanks!
You're very welcome! Thank you for your comments Johann.
This is gold man, thank you, I was able to fetch currencies from last 7 years from xe site and they love me now. I was also able to get data from steamships lines and so, thank you so much Manz God bless you
You're very welcome. Nice work Kenneth.
@@Computergaga Can you show us how to do the same thing but with a PDF file? meaning the source would be the folder where the pdf's are located
Excellent video. I used it to download 150 tabs of info on the WSJ website with all public companies listed in USA and it worked like a charm. Thanks a lot.
Awesome! Thanks for sharing.
I couldn't be more grateful to find this channel. Dear Computergaga, you explain everything so clear and understandable :) Real life saviour!
Thank you very much 😊 That's great!
I can't thank you enough, Computergaga! My work project just became a breeze.
You're very welcome.
Awesome Video! Seriously Days of searching and then you explained everything I needed in 12 minutes!
To Fix "Expression.Error" - If you're pulling a lot of dates, or websites, and maybe some of them don't exist or don't exist yet you'll get this error and it'll mess up everything:
Solution: @9:20 in the video simply right click your FetchMovie equivalent column header and select Remove Errors.
Excellent Dusty.
Thank you! Thank you! Thank you!
you make my date on time when looking for immediate resolution.Thanks
I am grateful for this... I had dataset of 40,000+ rows in 82 pages and it worked perfectly. Thank you for sharing the knowledge. I'm gonna try this in power bi too and see if it works. Thanks again!
How much time does it take to fetch the data
Wow excellent information by simple teaching ... Even a layman understand this module... Creating more interest to learn...Great Work...Non computer literate man from South India Coimbatore Tamil nadu... Slowly learning computers
So nice of you. Thank you Niranjan.
This was my first fx table. Thank you so much. Please follow this video up with a 5min time intelligence table video if you want. I'm going to watch your other videos.
This is so easy that it seems impossible. I've tried so many solutions from the internet that were not even close to what you've demonstrated. Huge credit! Thx!
You're welcome Szymon.
Thank you very much, just spent hours trying to get this to work on other sites.
No worries, Paul. Very glad to help.
Thank you! Very useful and it changes the structure of my work a lot. More efficient.
Great to hear. Thank you.
I normally don't leave comments but just hit the "like" (or not) button. But this video honestly, is very well made and helped me a lot. Thank you Computergaga.
You're very welcome. Thank you for the comment Luigi.
thank you so much i was able to compile 28k records ...each page had only 100 records per page. was so useful and so well explained
Brilliant! Glad it helped!
WOW. It works perfectly. It is exactly my need. Such a perfect example. You save me hours and hours of a boring task. Many thanks
Great to hear. Thank you 👍
Hi can only say thank you !! you're an amazing teacher. Cheers
Thank you! 😃
Excellent & smart stuff, saving tons of work. Grateful for sharing !!!
Very welcome! Thank you.
Worked like a charm!! No tutorial has ever worked for me in 1-go!! Thanks!
Happy to help, Gaurav. Excellent!
I searched all over the internet and finnally found your video. It is exactly what I need. I cant thank you enough for this well explained and details video. However when I try to create my own thing, I got issue when there is/are pages with no data, the queries stop working from that date. I hope you can help me on the issue. Many thanks in advance.
You saved me several hours of manual operational work
Great! 👍
Thank you so very much...beautifully explained, Highly underrated video. Just Brilliant
Thank you 😊
This was a huge help! Needed to download over 5000 rows of data. You saved me so much time. Thank you!
Awesome to hear. Happy to help Brock.
TH-camrs should look to this to see how to do it properly.....excellent.
Thank you, Don.
Love it ! Thank you so much! With the new Web Connector, this became so much better!
Oh yes! 👍Thank you. You're welcome.
What a piece of knowledge...very useful for me..thank you very much
You are most welcome. Glad that it was useful.
Thanks, solved a data input I was having.
Very well explained.
Thank you. Glad to be able to help.
Awesome tutorial breaking down this complex process in easy to follow steps along with a good example. Thank you sir.
One of the best tutorials. Does the job in matter of minutes.
Thank you, Chirag.
Cool tutorial! Thank you. Bombastic ! I have learned how to make a function out of a procedure!
Excellent! No worries, buddy.
One of the best tutorials I've ever seen! Thanks a lot!
You're welcome. Thank you.
Life saver.... Can't thank you enough... Been using this for months....
You're welcome, Serkan 👍
Thanks, you helped me finish important part of my Business Intelligence Internship Project
Happy to help 👍
Many thanks, Mr Computergaga - awesome!
Thank you so much, Ian.
Thank you so much! You really saved me here (And taught me how to use a great and powerful tool)!
Awesome! Good to hear.
Thank you! Took me way too long to find this gem
You're welcome.
Very clearly explained. Very good presentation.
Thank you 🙂
I was desparately in need of this and your video incrediblely came out to me. Besides your presentation is perfect... thank you
You're very welcome 😊
You guy are awesome, this video is what I needed, and completely blow my mind, I got quite confuse regarding URLs table and URL column, but I handle it and apply exactly as you on example that concern me, big THX.
Easily one of the best videos on TH-cam
Thank you very much 😊
Mahalo! You solved my whole problem just a few minutes into looking into how this works.
👍
This is incredibly helpful and useful. Really helped me solve a 2 year headache. Thank you so much. Appreciate the detailed guide.
You're very welcome!
This is super usefull, I wont remember it, but I will come back again when I will need it again
Thank you!
Hitting Subscribe by watching your 1st Video.... ultimate.. The way you explain..
👍
Thanks, Alan. You are awesome!
Thank you 😊 you're welcome
You have a great teaching style
Thank you, Viktor.
Very helpful video! Useful technique, and explained in an easy to understand way.
Thank you, Bill.
Im not writing comments very often, but I have to say that this video is so useful, interesting yet well eyplained, that I had to.
Thank you 👍 I appreciate your comments, very much.
This tutorial is so clear and easy to understand. I have some problem, the table result only show 10 data per row (because the website default is show 10 row, but we can change to show all) how can we fetch all data?
Many thanks for your great help ❤️❤️❤️❤️❤️❤️❤️
You're welcome 😊
Good one Bro I got some manual work automated now...thanks verymuch
Great 👍
Perfectly explained! Why to dislike this !?
Thank you Adr 😀
This is great tutorial and very clear explanation
Thank you very much.
This is great, thank you!
What if the URL doesn't have a unique identifier for the different pages? I'm trying to download data from more than 50 pages but every time I go to the next page and see a different spreadsheet, it has the same URL. There is no equivalent to the year numbers in your URL.
I wish to thank you so so so much for your video that helped me A LOT.
You're welcome, Antoine. Thank you.
This is gold! Thank you so much
You're so welcome!
This is an excellent video. It helped me overcome a major hurdle today. Thank You!
Great to hear. Thank you, James 😊
This is an excellent tutorial - clear and easy to follow, thank you! It's saved me a ton of time.
You're welcome, Matthew. Thank you.
Thanks so much for your excellent tutorial!!! It really helped get the job done!!! 👍👍👍
Great video and great explanation !!! Congratulations
Thank you, Xavier.
Thank you for this video.. Saved me so much time
Great to hear! Thank you.
This is brilliant! I love how you go through the steps, seems like you're commenting a football match! :) Don't get me wrong it's really well explained! Thanks for that.
Thanks! 😃
Brilliant! Excellent teaching skills; very clear and understandable.
Would it be possible to do a video showing how to get data from a username & passworded website, please?
This tutorial is pure Gold! Thanks! Looking forward to more videos from you. :)
Thank you very much Subanta.
Helped me a lot mate. Thanks a lot.
No problem 👍
FANTASTIC vid. Thank you!!!
I’m scanning for Zip Codes and the address in one of the URLs isn’t valid and I get an error. How do I tell the function to ignor it and continue?
That is sick!;) I saw nobody adding some text to PowerBi code before. It looks very advanced and powerful. I really love it. It opens eyes;)
Thank you, Enrike 😊
Fantabulous.......Great explanation & worked at the first go....Thanks a ton
Most welcome, Hari 👍 Thank you.
Thank u so much from VietNam
You're very welcome.
This was a great video. Thanks so much for the tutorial
You are so welcome!
You have saved me a huge amount of time - thank you so much!
You're very welcome.
Excellent !!!! This is what I was looking for. Very well explained step by step.
Thank you, Dhananjay
I have never seen the ratio between like and dislike in any video. Well done sir
Thank you so much Afzal 😀
Hi, I know this video is a few years old, but hopefully you occasionally check in for questions/comments. Btw, thanks you for this tutorial, it has made my Excel life so much easier.
I was trying to create a new worksheet using over 300 URLs, and I'm wondering if that is just too many because it always gets stuck about a third of the way through loading the rows.
Any ideas why?
You are a super Hero, Thank you so very much.
You're welcome! Thank you 😊
Brilliant solution, these are great.
Thank you, Jonny. Happy to help.
Great stuff! thanks a lot mate. made my work a lot easier :)
No problem 👍
Thank you Computergaga. This was a superb explanation and tutorial.
You are welcome, Robert.
Incredible video. I have been trying to learn how to do this for ages now, and every other video I've seen isn't near as helpful.
Great! Happy to help, Nathan.
Men should think machines should work you have done a job excellent hats off
Thank you Narayan.
Great info, what is my URLs are 2 columns instead of 1, in my example I have one for the actuals and one for the goals... thank you I've been searching for this solution for a while
really useful, thanks for your help. nice explanation
You are welcome, Maurizio.
Thankyou sir, you are a precious gem😍
You're welcome 😊
AMAZING...WOOOOOOW.... THANKS SO MUCH SIR
sir, i need more columns in excel more than 1 decillion. any tips? this may sound crazy, but I do need it
You're welcome. Thank you.
Look into connecting to an external source using Power Query. Excel cannot provide more rows or columns on the sheet.
Thank you so much for such an incredibly informative, easy to follow and helpful tutorial. That was absolutely brilliant for helping me challenge my council tax band increase. Liked and Subcribed.
Glad it was helpful, Darren.
This was a great video. I think the main use case for this functionality is to automate web scraping of changeable data such as stocks, commodities, and prices on goods and services. Otherwise, one could simply cut and paste stagnant data.
Thank you.
Excellent sir. Just loved it🔥
Thank you, Chetan.
Thanks alot! This is perfect. However, I was wondering if there’s a workaround for if the columns from the web are variable.
Depends on the variable. If you're referring to the URL, we will need a way to calculate it using this method.
If you're referring to the page, we would build into the query a method to find the table.
Excellent sir..
Its helps a lot for work
Awesome! Thank you, Yogesh.