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

Published: 21 July 2020
on channel: Dataslice

140,686

2.5k

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
Part 2: • Web Scrape in Google Sheets: IMPORTXM...
----------------
Code
----------------
Tables: var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
Lists: var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); });

----------------
Datasets
----------------
Apple Species: https://en.wikipedia.org/wiki/List_of...
Earthquakes: https://en.wikipedia.org/wiki/Lists_o...
Zha Jiang Mian Recipe: https://www.thespruceeats.com/zhajian...
Github CSV: https://github.com/datasets/populatio...
NASA RSS Feed: https://www.nasa.gov/content/nasa-rss...

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

Watch video Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1) online without registration, duration hours minute second in high quality. This video was added by user Dataslice 21 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 140,686 once and liked it 2.5 thousand people.

60,618

700