Converting espn/yahoo stat tables to excel - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Converting espn/yahoo stat tables to excel

Moderator: Baseball Moderators

Converting espn/yahoo stat tables to excel

Postby gmq » Thu Apr 02, 2009 12:05 am

Anyone know any tricks for simplifying transferring stats, be it my own teams projections, another teams projections, whatever it may be, over to excel all in one swipe, and not having to manually type in each number?
gmq
Minor League Mentor
Minor League Mentor


Posts: 409
Joined: 17 Mar 2005
Home Cafe: Baseball

Re: Converting espn/yahoo stat tables to excel

Postby Chicago RedSox » Thu Apr 02, 2009 12:29 am

-Copy all the stats from the Yahoo page
-Go to Excel
-Right Click - Paste Special (or Edit - Paste Special)
-Choose Unitext Code
...that should do it.
Play Ball
Chicago RedSox
Major League Manager
Major League Manager

User avatar

Posts: 1436
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: SanDiego

Re: Converting espn/yahoo stat tables to excel

Postby gmq » Thu Apr 02, 2009 12:44 am

Awesome.

Only thing is that when I pasted, it pasted it all in one row 1, not charted as it is online. Is it possible to right this?
gmq
Minor League Mentor
Minor League Mentor


Posts: 409
Joined: 17 Mar 2005
Home Cafe: Baseball

Re: Converting espn/yahoo stat tables to excel

Postby Chicago RedSox » Thu Apr 02, 2009 12:56 am

I'm not sure what else to try. I do that for Yahoo and it works. Were you trying ESPN?
Play Ball
Chicago RedSox
Major League Manager
Major League Manager

User avatar

Posts: 1436
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: SanDiego

Re: Converting espn/yahoo stat tables to excel

Postby Chicago RedSox » Thu Apr 02, 2009 1:03 am

This is a little bit messy, but it might help save you some time with ESPN.
-Open Excel
-Data - Get External Data
-New Web Query
-Paste in the web address
-Specify only tables
-Done

It'll bring a lot of unnecessary info from the page, but it put the stats into columns for me. Try and see if that helps.
Play Ball
Chicago RedSox
Major League Manager
Major League Manager

User avatar

Posts: 1436
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: SanDiego

Re: Converting espn/yahoo stat tables to excel

Postby JTWood » Thu Apr 02, 2009 1:09 am

Chicago RedSox wrote:This is a little bit messy, but it might help save you some time with ESPN.
-Open Excel
-Data - Get External Data
-New Web Query
-Paste in the web address
-Specify only tables
-Done

It'll bring a lot of unnecessary info from the page, but it put the stats into columns for me. Try and see if that helps.

When you put in the web url, you can load the page in Excel. It will place a box around each table in the page.

If you want, you can then check the specific table you'd like to import. That keeps the superfluous stuff from getting pulled in.

;-D
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Re: Converting espn/yahoo stat tables to excel

Postby JTWood » Thu Apr 02, 2009 1:12 am

gmq wrote:Awesome.

Only thing is that when I pasted, it pasted it all in one row 1, not charted as it is online. Is it possible to right this?

Ignore my last post. You must have done something wrong. I tested, and it does indeed go into one row if you paste like normal. It works just fine if you paste special as text.

You have to right click, select paste special, and then choose one of the text options.

Give that a go before using the web query.
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven


Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 8 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Friday, Oct. 24
(All times are EST, weather icons show forecast for game time)

Kansas City at San Francisco
(8:07 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact