NEW Import Data from Web into Excel 🌐 (TWO Examples)

Computergaga June 7, 2024
Video Thumbnail
Computergaga Logo

Computergaga

@computergaga

About

Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work. Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI. If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody. Who am I? My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas". I love working with data and helping people improve their Excel skills and save time. I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.

Video Description

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 - https://youtu.be/STjBoS1rQuQ Import multiple Excel files - https://youtu.be/7Gy6Y5ghiNc 🔗 URLs used in the video IMDB Top 250 - https://www.imdb.com/chart/top/?ref_=nv_mv_250 Social Blade top 100 YouTubers - https://socialblade.com/youtube/top/100/mostsubscribed Find more great free tutorials at; https://www.computergaga.com 🔗 Connect with me! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #excel #powerquery #exceltutorial

Excel Data Import Must-Haves

AI-recommended products based on this video

Loading...
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

(137)
$19.97
FREE delivery Sat, Jun 14 on your first order
Loading...
Leaf Blower Air Booster, Universal 2–4 in Leaf Blower Nozzle Attachment, Driveway Cleanup Turbo Air Nozzle Extension Boosts Speed & Power for Yard Lawn (Orange)

Leaf Blower Air Booster, Universal 2–4 in Leaf Blower Nozzle Attachment, Driveway Cleanup Turbo Air Nozzle Extension Boosts Speed & Power for Yard Lawn (Orange)

(3)
$15.98$12.59
FREE delivery Nov 21 - 24
Loading...
Leaf Blower Air Booster, Leaf Blower Nozzle Attachment, Turbo Nozzle Extension Boosts Speed & Power for Yard, Lawn, and Driveway Cleanup (Black)

Leaf Blower Air Booster, Leaf Blower Nozzle Attachment, Turbo Nozzle Extension Boosts Speed & Power for Yard, Lawn, and Driveway Cleanup (Black)

(0)
$19.99
FREE delivery Nov 24 - Dec 12
Loading...
240W Portable Solar Panels for Power Station, 23.5% High Efficiency, 240 Watt Monocrystalline Foldable Solar Panel Charger with USB/20V DC Output Adjustable Kickstand for Camping, Off-Grid Living

240W Portable Solar Panels for Power Station, 23.5% High Efficiency, 240 Watt Monocrystalline Foldable Solar Panel Charger with USB/20V DC Output Adjustable Kickstand for Camping, Off-Grid Living

(22)
$491.55
FREE delivery Aug 12 - 14
Loading...
Asus ZenScreen 15.6” 1080P Portable Monitor (MB16ACV) - Full HD, IPS, Eye Care, Flicker Free, Blue Light Filter, Kickstand, USB-C Power Delivery, for Laptop, PC, Phone, Console, Antibacterial Surface , BLACK

Asus ZenScreen 15.6” 1080P Portable Monitor (MB16ACV) - Full HD, IPS, Eye Care, Flicker Free, Blue Light Filter, Kickstand, USB-C Power Delivery, for Laptop, PC, Phone, Console, Antibacterial Surface , BLACK

(2,097)
$209.98$152.10
FREE delivery Jan 13 - 27
50+ bought in past month
Loading...
AstroAI 27" Snow Brush and Detachable Ice Scraper with Ergonomic Foam Grip for Cars, Trucks, SUVs (Heavy Duty ABS, PVC Brush, Orange)

AstroAI 27" Snow Brush and Detachable Ice Scraper with Ergonomic Foam Grip for Cars, Trucks, SUVs (Heavy Duty ABS, PVC Brush, Orange)

(33,617)
$16.99
FREE delivery Sat, Jan 3 on your first order
3K+ bought in past month
Loading...
Jectse High Resolution Screen of 14.5 Inches 60 Hz Update rate: 4k IPS Portable Screen for a Switch, Excellent for Work and Entertainment

Jectse High Resolution Screen of 14.5 Inches 60 Hz Update rate: 4k IPS Portable Screen for a Switch, Excellent for Work and Entertainment

(0)
$254.59
FREE delivery Aug 27 - Sep 17
Loading...
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

(137)
$19.97
FREE delivery Sat, Jun 14 on your first order
Loading...
KEXIN 64GB USB Flash Drive 3 Pack - Swivel Thumb Drives with LED Indicator, High-Speed USB 2.0 (Pink/Yellow/Cyan) for Data Storage, Bulk Pen Drives Multi-Color Pack

KEXIN 64GB USB Flash Drive 3 Pack - Swivel Thumb Drives with LED Indicator, High-Speed USB 2.0 (Pink/Yellow/Cyan) for Data Storage, Bulk Pen Drives Multi-Color Pack

(1,558)
$17.75
Prime
100+ bought in past month
Loading...
Flash Drive 16GB 5 Pack USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pendrive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (16G, 5Pcs Mixed Color)

Flash Drive 16GB 5 Pack USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pendrive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (16G, 5Pcs Mixed Color)

(983)
$18.04
FREE delivery Sun, Aug 10 on your first order
100+ bought in past month
Loading...
5 Pack 32GB Flash Drive, USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pen Drive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (32G, 5Pcs Mixed Color)

5 Pack 32GB Flash Drive, USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pen Drive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (32G, 5Pcs Mixed Color)

(965)
$24.69
FREE delivery Sat, Jun 14 on your first order
Loading...
2 Pack 32GB USB Flash Drive, 2.0 USB Stick Thumb Drive,Waterproof Function with Lanyard USB Memory Stick for Data Storage and Backup, Black

2 Pack 32GB USB Flash Drive, 2.0 USB Stick Thumb Drive,Waterproof Function with Lanyard USB Memory Stick for Data Storage and Backup, Black

(332)
$15.19
FREE delivery Sat, Jun 14 on your first order