Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
----------------
Code
----------------

----------------
Datasets
----------------

----------------
Timeline
----------------
0:00 Intro
0:36 ImportHTML
4:54 ImportDATA
5:46 ImportFEED
5:59 Summary

[obama]

If people from the EU are watching this. Use ; instead of, in the function

[jschmidt]

Excellent video. My 6 year son is learning how to read and he also getting interested in sports. I created a custom sports “newspaper” page with standings from all the leagues and stats of his favorite players. I used importhtml to build most of it but your tips on cleaning some of the columns will help solve a few problems I’ve been dealing with. Thank you!

[MrCadutargino]

This channel deserves a lot more subscriptions. Really useful information with a simple and direct explanation. Awesome!

[brianfindlay]

I'm probably never gonna need +90% of the info in this video, but I'm about to go watch more of your videos because I am always down to learn when I've got a teacher who is clear and to the point! Liked and subbed. I wish more YouTubers where like this!

[ziqi]

Thanks for the video! One of the most concise and useful uploads regarding this topic I've seen.

[grainofsalt]

this was really useful for me at my job, thank you! I had to make dashboards using publicly available data and this was a godsend.

[priyankak]

Brilliant Work. Lot of Blesses from Lord Ganesha to you. More Videos on Machine Learning by using Google Sheets commands. This is really great insight. Before this I was breaking my head for web scrap but your video is excellent.

Thank you very much

[mr.himalayan]

At end you said, I don't know how helpful it would be, but let me say for me it can give me passive money my friend. Thanks a lot. Im working on something different

[dishydez]

You have saved me weeks of looking around. I even learned python just to do this! lol. Lifesaver!

[aljohame]

I'm really don't know what you upload usually... But when I saw first half minute of this video directly Gave you like and sub 🌞♥️

[DownToEarthYoutube]

Excellent tutorial. I never done this before and I feel confident to begin

[naveenkumarchitturi]

You don't know something, that you are too Good Bro. I am glad I found your videos. If you plan on doing course videos on python. Count me IN!

[michaelhudson]

Thank you for your excellent videos. I am learning so much, its amazing! I hope you keep sharing your knowledge through these videos. Thank you!

[murators]

This Tutorial is pure gold.
And thanks for the comments and your reply.
So it is not possible to scrap data from sites with Javascript. But it is possible I guess. Any recommendation for a video?

[ajitafhaam]

I have learnt so much from you mr. Thank you so much for your sincere help.

[edwardyiu]

Genius!! ... and I like your get-right-to-the-point style, thank you.

[altonpeques]

This was the best video I found on this topic. Thank you!

[chuckgravity]

Thanks for sharing your great video which helped me with web scraping!

[CE]

Thanks! I'll save time with this tricks. So, a question: do you know if is there any replacement for openrefine?

[buffsurfer]

Hi Dataslice, thanks a lot for this tutorial. I've troubles with yahoo finance also with pages with tables. Always NA "error" appears. May I ask you to make a video to import data from "statistic" page and also from the no-table (unfortunately it is not a table) financials. Thanks a lot and I hope you can reply me. BR, BS