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

dataslice · Beginner ·📰 AI News & Updates ·5y ago

Key Takeaways

The video demonstrates web scraping in Google Sheets using IMPORTHTML, IMPORTDATA, and IMPORTFEED functions, providing examples and code snippets for scraping tables, lists, and RSS feeds.

Original Description

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
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Dataslice · Dataslice · 5 of 16

← Previous Next →

This video teaches you how to use Google Sheets functions to scrape data from websites, including tables, lists, and RSS feeds, and provides examples and code snippets to get you started.

Key Takeaways
  1. Use IMPORTHTML to scrape tables from websites
  2. Use IMPORTDATA to scrape lists from websites
  3. Use IMPORTFEED to scrape RSS feeds from websites
  4. Use Google Sheets functions to import and manipulate data
  5. Practice web scraping with provided datasets and code snippets
💡 Google Sheets provides a range of functions for web scraping, including IMPORTHTML, IMPORTDATA, and IMPORTFEED, which can be used to import and manipulate data from websites.

Related Reads

📰
Will a Degree Still Matter in the AI Era?
In the AI era, a degree may still open doors, but its value is being reevaluated, making it essential to acquire relevant skills to remain competitive
Medium · AI
 📰
Will a Degree Still Matter in the AI Era?
In the AI era, a degree may not be the sole determinant of career success, but it can still open doors and provide foundational knowledge
Medium · Startup
 📰
AI Is Not the Enemy of Journalists, but a Test of Journalism’s Integrity
AI is transforming journalism, but its impact depends on the integrity of journalists, who must learn to work with AI tools while maintaining ethical standards
Medium · AI
 📰
Apple Sends Letters to Dozens of Former Employees Now at OpenAI
Apple is taking aggressive legal action against former employees now at OpenAI, demanding document preservation and meetings with lawyers, in relation to a recent lawsuit
Daring Fireball

Chapters (5)

Intro
0:36 ImportHTML
4:54 ImportDATA
5:46 ImportFEED
5:59 Summary
Up next
I Lost 94% of My Traffic. Then I Found the Unfair Advantage
Conor Martin
Watch →