Disclaimer: I provide this list without any representation as to the suitability or sufficiency of any of the items referenced for any particular purpose. IANAE. Please do your own assessment or evaluation, particularly if the provider is charging a fee. :).
Also, some of the approaches listed may no longer work. Change is constant.
A cool example of using the hidden AirBnB API (not sure if it still works, but you'll get the idea)
Using Excel to get web table data (super handy!)
A more in depth look at Excel to scrape table data from the web
Find answers to Python errors on Stack Overflow (make an account!)
The Anaconda distribution (Jupyter Notebook) - Community Edition
Sample Notebook: The basics (you may get prompted to request access - just click the button)
Sample Notebook: Web Scraping Example 1 (same as above)
Phantom JS (deprecated)
HtmlUnit (Java)
Puppeteer (headless browsing library for Node.js)
https://anti-captcha.com/ (not free, but relatively cheap)
https://www.deathbycaptcha.com/ (also not free)
https://scrapex.ai/ (in Beta)
An online tool to download a user's tweets (with nice export feature)
Socinator (more a marketing monitoring tool, but worth a mention here)
Zyte (used to be Scrapinghub)
Grab a specific user's photos and videos on Instagram with instagram-scraper
Download all reddit user posts to a Google Sheet using Google Scripts
You Suck at Excel (54 minutes well spent, just go watch it)
Microsoft Power BI (download links here)
Discover what data the big social media companies have about you
Learning about what data your social networks keep about you
I Downloaded the Information That Facebook Has on Me. Yikes. (Watch the embedded video)
Reddit subreddit on webscraping (great for staying up to date or asking questions)
Some of my other resource pages are here.
This page last updated in February 2022