Channel: Teacher's Tech

Category: Education

Tags: web scrapingjamie keethow to use google sheetsimporthtmlimport html into google sheetsgoogle sheets tutorialteacher's tech tutorialsgoogle sheetshow to limit columns from the import tableimport list from a webpage into google sheetshow to import data from webpages into google sheetsimport tables and lists from a webpage to google sheetsgoogle sheets formulas

Description: This video will show you how to import tables and lists from a webpage to Google Sheets. Using the IMPORTHTML function in Google Sheets allows this import to be done very quickly. You can customize the data you import from the web by limiting columns or adding filters to get exactly what you want in Google Sheets. This is done by adding the QUERY function along with the IMPORTHTML function in Google Sheets. 0:00 Introduction 0:50 Import table from a webpage into Google Sheets 3:01 Import list from a webpage into Google Sheets 3:45 How to limit columns from the import table 5:48 Filter data from the import table into Google Sheets Data I used in the example: en.wikipedia.org/wiki/Lists_of_Netflix_original_films