Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding)
Learn Power Query now with our Beginner to Pro course: https://link.xelplus.com/yt-pqweb
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://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 ► https://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: https://youtu.be/6lBqYInBldk
You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query: https://youtu.be/8hjgmJk5RiA
➡️ Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/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
Видео Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding) канала Leila Gharani
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://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 ► https://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: https://youtu.be/6lBqYInBldk
You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query: https://youtu.be/8hjgmJk5RiA
➡️ Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/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
Видео Master Excel Web Scraping - Learn How to Import Data AND Images (with ZERO Coding) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![116 Excel Tutorials in 1 Video](https://i.ytimg.com/vi/muTLxMjaZww/default.jpg)
![How to Screenshot on Windows 11 📸 - Cool New Updates](https://i.ytimg.com/vi/UCO80F8_uOs/default.jpg)
![How to Use Excel's NEW Lookup of Images 👉 Professional Dashboards Just Got Easy ➕ Bonus Reveal](https://i.ytimg.com/vi/-BiZjkqgaHc/default.jpg)
![The Secret to Making Hand-Drawn Charts in Excel](https://i.ytimg.com/vi/_jWHD0CK9hY/default.jpg)
![Make better Excel tables: BMW report to the test (Part 3)](https://i.ytimg.com/vi/xLmi3PUDg9k/default.jpg)
![Effortlessly Create Dynamic Charts in Excel: New Feature Alert!](https://i.ytimg.com/vi/ehrXyFPljBo/default.jpg)
![How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project](https://i.ytimg.com/vi/p92Ta3J5vGU/default.jpg)
![Unusual use of Excel's Custom Number Formatting with Conditions & Symbols (Part 2)](https://i.ytimg.com/vi/faPSXNkU1Y0/default.jpg)
![How to Use Excel's New TAKE Function to Impress Your Boss and Colleagues](https://i.ytimg.com/vi/z66-6WVZSFY/default.jpg)
![Why You NEED to know the Time Value of Money Formula (Excel NPV function)](https://i.ytimg.com/vi/SuKXkrc-Lxs/default.jpg)
![5 FREE Cool Add-Ins for PowerPoint to Start Using NOW](https://i.ytimg.com/vi/ssbBaYLq8Mg/default.jpg)
![How You Can Actually Use the NEW Excel BYROW & BYCOL Functions](https://i.ytimg.com/vi/YqaEJiwJj2I/default.jpg)
![Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)](https://i.ytimg.com/vi/YFnXV2be9eg/default.jpg)
![How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit)](https://i.ytimg.com/vi/SgXiepZUumc/default.jpg)
![How to Make a Graph Change Color Based on Value | Conditionally Formatting Charts](https://i.ytimg.com/vi/Gk7GNXplymw/default.jpg)
![Excel Flash Fill For MAJOR Time Saving (7 Examples)](https://i.ytimg.com/vi/1KimYFzET1w/default.jpg)
![How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)](https://i.ytimg.com/vi/AXNPR5q1y08/default.jpg)
![Easiest Way to Edit Visuals in Power BI - Watch before using the new features (Includes hidden tips)](https://i.ytimg.com/vi/V0E_Hrn-iJU/default.jpg)
![Lookup Secrets in Excel: Easily Handle Upper & Lower Boundaries](https://i.ytimg.com/vi/ZY-conYBbYc/default.jpg)
![The Secret to Note-taking for Busy People](https://i.ytimg.com/vi/yxHPScN_ct4/default.jpg)
![How to Use TOCOL | TOROW Function in Excel #shorts](https://i.ytimg.com/vi/K-FyqwKsIME/default.jpg)