How to download stock data and industry taxonomy automatically to excel

*I’d like to build a dynamic stock screener to use in excel. More specifically, I’d like to mirror the stock screener from Finviz (

I’m aware google sheets has a syntax to pull stock data automatically, but it doesn’t allow to pull sector/ industry taxonomy. Also, google sheets does give you the functionally to pull HTML tables using =importhtml but I’m not so sure how to use this.*

Any help would be appreciated.

Ps. I can’t afford to pay for Capitaliq or Bloomberg. The market has not been friendly to me.