How to Web Scrape Data in Google Sheets! (Import HTML)

In this video, I take you step by step on how to web scrape data in google sheets. I focus on following three main web scraping strategies in this video:

1. Scraping full data sets
2. Scraping individual metrics from data sets
3. Automating the web scraping process in google sheets

The HTML code I use to inspect tables is the following:

var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
If you are trying to inspect a list instead of a table, use the following HTML code:

var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); });
The google sheets codes used in this video are below:

=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_National_Basketball_Association_single-game_scoring_leaders","Table","2")

=IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","7")

=(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","7"),7,2))

=(index(IMPORTHTML("https://finviz.com/quote.ashx?t="&A3,"Table","7"),7,2))

I hope this tutorial was helpful! Let me know if you have any questions. Don't forget to like and subscribe to the channel!

Link to download my portfolio tracking spreadsheets: https://www.patreon.com/dividendology

The microphone I use: https://amzn.to/3ngqbVz

Видео How to Web Scrape Data in Google Sheets! (Import HTML) канала Dividendology