How to scrape in Google Sheets with IMPORTXML
Channel: onlinejournalist
Date: 27/02/2023

Google Sheets makes it possible to fetch information (scraping) from a webpage using an IMPORTXML formula. In this video, made for students on the MA in Data Journalism at Birmingham City University, I explain how the formula works, by writing a formula that scrapes a webpage at https://www.channel4.com/news/team. I also explain reasons why your IMPORTXML formula might not work.