Import Webpage Data into Google Sheets Using IMPORTXML
Learn how to pull XML structured data such as HTML, CSV, TSV, RSS, and ATOM feeds into your spreadsheet. You will see an example with federal holidays and one with hyperlinks.
More information and live sheet: https://sheetshelp.com/importxml/
Timestamps:
0:00 Intro
0:25 Import Federal Holidays
1:07 URL
3:30 Finding the XPath
5:05 Import a list of hyperlinks
6:11 Playlist of Date Functions
#googlesheets #importxml #webscraping
