How to Automate Excel from Web Data – Any Tips or Tools to Get Started? Alternatively, if you prefer a more

For a no-code option, check out Octoparse. It’s a web scraper that exports to Excel, and they have a free plan.

Not as flexible as Power Query or Python, but if you just need simple tables, it’s a lifesaver.

Also, for live updates, maybe look into Google Sheets + IMPORTXML? Works for some sites.