A nice little trick to scrape some data from a list or a table on website is by using the ‘ImportHTML’ function in Google Sheets/Docs. The ‘IMPORTHTML’ function takes 3 parameters –

  • url – the url of the page you want to scrape
  • query – ‘list’ or ‘table’ html element that contains the data
  • index – the index, starting at 1, of the list or table on the page.

Here is a simple example

And the result of the import.

Useful trick to have in your back pocket to quickly scrape data off without having to resort to scrapy or beautiful soup or other tools.

Data Scientist by training with diversions into economics, politics,technology and trivia in no certain order.