Subject: How to automate Excel from web data – Any tips or tools to get started?
Hey everyone!
I’ve been manually copying data from websites into Excel, and it’s such a pain. Wondering if anyone knows how to automate Excel from web data? Like, scraping tables or pulling live updates without doing it all by hand.
I’ve heard of Power Query and VBA, but not sure where to start. Are there simpler tools or scripts that work well? Maybe something free or low-cost?
Also, if you’ve got any tutorials or step-by-step guides, that’d be awesome. Just trying to save myself some time (and sanity lol).
Thanks in advance!
Hey everyone!
I’ve been manually copying data from websites into Excel, and it’s such a pain. Wondering if anyone knows how to automate Excel from web data? Like, scraping tables or pulling live updates without doing it all by hand.
I’ve heard of Power Query and VBA, but not sure where to start. Are there simpler tools or scripts that work well? Maybe something free or low-cost?
Also, if you’ve got any tutorials or step-by-step guides, that’d be awesome. Just trying to save myself some time (and sanity lol).
Thanks in advance!