I have put two of the spreadsheets TITANS to the contest at web scraping. We extracted the live data from a website, cleaned it an pulled into both Google Sheets and Power Query. Find out RIGHT NOW how they handled it.
TIMESTAMPS:
00:00 Intro
00:10 Presenting the task
00:56 Scraping web data with Excel
01:36 Excel: Creating dynamic URLs
03:07 Excel: Creating sample custom function
04:46 Excel: Create a query to fetch data from multiple URLs
09:61 Excel: Extracting data from the query using XLOOKUP, CONCAT, MID, LEFT & FIND Functions
17:08 Scraping web data with Google Sheets using =IMPORTHTML function
23:38 Google Sheets: Cleaning the data with INDEX, CONCATENATE, SUBSTITUTE, MID & FIND Functions
FOLLOW ALONG! LINK WITH THE WORKBOOK:
https://www.dropbox.com/scl/fo/q3cdz5...
RELATED VIDEOS:
Playlist with all my videos on Power Query: • Power Query