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!
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.
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!
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.
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.
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.
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!
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?
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.
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.
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 :)
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
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.
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
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!
I tried to repeat this tutorial using the Xelplus web page, but without success. No tables were identified or suggested, just a document. I tried it twice in case I'd made a mistake.
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! 😅
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?
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?
@@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.
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
This is amazing! But im having some issues with it. I tried this today bc I wanted to scrap some images from a website, despite my best effords I couldn't do it, because it seems like the images have one url when I hover them, but when i copy the image url it gives me a different one, even after i tried looking for any of those 2 urls, excel can't find any images...
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 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?
Good Job, LEILA ...BUT, it seems that " AI " is simply the advanced version of "MACRO" recording, which has been a feature of Excel for years ...along with programming VBA to compound blocks and RSS feeds into an 'automated function' that is user friendly like an APP ...a good beginning that is headed to the same place as social sites in anticipating stereotypes rather than founding innovations and improvements to the system ...therefore rendering the method obsolete and shelved in favor of old fashioned holographic marketing ...getting past amateurish conversions has become a lynchpin trigger to avoid a paradox (Pandora's Box) and the statement ( TMI-Too Much Information ) ...taking the 'Grind' out of intelligence has proven difficult if not impossible
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.
What if after copy/pasting the URL, there are no tables identified? How can I scrape and look for the information that I need? I hope this gets noticed. Thanks Leila!❤
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.
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?