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

Dividendology September 28, 2021
Video Thumbnail
Dividendology Logo

Dividendology

@dividendology

About

I believe value dividend investing has proven to be one of the most effect forms of investing as it allows you to buy quality companies at great prices while receiving cash flow, without selling your position in a stock. On this channel, we focus on finding great value dividend paying companies by finding their intrinsic value, creating stock portfolio trackers, tracking my real dividend portfolio each month, and most importantly, finding ways to live off dividend income! Be sure to subscribe! Gain access to my portfolio tracking and stock valuation spreadsheets at Tickerdata.com! I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk.

Video Description

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_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 Get 50% off of Seeking Alpha Premium! https://www.sahg6dtr.com/9D5QH2/R74QP/ The microphone I use: https://amzn.to/3ngqbVz

Transform Your Space Today

AI-recommended products based on this video

Loading...
RoboSeal Rechargeable Mason Jar Vacuum Sealer for Mason Jars Wide and Regular, One Touch Vacuum Sealer for Jars, 10 Lids Included, Digital Battery Indicator, As Seen on TV

RoboSeal Rechargeable Mason Jar Vacuum Sealer for Mason Jars Wide and Regular, One Touch Vacuum Sealer for Jars, 10 Lids Included, Digital Battery Indicator, As Seen on TV

(190)
$36.09
Prime
2K+ bought in past month
Loading...
2 Pack Outdoor Solar Firework Lights, 240 LED Solar Powered Hanging Lights Outdoor Waterproof Hanging Fairy Garden Lights Landscape Lights(Warm White)

2 Pack Outdoor Solar Firework Lights, 240 LED Solar Powered Hanging Lights Outdoor Waterproof Hanging Fairy Garden Lights Landscape Lights(Warm White)

(41)
$25.99
FREE delivery Sat, Jun 14 on your first order
300+ bought in past month
Loading...
Cordless Paint Sprayer for Dewalt 20V MAX Battery.Paint Spray Gun with Powerful Motor and 4 Copper Nozzle.650w Electric HVIP Sprayer for House Painting,Furniture, Wall, Door.(NOT Battery)

Cordless Paint Sprayer for Dewalt 20V MAX Battery.Paint Spray Gun with Powerful Motor and 4 Copper Nozzle.650w Electric HVIP Sprayer for House Painting,Furniture, Wall, Door.(NOT Battery)

(5)
$74.99
FREE delivery Wed, Aug 20
50+ bought in past month
Loading...
Paint Sprayer Electric Spray Gun: 700W Spray Paint Gun with 1200ml Container, 4 Nozzles & 3 Patterns, Adjustable Air Flow, Easy Cleaning for House Painting, Furniture, Fence, Walls, Door (Red)

Paint Sprayer Electric Spray Gun: 700W Spray Paint Gun with 1200ml Container, 4 Nozzles & 3 Patterns, Adjustable Air Flow, Easy Cleaning for House Painting, Furniture, Fence, Walls, Door (Red)

(126)
$65.99
FREE delivery Wed, Aug 20
400+ bought in past month
Loading...
Koolmox Koolmox Canvas Grocery Bag, 6-Pack 22'' Large Bags with Reinforced Handles, 12 Oz Heavy Duty Reusable Washable Grocery Shopping Bags Plain Bags for Teacher Paint Embroidery Draw DIY Art Craft Totes

Koolmox Koolmox Canvas Grocery Bag, 6-Pack 22'' Large Bags with Reinforced Handles, 12 Oz Heavy Duty Reusable Washable Grocery Shopping Bags Plain Bags for Teacher Paint Embroidery Draw DIY Art Craft Totes

(144)
$39.99
PrimeFREE delivery Sat, Jun 14
Loading...
Paint Your Own Moon Lamp Kit, DIY 3D Moon Night Light with Space Figurines & Wooden Stand, Art Supplies Creativity Arts & Crafts Kit for Kids, Toys Girls Boy Birthday Easter Gift Ages 3 4 5 6 7 8 9 10 11 12+

Paint Your Own Moon Lamp Kit, DIY 3D Moon Night Light with Space Figurines & Wooden Stand, Art Supplies Creativity Arts & Crafts Kit for Kids, Toys Girls Boy Birthday Easter Gift Ages 3 4 5 6 7 8 9 10 11 12+

(2,309)
$19.99
FREE delivery Sat, Jun 14 on your first order
400+ bought in past month
Loading...
FineCheer FineCheer 30 Pcs Graduation Party Decoration Graduation Cap Photo Banner Grad Cap Garland Photo Display Decor Black Gold Class of 2026 Wooden Clip String Kits for Congrats Grad Hanging Picture Decor

FineCheer FineCheer 30 Pcs Graduation Party Decoration Graduation Cap Photo Banner Grad Cap Garland Photo Display Decor Black Gold Class of 2026 Wooden Clip String Kits for Congrats Grad Hanging Picture Decor

(2)
$59.09
FREE delivery Feb 18 - 19
Loading...
LaLaGreen Wood Planter Box for Plants (6 Pack, 4x4 Inch) Small Square Wooden Wall Planters for Indoor Plant, Hanging Window Flower Boxes Herb Planter Table Centerpiece Modern Home Garden Office Decor

LaLaGreen Wood Planter Box for Plants (6 Pack, 4x4 Inch) Small Square Wooden Wall Planters for Indoor Plant, Hanging Window Flower Boxes Herb Planter Table Centerpiece Modern Home Garden Office Decor

(80)
$29.99
FREE delivery Sat, Jun 14 on your first order
Loading...
4-Ft Vertical Garden Planter for Outdoor and Indoor Plants - Elevated Planter with 4 Rectangular Plastic Planter Boxes for Patio and Balcony (1-Pack/Espresso Brown)

4-Ft Vertical Garden Planter for Outdoor and Indoor Plants - Elevated Planter with 4 Rectangular Plastic Planter Boxes for Patio and Balcony (1-Pack/Espresso Brown)

(685)
$109.98
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
6-Ft Raised Garden Bed - Vertical Garden Freestanding Elevated Planter with 4 Container Boxes - Good for Patio or Balcony Indoor and Outdoor - to Grow Vegetables Herbs Flowers (1-Pack/Espresso Brown)

6-Ft Raised Garden Bed - Vertical Garden Freestanding Elevated Planter with 4 Container Boxes - Good for Patio or Balcony Indoor and Outdoor - to Grow Vegetables Herbs Flowers (1-Pack/Espresso Brown)

(1,304)
$149.98
PrimeFREE delivery Mon, Jun 16 Only 3 left in stock.
200+ bought in past month
Loading...
Outsunny Raised Garden Bed Wood, Freestanding Planter Stand with 5 Planting Boxes and 4 Hooks, Good for Herbs, Flowers, or Vegetables in Patio Balcony Indoor Outdoor

Outsunny Raised Garden Bed Wood, Freestanding Planter Stand with 5 Planting Boxes and 4 Hooks, Good for Herbs, Flowers, or Vegetables in Patio Balcony Indoor Outdoor

(11)
$109.99
FREE delivery Jun 12 - 13 Arrives before Father's Day
Loading...
Kotagi Personalized Wedding Anniversary Metal Signs | Custom Name Metal Sign | 50th 60th 40th 30th 25th or Any Year Metal Sign Wedding Gift | Metal Wall Art | Anniversary Gift for Couple Parents

Kotagi Personalized Wedding Anniversary Metal Signs | Custom Name Metal Sign | 50th 60th 40th 30th 25th or Any Year Metal Sign Wedding Gift | Metal Wall Art | Anniversary Gift for Couple Parents

(19)
$19.99
$9.99 delivery Jun 26 - Jul 10
Loading...
Dyoart Personalized Camping Signs | Custom Metal Sign | Custom Mountain Campfire Sign | Custom Signs Outdoor Metal | Family Name Sign | Personalized Campfire Name Sign | Metal Wall Art | Camping Signs
Best Seller

Dyoart Personalized Camping Signs | Custom Metal Sign | Custom Mountain Campfire Sign | Custom Signs Outdoor Metal | Family Name Sign | Personalized Campfire Name Sign | Metal Wall Art | Camping Signs

(212)
$26.99
$10.99 delivery Jun 26 - Jul 10
100+ bought in past month