Some datasets can also be directly imported into Google sheets.
Google Sheets: Scraping data from the internet - Google News Initiative
A little bit of NICAR for y'all
If you don’t want to code, there are some libraries and browser extensions that can do some simple scraping.
Scrape data from any website with 1 Click | Data Miner
Web Scraper - The #1 web scraping extension
Web Scraping, Data Extraction and Automation · Apify
Web-scraping can be done using other languages like Python as well.
Journalist's Toolbox: Scraping | Cleaning Data
Some datasets might need you to create local databases to consolidate data as it updates. There are some libraries to do that using JSON adapters.