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

Published: 28 September 2021
on channel: Dividendology
35,902
834

Access Tickerdata and my Spreadsheets: https://tickerdata.com/

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...","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:   / dividendology  

Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/

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


Watch video How to Web Scrape Data in Google Sheets! (Import HTML) online without registration, duration hours minute second in high quality. This video was added by user Dividendology 28 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 35,902 once and liked it 834 people.