Use Excel to Scrape Web Data
How to get data from the web into Excel 365 using Power Query. It's fast and easy to do. But POWERFUL too. No need to use 3rd party tools or do any coding.
Get the FREE Excel workbook for this video
Step 1: Sign up for free: https://go.launchexcel.com/email-sign...
Step 2: Log in here: https://courses.launchexcel.com/dashb...
Step 3: Get the workbook: https://courses.launchexcel.com/schoo...
TIP: Stay logged in for quick access to ALL workbook downloads
✅ Learn Power Query Fast: https://go.launchexcel.com/moth-power...
Chapters:
00:00 Have you ever spent hours mindlessly copying and pasting?
01:29 LEVEL 1: Basic Web Query
02:58 LEVEL 2: Customize the Table
11:11 LEVEL 3: Single Text Changes
14:38 LEVEL 4: 2-Letter Country Codes to Full Country Names
19:59 LEVEL 5: Work on Dates
21:57 How to learn Power Query in depth?
Watch this video next
STOP Wasting Time on Repetitive Tasks with Excel VBA
• Excel Macros & VBA for Beginners