Data studies can be difficult to execute if you aren’t a data scientist, developer, or have hours to spend manually collecting data.
I am always on the lookout for a unique angle to use freely available or potentially scrapable data sources. And I have, admittedly, spent hours upon hours trying to learn Python for writing simple web scraper applications—only to discover the data isn’t accessible, interesting or differentiated enough from what’s already out there.
Thankfully, there is an easy way to collect data from the web without learning a programming language: Google Sheets.
In this video and article, I will explain the simple function I use most often to quickly pull web data within Google Sheets, an example use-case, and to avoid common pitfalls.
How to Scrape Data Using ImportXML
There are import functions for a number of structured data sources, including HTML, CSV, and more. We will focus on ImportXMLbecause it is a simple way …