When trying to import data from the web using Excel, Excel doesn't seem to like the way most sites have their data organized and I can't select the individual tables I want. The only site I have found that seems to work well is yahoo sports. I was wondering what other people use? Or is it possible to make changes in Excel so that other sites/tables will work better with the import data from web feature? Thanks
Best site for using Excel to import data from web?
Collapse
X
-
TackleberrySBR Sharp
- 12-01-10
- 441
#1Best site for using Excel to import data from web?Tags: None -
grevaSBR Sharp
- 03-01-10
- 487
#2i use baseball-reference.com..
works great assuming we are talking basesComment -
FlightRestricted User
- 01-28-09
- 1979
#3If using Excel 2007/2010, try using the Data tab and the web data source
Sometimes it imports the stuff in a decent fashion. Or you can write a script that cleans up the import.
I have also found that Excel's table import is sketchy. ESPN for example has really easy to read data in table format and the HTML uses very standard <table> tags to layout the data, yet Excel refuses to import the main stat table. GRRR!Comment -
ZuonSBR Hustler
- 03-06-11
- 93
#4baseball-reference.com appear to be interesting....Comment
SBR Contests
Collapse
Top-Rated US Sportsbooks
Collapse
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code