Best site for using Excel to import data from web?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tackleberry
    SBR Sharp
    • 12-01-10
    • 441

    #1
    Best site for using Excel to import data from web?
    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
  • greva
    SBR Sharp
    • 03-01-10
    • 487

    #2
    i use baseball-reference.com..

    works great assuming we are talking bases
    Comment
    • Flight
      Restricted User
      • 01-28-09
      • 1979

      #3
      If 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
      • Zuon
        SBR Hustler
        • 03-06-11
        • 93

        #4
        baseball-reference.com appear to be interesting....
        Comment
        SBR Contests
        Collapse
        Top-Rated US Sportsbooks
        Collapse
        Working...