Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding)

Learn Power Query now with our Beginner to Pro course: link.xelplus.com/yt-pqweb
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
With the recent updates to the Power Query web connector you can grab data from pretty much any web page and bring it over to Microsoft Excel. Plus you'll have a connection to the webpage. Which means, just click the "refresh" button and pull over the latest information.
🤔 One challenge I was excited to tackle was to import "clickable" URL links AND images with Power Query into Excel. Yes. It's possible to have clickable links in the Power Query extract. It's also possible to extract images from web pages! Check out the video to see my solution.
👉 What You'll Learn:
How to use Excel's web connector for easy data import.
Tips for importing data from web pages without HTML tables.
Creating dynamic, clickable links and images in Excel with ease.
📊 Excel Your Skills:
Perfect for analysts, Excel enthusiasts, and anyone interested in data management.
Step-by-step guidance, making it accessible for beginners and a time-saver for advanced users.
🌍 Join 400,000+ professionals in our courses ► www.xelplus.com/courses/
🔍 Key Moments in This Video:
00:00 - Introduction to Excel's Web Connector
02:30 - Importing Data from Web Pages
04:38 - Add Table Using Example
09:10 - Creating Clickable hyperlinks in Power Query
12:01 - Importing web images
12:40 - Updating webpage to test
13:28 - Wrap Up
🎬 LINKS to related videos:
How Power Query Will Change the Way You Use Excel: • How Power Query Will C...
You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query: • You WON'T BELIEVE Thes...
➡️ Join this channel to get access to perks:
/ @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
More resources on my Amazon page: www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel

[@LeilaGharani]

As for availability: This feature is already live in Excel 365 version. According to Microsoft Version 2310 (Build 16924.20106) or later. Depending on when you'll receive updates, you might have to be patient. Do subscribe to our weekly newsletter "Between the Sheets" to stay on top of office app updates: link.xelplus.com/yt-c-newsletter

[@ahmadnaggayev3637]

Thank you for valuable information @LeilaGharani. Your great grandfather Veysel Gharani probably would be proud you careying on of the continuous legacy of contribution your last name does for to society. Sorry for off topic, once again thank you for your contribution 🤲🏻.

[@fernandoantuneslopes1969]

Great video! I have M.O. 365 but it is not available yet...

[@jpeca13]

Interesting tool. However, I have Office 365 Version 2311 Build 16.0.17029.20028, 64-bit, but I can not reproduce your example. After providing the link to Get & Transform Data > From Web, I got only the option to see "Document" - no tables, etc. and no button Add Table Using Example 😥

[@lateefbalogun4691]

@@jpeca13 I got the same prompt message "Document" too

[@eslamfahmy87]

Does this feature for insider first and then be published ?

[@chaseman]

been watching your videos for a bit now but this is one of the best ones. love the real world example!

[@ym10up]

I'm only halfway through the video and I have to pause to comment that THIS IS SO COOL!!! You are basically building your table by picking the data directly from the webpage like a pick your own orchard!! How brilliant is that!? Thank you so much, Leila!

[@Grumpy_Granddad]

Yes Yes Yes -- I am so excited with this and without even thinking I can change the way I record data.

[@RunOs3]

Thank you, Lella. You're my new hero!

[@Autoscraping]

A fabulous video that has been of great help in orienting our new collaborators. Your generosity is highly valued!

[@LeilaGharani]

Our pleasure. Glad the content is helpful!

[@ginojap]

Leila, you have non idea how much I respect you for being so professional and smart! thank you very much for you content.

[@jeffersonbruno8167]

Hello Leila, congratulations on your didactics and saving me from a last-minute demand. I shared it with colleagues and we are all coming up with fantastic applications lol.

[@gospelmoto2833]

Valuable, thanks again Ms.Leila

[@arsraza354]

I've no words to say thank you. Very much significant topic discussed.

[@LeilaGharani]

Glad you enjoyed it!

[@flourishwithMJ]

Thank you so much, Leila.❤

[@nomoreospf]

Super useful, thank you!

[@azmary986]

Nice approach to web scraping!

[@Jocedu06]

Nice trick! And same with cubefonctions for pivot table

[@gef24]

Wonderful. We will soon do scrapping in Excel with Power Query web scrapping like what we can already do with Power BI.

[@garycroftsmicroscopy]

Fantastic the data type was awesome

[@mariettekaosisonna774]

Lucky to be the 1st to be here. Let me relax and learn.

[@alex626ification]

That create data type, seems like a really cool way to help hide and expand/rollup data from a table. Despite my best effort some people are still scared of pivot tables.

[@AlfordLau]

Thank you Leila.

[@logiclust]

i really like the way you say "pattern"

[@paklibas2514]

Bohat Alla. Excellent 👍

[@nadermounir8228]

Thank you for this nice video 📹 👍

[@tumipitsie7449]

Thank you. Excellent video 📹

[@LeilaGharani]

Glad you liked it!

[@jesus.moreno]

wouuuuuuuuuuuuu .... awesome ... muchas gracias !!!

[@HasanAYousef]

Super as usual

[@chrism9037]

Excellent Leila!

[@LeilaGharani]

Thank you! 😃

[@ikchuks4u891]

THANK YOU!!!!!!!

[@a.achirou6547]

Thank you for sharing !!

[@LeilaGharani]

My pleasure!

[@eslamfahmy87]

Perfect, actually you helped me as I have been facing an issue with power automate while I extracted from Web

[@ChristiaanRoest79]

Great content Leila ❤

[@LeilaGharani]

Thank you!

[@jawadahmadehssan6251]

Apparently I did not have my excel updated to do it there. However, it worked perfectly in PBI. Thank you for the video.

[@davida6955]

Thanks!

[@jerrydellasala7643]

AWESOME! I've been aware of the Web Scraping and Data Types, but putting them together to be able to get a CLICKABLE LINIK is a trick I hadn't thought of! Great tutorial on how to use the Web Scraping tool without the Data Type trick. THANK YOU!

[@LeilaGharani]

Glad it was helpful!

[@coffeecuppepsi]

This is awesome thank you 😄

[@LeilaGharani]

I'm glad you like it

[@muhammadelsaqa7484]

Very powerful ❤

[@AlThePal78]

anoter fire video thank you so much I actually follwed a long this time :)

[@mahendraroliya8695]

hat create data type, seems like a really cool way to help hide and expand/rollup data from a table. Despite my best effort some people are still scared of pivot tables.

[@brucepeaslee3952]

Very useful.

[@Terniedintorni]

I amin love with your videos

[@BlossomCafeStudio]

Thank you for another great video ❤ and inspiration insight to use your own catalog of courses. 🎉

[@koponi100]

beauty and smart💙

[@NotTelling-ik8zl]

You are SO GOOD at what you do!!

[@surajbhardwaj428]

Upto the so high skilled... So much cool👍

[@bisyrim1030]

thanks

[@mjaved701]

Excellent madam

[@mahendraroliya8695]

Excellent💯💯💯💯

[@englishwithabdullahsafi5034]

Awesome 👍❤

[@DjPrimeberry]

Game changer

[@IvyPlans]

Thank you for another awesome video. Does it work on OneDrive? Does it bypass secured website like Dropbox or Google Drive?

[@Hoekstes]

Thanks Leila! Can you use this if you need to login to website first?

[@ajbp95]

This is crazy!

[@JakubHumpolec]

Wow, the trick to format links and images is SO VALUABLE, I'd say more then getting daya from web. Thank you Leila!

[@GerhardHolzer911]

Hallo Leila, prosit 🎉2024 und vielen Dank für die Informationen im Video - speziell die Datentypen sind genial ! Viele Grüße nach 2351

[@sunnygala7972]

Great job Leila as always!

[@LeilaGharani]

Thank you! Cheers!

[@hungluu6474]

thank you for your video. Can we add pager by this method?

[@trevh1400]

Many thanks for your videos which are very helpful. Can you please explain 2 things: 1: how to include login information and 2: how to get information from a page pointed to by one of the links on the previous page? Thank you.

[@byrollo]

top!

[@GG-tr2xe]

Cool! Can we also do the same for invoices in in sheet 1 of different excel files?

[@barttitulaerexcelbart9400]

Well done Leila. nice web scraping techniques. But you do not need to transform to datatypes. If you add a column to the table result in Excel and type =HYPERLINK(....etc) then this formula is always updated. You do have a "double" column but you can hide the PQ one in Excel. It is dynamic!

[@omarchahine3613]

Thanks

[@LeilaGharani]

Thank you!

[@webnestors]

Hi nice videos, very helpful. Is it possible to do this vise versa? Like to send from excel to a wordpress website? Also is it possible with power automate to make changes to an article for example?

[@007KrausBean]

Very cool. Such a bummer that this is NOT a thing for Excel on Mac. At least I have not found it.

[@grabshopper4599]

Great job, do that have way to solve if the website need to login user id and password in excel?

[@tbarczyk1]

If the data is split over paginated sites (and the URL of each pagibated page inckudes "page=1" , "page=2" and etc., is there a way to use power query to collect the data from each of those pages other than by creating a separate table for each page (which would also not be ideal since the number of paginated pages fluctuates). If not, what would you advise as the next best solution? Power automate?

[@satishsj]

Please consider creating a similar video for scraping data from IMDB into Excel.

[@user-fp2zr8hs9c]

Dear ma'am i wanted your (excel to advance course). BCZ your teaching method is so good please ma'am guide me

[@nevado.]

Leila, you are really crease. I am just wondering how could you create such an amazing video.!! It is really super cool. I lvoe you soooooooooooooooooooo much. muaaaaaaaaaaaaaaaaaaaaaaah

[@LeilaGharani]

Thank you so much!

[@b.a.6663]

Hi Leila, thank you for this great video first! On my company laptop I get following message, when I try to create a connection with a webpage: "Internet Explorer is in compatibility mode, etc" With other words: I'm not able to see the content of the webpage for further adjustments. Any work around for this issue? Best,

[@marcossaraiva4245]

Hi Leila, great video and wonderful content! Just one question - what should we do when the list and data is in more than one webpage? looking for your solution! 😅

[@fernandoantuneslopes1969]

Great video! And how can we web scrape when there are multiple pages, not only one? By the way, this feature of creating a table by example is not showing to me in 365

[@keljar2007]

Loved this video. I have been trying in vain for some time to do what you did for my purchased courses on Udemy, the Great Courses, Audible, and Kindle books. Every time I paste the url in, I get the message "Unable to connect: "Access to the resource is forbidden." Any way around that? I am assume each of those entities don't allow the connection?

[@isaiahdavis3350]

Does this ping the server for the image each time you open the excel file OR refresh the data connection OR not load if you are connected to the internet? I ask because I don't want to unnecessarily keep requesting the same image from a server if I don't have to. I would think it would save the file temporarily to your local machine as a cached image. If that is not the case I just wanted to ask.

[@Mohamed0Elsarf]

Thanks for sharing I am accountant and we work with Excel and SalesForce App So, How can I connect Excel with reports from Salesforce?

[@AnkitSingh-vx4dy]

Hi Leila, Can you teach us how to make Attendance tracker , Productivity tracker on Google Sheets >

[@excel-k-sir]

Wow that's amazing 👏. Can I request you to please share knowledge on Data Types usage with real life examples

[@GustavoSoares]

🤯 data types

[@thamilanban]

Could you please make your courses available in Udemy like before?

[@ahsaaah7247]

Super, Leila. I learned so much from your channel. Thank you and wish you and your family a good holiday:) I recently started using Sharepoint list, can I get the images from the SharePoint list? And can I use it in the VBA code? Would be appreciated if you could show an example of this:)

[@jasonorr1093]

Why am I not seeing the "Add table using example" shown at 4:43? It's not on my navigator screen. Thanks

[@lavahawk]

same

[@henryg5735]

How would you deal with web page access being password protected?

[@chrisgrable5319]

This is fantastic. Thanks! Is there a way to do something similar for a pdf document?

[@LeilaGharani]

Sure is :) kzbin.info/www/bejne/pmOWYWd4n9uleJo

[@Skyba6750]

Leila, missing ur more videos on power automate. Can u make more videos on this like data extraction from invoice table of a pdf invoice and then paste in excel. I tried searching on KZbin but could not find much videos around it. Missing ur videos on the same. Would be thankful if u can help on this.

[@Quidisi]

BRILLIANT!!! Now, if only there were a way to have Excel queries periodically refresh without me having to go and open the workbook. Then I could use them as the data source & calc engine.

[@LeilaGharani]

Definitely! Check out Power Automate for that. To get you started: kzbin.info/www/bejne/iYbWmp5me6ytf5I

[@Quidisi]

@@LeilaGharani Thank you!

[@MrMvlarra]

@leila, where can I see an example for KZbin Chanel and play list ?

[@cleareasmud]

Leila I have a webpage with my students' progress on their online hwk. I've been trying to extract data to excel but it only extracts the sign in page to the website. Is there a way to sign in inside this Excel process?

[@bgyw]

This is pretty good. I usually use a Chrome extension but it's not as versatile as this technique. What do you do when there are multiple pages with the content structures the same way?

[@luzaanvanwyk1977]

I have the same question regarding multiple pages of similar data. If this is just page 1 of 888… with only 10 lines of data displayed per page… can Power Query manage that?

[@JakubHumpolec]

@@luzaanvanwyk1977 Some time ago we did Power Query thet fetch number of pages and then processed all of them within a cycle. It was not easy, took some time but it definitelly can be done.

[@joesmith4254]

Firstly, it's very inspiring to watch your videos. Secondly it's very frustrating to know that I can't use them for several months while I wait for my company to update to and Excel version that contains the new functionality. Would be great if you had a table on your webpage that showed which build versions of Excel contained the new functions. And absolutely fantastic if the table had a link to to the youtube video telling how to use the functionality. Keep up your absolutely fantastic work.

[@pedroemanuelrebelo2182]

The "Add Table Using Examples" feature in PQ Excel brilliantly uses AI to recognize patterns, making data handling both intuitive and efficient without coding! 🚀🧠 I'm absolutely thrilled by this AI-driven innovation! 😃🌟. Brillant Leila

[@LeilaGharani]

Thank you! Cheers!

[@eTrainerBox]

What if website require login? then how can we scrap data?

[@luckyyvan9568]

leila, Im using excel 365 ,after pasting the urls I go to navigator pop up page but under the suggested tables there's no adding table using example option

[@user-lk2uv5yo9r]

Thanks, but for me it currently available only in Power BI, need to wait some time for latest Excel))

[@user-vu4kq2um2k]

Hi Leila Thanks for yet another great piece of content. I have an issue in that I do not have the "Add table using example" button that you mention at 4:43. Any ideas?

[@lavahawk]

I have the same thing, maybe they removed it from the navigator.?

[@sagasam1]

Thank you very much for this. Can this be applied to scap information from a PDF document into excel?

[@brianxyz]

Power Query has a PDF connector. Use t to extract info from a PDF file.

[@angelvargas9042]

Hi Leila, when I load the URL into excel as you describe from your video @ 2:43. Only 1 table is in the drop down menu. I was hoping to see different links that are visible on the official website but nothing.

[@virendrahardiya2797]

Hallo ! Ms Laila, Greetings I need to search update status of export container tracking on msc website one by one, can u solve it in power query to get results directly in Excel without going to website?

[@TheGeoffYuen]

Might I know if this can also capture info only appear after clicking ‘Read more’?

[@tejsingh7035]

Maam can we create live updating time in excel without vba

[@kjjohnson37]

Can this be done on Google Sheets too?

[@KeithAul]

I'm assuming this feature isn't available yet. I do have 365 but I dont' get the 'add table using examples'. I don't even get suggested tables.

[@Pezsmapatkany]

I have an up-to-date Excel with a Microsoft 365 (Family) subscription, but my Excel does not support either Web.BrowserContents, nor Html.Table in power query. What else do I need to be able to use these?