Import Live Web Data to Google Sheets With One Formula

In this video I will show you how to import live data into your google sheet with one formula. This can be used to pull live data from websites to have access to in your google sheet.

►► save 15% with coupon code "annualplan15" at checkout

[Books I Love] Support the Channel

[Connect with Me]

[Social Media]

[anthonyaloisi]

Wow, this video was EXACTLY what I was looking for. I've been building out web scrappers using Excel, but need to convert to using Google Sheets now so more people can access. I need it to pull baseball data from baseball reference, so this video was PERFECT for learn to pull into google sheets using the exact source/site I need to get data from! Thank you for sharing this

[alexzhu]

Is there a way to only convert one line of the table onto your spreadsheet?

[tylershoemaker]

Do you have any tips on being able to execute hundreds of importHTML formulas at once without sheets slowing down?

[markknowles]

Great video. I would like to importHTML from a site that requires a userID and PW. Is there a way to add that to the importHTML function?

[ack-ird]

Very useful! Do you have any videos on how to clean up the data?

[proke]

Is there a way for example to import data from the website and it will automatically refresh the value once the data on the website has changed?

[DerekLibations]

Does this work on a MAC? I can't seem to use the IMPORTHTML function

[perka.km]

Is this possible to do with Ahrefs data?

[kerry-leerodighiero]

But can I add data in columns alongside the live feed, that stays in line if a line of live feed is removed?

[robertocannarile]

Do you know how to get data from Google trends and put in the gsheet?

[ymmuG_Oce]

Is there anyway to use this to get info from a website that requires a username and login for example importing say current crypto valuations into sheets? If so could you paste the formula at all, would be a huge help.

[wasimalam]

What to do when the web data displayed after entering a captcha?

[gregoryjones]

The video is hard to see can you put the exact UNIQUE formula you put infront of the =importhtml. I've enlarged it and listened and watched 25 times and still nothing works for me when I try it. Thanks

[heidiniitsuma]

What if I would like a data "sheet" from somewhere like the YouTube channel analytics?

[bradstein]

I get an error. My sheets doesn't have the dropdown menu. Any idea on how to get that dropdown.

[Alex-zszu]

Wish this worked with airtable but nevermind

[chetrshah]

what if website requires login and password?

[alexandrahaskins]

I'm trying to import my schedule from a company ID/password-protected website. It's not a table or a list so I'm not quite sure how to classify it in the query. I am also getting the message "we cannot parse this operator in this context" at the double slash part of my URL address. Please help

[Combat_Pyro]

does not seem to work in excel running on a mac

[mowe]

I am able to set this up using android . But the data will not change . Even after selecting every min. On Samsung.browser.
Opened chrome and the sheet opens not on the browser so no.option to update every min .
So close, , any help