GISTP 0020
gistp20
Google Sheets: Import Tables and Lists from Websites
Product Description
Google Sheets is a free web-based spreadsheet program available to anyone with a Google account. Like Excel, it has a large variety of formulas, such as ImportHTML, which works by querying a given website for its data structure and returning the results directly in Google Sheets. This task sheet gives an overview of using ImportHTML to scrape tables and lists from a website, thus eliminating both the need to re-type data found on the web and the formatting clean-up that copy/pasting website data typically requires. After establishing how to use the ImportHTML formula, this tutorial details the process of exporting the data to another file type.
Product Details
Pages / Length: 2
Publication Date: 10/2022
- In Stock