I'v read a lot on here about people "scraping" data from a website and converting it into excel (i think?).
Now, i have like 0 knowledge of programming, however i am good at excel, so i am curious how do-able this is, and how hard it would be for me to learn to do this.
I would like to take a website such as
http://sports.yahoo.com/nhl/players/...y7eJzqAEdivLYF and convert all those stats into excel.
Now i realize i can just highlight the data, copy and paste it, and clean it up, showing me the columns i'd like to see. I guess i can just keep copy and pasting values, knowing which columns theyll be in, and set up equations to only extract data from those columns.
My question is...is there a faster way to do this? Is there a way i can just simply change the player # in the yahoo sports game log link, and have excel automatically extra data the way i want it to? I guess i just want to cut down on taking the time to copy and paste the table and cleaning it up, was hoping there was some kind of code to do that for me?