I have been using Google Sheets for years, and only recently learned about the formula function IMPORTHTML. This amazing function allows you to import an HTML coded table from a website. Learn how to use it here.
Video produced by WILDERNESS PILGRIM LLC