Automating Excel Table from Web Site

basebalplayr33

New Member
Joined
Aug 14, 2013
Messages
44
Hey all,

I am trying to pull a listing of the weekly PGA Tour leaderboard from a website that I will be able to populate and refresh each time I open the document. I tried simply going to Data > From Web > and pasting the URL and clicking ok. The URL that I am trying to use is http://www.cbssports.com/golf/leaderboard . I was able to pull the table into excel and it looks as follows:

CardPosCtryPlayer NameLiveTo ParThruTodayR1R2R3R4Total
[Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record]
[Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record]
[Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record]
[Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record][Record]

<tbody>
</tbody>

Each field is currently being populated with "[Record]" as opposed to the player name, their position, etc. Does anyone have any ideas on how I can fix this using my method or using a macro to pull the data? Below are three other websites that I have found with a leaderboard that refreshes for each week in case this site isn't in a usable format:

https://www.pgatour.com/leaderboard.html

https://www.pga.com/news/golf-leaderboard/pga-tour-leaderboard


http://www.golfchannel.com/tours/pga-tour

As always, thank you all in advance for any help you can provide me!
 
Last edited:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
That page has so many scripts associated. I does a lot of analytics and tracing to see where its called from (right click > view page source). There are programmes that claim to be able to load web info but I couldn't recommend any as I don't use them
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,720
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top