NEW Import Data from Web into Excel 🌐 (TWO Examples)
HTML-код
- Опубликовано: 30 сен 2024
- Get data from the web into Excel using the new web connector.
This new feature of Excel utilise AI to interpret structures on a web page. In this video, we see two examples of importing unstructured data.
The data on the web page is not in a table, but Excel offers suggested table structures for us to import from. And if that is not enough, a web from examples option to tell Excel what we need.
Web from Examples is Amazing!
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📺 Related Videos
Import multiple pages from the web in Excel - • Import Multiple Pages ...
Import multiple Excel files - • Import Multiple Excel ...
🔗 URLs used in the video
IMDB Top 250 - www.imdb.com/c...
Social Blade top 100 RUclipsrs - socialblade.co...
Find more great free tutorials at;
www.computerga...
🔗 Connect with me!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
#excel #powerquery #exceltutorial
Hello Sir, I need your help.
I want a formula that if
• if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated
• If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated
• if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated
Please Reply Sir
Thank you Allan! Very nice examples. But what if your webpage displays only 25 rows and you have to click on " next" . Would that also be possible? Maybe something with "web scraping"? I fyou know more, please show this to the world.... Oh, and next time you also are in the list of most viewed youtubers? 😉
Thank you, Bart ☺️
How to extract the excel table from website with colours of each column is there any options ?
Excellent and it looks so simple! If I might suggest, could you preface the announcement of the videos in your email to advise the version/s of Excel to which the tutorial relates and functions (eg, 2021 v 365). Someone else mentioned "data scraping" ~ what if the website requires login and password (eg, for a bank statement or share/stock portfolio)?
Thank you! And thank you for the feedback.
For the login and password, a window should appear asking for authentication when you connect to the site for the first time.
@@Computergaga Yes, thanks Alan. But can the login process be completed programmatically?
Is it possible to insert only one data from the website, like the price of my brand watch, not entire website? I want to insert one data into one excel cell
Sure! You would either identify the table of data such as the list of watches, then in Power Query filter for the one you want (could even make this dynamic from Excel for the user) and delete all other columns leaving only the price to be imported.
Or you could use the From Examples that I did in the second demo to write the code and bring in the necessary price.
Please help me I have Two workbooks of around 18 MB which is .XLS files saved as web page in my PC when I do import data from these files it took very long time but when I change them to Excel workbook type it become superfast in loading in power query but I have multiple files also it is repetitive task and file can be only downloaded in web page type. Only ...😢
I use web connector for loading web page type from your trick of multiple web page data import video .
Wow! That's great and didn't know about it at all. The transform by example is super. Thanks a lot!
My pleasure, Erica.
Pretty good, ill have to try
Please do!
Thank you Alan. The old navigator window was a pain, good to see improvements in this area inside PQ - I would use it more often!
Cheers, Gareth
The second scenario was a great eyeopener. thanks for sharing.
You're very welcome, Samuel.
Is this only in beta channels?
It is out in General Release. If you have 365, and it's not there yet, it will be very soon.
It has been in beta for months.
Hi @zachg.9208,
I have a Home 365 Subscription.
I was able to practice along with the Expert.
@@ankursharma6157 I have Office 365, version Microsoft 365 MSO (versión 2403 compilación 16.0.17425.20236) 64 bits, and I don't have this feature yet and no updates available.
Thank you very much!...
You're very welcome
Thank You!
You're welcome!