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: https://en.wikipedia.org/wiki/Lists_of_Netflix_original_films