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
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 🤲🏻.
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 😥
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!
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.
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!
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.
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.
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.
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!
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?
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?
Yes, you can do this - you have to implement code into the power query that tells Excel to first paginate your URL, then create tables with those links. I have the code for this, but it's too long to post here. LMK if you are still looking for it.
Thank you for your content miss! I worked at Accenture as a Data Analyst, but I was robbed and my hand was broken, which caused me to be fired from my job. My hand is better now, but i'm not receiving job offers, so I'm taking the opportunity to qualify a little bit more and learn some tools like that and web scraping with python too.
Could you please make a video with the best tool to scrape e commerce web sites? They seem to be all to complex for this solution. I saw a few with power automate but this is as well very complex. Thank you for your great work :)
Hi Leila - you do always very interesting videos - Could it be done on the LinkedIn site on Saved Post?? Should be great to be able to do!! Thanks so much
This looks great, but what version of excel is needed for the "Get Data From Web" function? The option does not seem to exist on the online 365 version. There are so many product options now - any idea which one/s has the feature? We have: 1. Microsoft 365 personal 2. Microsoft 365 business basic 3. 365 business standard 4. 365 business premium 5. Office Home 2024 6. Office 2024
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.
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
And what if this menu item "Structure columns" is grayed out and there is no option to select it? Is there any other way to perform the described actions? And even more, in Excel 2024 there is no "Add by Example" option(((
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
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,
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?
Hi, I have office 365 enterprise but when I put your link in the get data from web following along with your tutorial i dont get suggested tables at all. Is it a version thing?
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
hi thanks for the sharing but it doesn't work for me on excel 365. No tables suggested, only document proposed. I tried the same process in Power Bi and it works. The tables suggested displays and the option button too.
Hello Leila. Did Microsoft have a solution to run VBA script via web browser? I asked because we have a lot of Exel files witch we need migrate to Sharepoint and i did not know exacly what to do. Maybe you can reccomend me some solution?
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.
Hi Leila! I'm trying to grab data from grocery stores online, but some websites require a security check (i.e., "I'm not a robot" checkbox) in the Web View, which prevents Excel from pulling the information from the webpage. Do you know a fix for this?
I am using office 365 but I don't have the option at 4:42 "Add Table Using Examples". Does anyone have an idea on how to fix this? Edit: Btw i'm on version 2311 (build 17029.20108), so according to the pinned comment I should have the feature.
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.
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?
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?
I love this! I am working through it now and have a question. When I get to the step where I click the button "add table using examples" , the website appears over my column headers, so i am unable to type in them. Is there a way to keep the webpage from taking up so much real estate in that step? Thank you in advance!
Thanks, glad you love it! It sounds like Excel might be overlapping with the column headers. Try these steps: Resize the Window: Adjust the size of the Excel window or zoom out (Ctrl + - on Windows or Command + - on Mac) to make more room for the headers. Freeze Panes: If the webpage content is scrolling over your headers, use Freeze Panes (View > Freeze Panes) to lock the headers in place. Minimize the Website: If you're working with a website in the background, try minimizing or resizing that window to give Excel more space to display the headers. By the way, I also offer Python web scraping services if you ever need help extracting data directly from websites into Excel or other formats!
That does not always work in my situation. I tried using the "Add Tabel Using Examples" the image of the web page covers the area to enter configuration information, and you cannot enter the column data info. there are over 1146 items to pull from the site. So, the web site information does not stay in its own window, but it completely covers the column config section. Any Ideas?
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
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
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 🤲🏻.
Great video! I have M.O. 365 but it is not available yet...
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 😥
@@jpeca13 I got the same prompt message "Document" too
Does this feature for insider first and then be published ?
Leila, you have non idea how much I respect you for being so professional and smart! thank you very much for you content.
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!
been watching your videos for a bit now but this is one of the best ones. love the real world example!
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.
Thanks!
Why am I not seeing the "Add table using example" shown at 4:43? It's not on my navigator screen. Thanks
same
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!
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.
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.
Thanks
Thank you!
Thanks!
That you for the great video. I found even more topics than what I was searching for by the examples from your channel you used in the instructions!
Yes Yes Yes -- I am so excited with this and without even thinking I can change the way I record data.
A fabulous video that has been of great help in orienting our new collaborators. Your generosity is highly valued!
Our pleasure. Glad the content is helpful!
I've no words to say thank you. Very much significant topic discussed.
Glad you enjoyed it!
Wow, the trick to format links and images is SO VALUABLE, I'd say more then getting daya from web. Thank you Leila!
Wonderful. We will soon do scrapping in Excel with Power Query web scrapping like what we can already do with Power BI.
Great job, do that have way to solve if the website need to login user id and password in excel?
This lesson was unique on the net. Thank you
Thank you, Lella. You're my new hero!
Great content Leila ❤
Thank you!
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.
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!
Glad it was helpful!
Lucky to be the 1st to be here. Let me relax and learn.
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?
I have the same thing, maybe they removed it from the navigator.?
Hallo Leila, prosit 🎉2024 und vielen Dank für die Informationen im Video - speziell die Datentypen sind genial ! Viele Grüße nach 2351
i really like the way you say "pattern"
At 9:21 I get to the Edit Query and Transform Tab and any options in Structured Column are grayed out, using Excel in Office Pro Plus 2021
Nice approach to web scraping!
How would you deal with web page access being password protected?
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?
Yes, you can do this - you have to implement code into the power query that tells Excel to first paginate your URL, then create tables with those links. I have the code for this, but it's too long to post here. LMK if you are still looking for it.
Thank you so much, Leila.❤
Thank you. Excellent video 📹
Glad you liked it!
anoter fire video thank you so much I actually follwed a long this time :)
Thank you for another awesome video. Does it work on OneDrive? Does it bypass secured website like Dropbox or Google Drive?
Thank you for your content miss! I worked at Accenture as a Data Analyst, but I was robbed and my hand was broken, which caused me to be fired from my job. My hand is better now, but i'm not receiving job offers, so I'm taking the opportunity to qualify a little bit more and learn some tools like that and web scraping with python too.
Good luck finding a job. Hope you get one real soon!
Thanks for your inspirational message, it has helped me too!
Oh Accenture, why doesn't this surprise me. 😮💨
So sorry to hear about your ordeal. Hope you’re recovering well. 🙏
I pray you recover fully 🙏
You are SO GOOD at what you do!!
Could you please make a video with the best tool to scrape e commerce web sites? They seem to be all to complex for this solution. I saw a few with power automate but this is as well very complex. Thank you for your great work :)
Hi Leila - you do always very interesting videos - Could it be done on the LinkedIn site on Saved Post?? Should be great to be able to do!! Thanks so much
This looks great, but what version of excel is needed for the "Get Data From Web" function? The option does not seem to exist on the online 365 version. There are so many product options now - any idea which one/s has the feature? We have: 1. Microsoft 365 personal 2. Microsoft 365 business basic 3. 365 business standard 4. 365 business premium 5. Office Home 2024 6. Office 2024
Excellent Leila!
Thank you! 😃
Thank you for this nice video 📹 👍
Upto the so high skilled... So much cool👍
Fantastic the data type was awesome
Valuable, thanks again Ms.Leila
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.
Super as usual
Great video. Do you have any other video to extract data on paged content?
Bravissima come sempre! then is it possible to view the images easily in power bi? or is there a need for some external application? thanks very much
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
Thank you so much!
Apparently I did not have my excel updated to do it there. However, it worked perfectly in PBI. Thank you for the video.
Thanks for giving the idea to use Power BI !
And what if this menu item "Structure columns" is grayed out and there is no option to select it?
Is there any other way to perform the described actions?
And even more, in Excel 2024 there is no "Add by Example" option(((
Nice trick! And same with cubefonctions for pivot table
Super useful, thank you!
@leila, where can I see an example for UA-cam Chanel and play list ?
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.
hello and thanks for your videos, the image function is it available in any version of excel or just 365
Excellent💯💯💯💯
Please consider creating a similar video for scraping data from IMDB into Excel.
What if website require login? then how can we scrap data?
Great job Leila as always!
Thank you! Cheers!
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
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,
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?
Hi, I have office 365 enterprise but when I put your link in the get data from web following along with your tutorial i dont get suggested tables at all. Is it a version thing?
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
Dear ma'am i wanted your (excel to advance course). BCZ your teaching method is so good please ma'am guide me
Bohat Alla. Excellent 👍
hi thanks for the sharing but it doesn't work for me on excel 365. No tables suggested, only document proposed. I tried the same process in Power Bi and it works. The tables suggested displays and the option button too.
beauty and smart💙
Hello Leila. Did Microsoft have a solution to run VBA script via web browser? I asked because we have a lot of Exel files witch we need migrate to Sharepoint and i did not know exacly what to do. Maybe you can reccomend me some solution?
Thank you for sharing !!
My pleasure!
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.
This is fantastic. Thanks! Is there a way to do something similar for a pdf document?
Sure is :) ua-cam.com/video/p2304BjvrB8/v-deo.html
Hi Leila! I'm trying to grab data from grocery stores online, but some websites require a security check (i.e., "I'm not a robot" checkbox) in the Web View, which prevents Excel from pulling the information from the webpage. Do you know a fix for this?
Perfect, actually you helped me as I have been facing an issue with power automate while I extracted from Web
I am using office 365 but I don't have the option at 4:42 "Add Table Using Examples". Does anyone have an idea on how to fix this?
Edit: Btw i'm on version 2311 (build 17029.20108), so according to the pinned comment I should have the feature.
I have the same issue too, but I guess I'll chill out and wait
wouuuuuuuuuuuuu .... awesome ... muchas gracias !!!
Very powerful ❤
Awesome 👍❤
This is awesome thank you 😄
I'm glad you like it
Hey, this works for example to scrape thousands of reviews from trustpilot for example?
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.
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?
Excellent madam
thank you for your video. Can we add pager by this method?
Thank you for another great video ❤ and inspiration insight to use your own catalog of courses. 🎉
Thanks for sharing
I am accountant
and we work with Excel and SalesForce App
So, How can I connect Excel with reports from Salesforce?
Very cool. Such a bummer that this is NOT a thing for Excel on Mac. At least I have not found it.
The links refer to the course in first column... They do not take to the page.. how to solve this issue
If the site you wanna scrape has a password, like a bank, is that possible somehow with this method or do I need to do someting else?
Hi Leila, Can you teach us how to make Attendance tracker , Productivity tracker on Google Sheets >
I have one doubt. I did the same as you, why my excel doesn't showing up table section but only document section ?
Did an excel update to most current versions yesterday. But when I try to do this I don’t the same items or options.
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?
Hi Leila, I do not see the option Import Data from Web. I am using version 16.77 of MS Excel 365 subscription. Help please. Thanks
I love this! I am working through it now and have a question. When I get to the step where I click the button "add table using examples" , the website appears over my column headers, so i am unable to type in them. Is there a way to keep the webpage from taking up so much real estate in that step? Thank you in advance!
Thanks, glad you love it! It sounds like Excel might be overlapping with the column headers. Try these steps:
Resize the Window: Adjust the size of the Excel window or zoom out (Ctrl + - on Windows or Command + - on Mac) to make more room for the headers.
Freeze Panes: If the webpage content is scrolling over your headers, use Freeze Panes (View > Freeze Panes) to lock the headers in place.
Minimize the Website: If you're working with a website in the background, try minimizing or resizing that window to give Excel more space to display the headers.
By the way, I also offer Python web scraping services if you ever need help extracting data directly from websites into Excel or other formats!
Very useful.
That does not always work in my situation. I tried using the "Add Tabel Using Examples" the image of the web page covers the area to enter configuration information, and you cannot enter the column data info. there are over 1146 items to pull from the site. So, the web site information does not stay in its own window, but it completely covers the column config section. Any Ideas?