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

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)Part 2: https://youtu.be/4A12xqQPJXU—————-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_apple_cultivarsEarthquakes: https://en.wikipedia.org/wiki/Lists_of_earthquakesZha Jiang Mian Recipe: https://www.thespruceeats.com/zhajiangmian-chinese-noodle-recipe-4006698Github CSV: https://github.com/datasets/population/blob/master/data/population.csvNASA RSS Feed: https://www.nasa.gov/content/nasa-rss-feeds/ —————-Timeline—————-0:00 Intro0:36 ImportHTML4:54 ImportDATA5:46 ImportFEED5:59 Summary

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
Part 2: https://youtu.be/4A12xqQPJXU
—————-
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_apple_cultivars
Earthquakes: https://en.wikipedia.org/wiki/Lists_of_earthquakes
Zha Jiang Mian Recipe: https://www.thespruceeats.com/zhajiangmian-chinese-noodle-recipe-4006698
Github CSV: https://github.com/datasets/population/blob/master/data/population.csv
NASA RSS Feed: https://www.nasa.gov/content/nasa-rss-feeds/

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

Be the first to add a review.

Please, login to leave a review
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV

Categories

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
Price:
Free
This website uses cookies and asks your personal data to enhance your browsing experience.