I am looking to link update-able statistics from a baseball website onto my excel spreadsheet. It's very important that when the data is updated on the site that it reflects in my spreadsheet automatically as well.
Here is the url for the page I am referencing:
http://www.baseball-reference.com/pl...=1&submitter=1
You will see that there is a table with a red header entitled : "Stats Summary for matching Plate Appearances"
I am looking to have the associated numbers in the table imported and linked to my spreadsheet. I tried using the "Get External Data" tool in excel but the table does not seem to be compatible, so maybe I have to import the html somehow? I am not that familiar with importing data from sites but I believe it is possible.
Please, any help would be appreciated.
Anyone? Just want to know if it is possible to import the data. Just a beginner when it comes to using Excel in this way.
Bookmarks