Computer help. Stats to Excel - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Computer help. Stats to Excel

Moderator: Baseball Moderators

Computer help. Stats to Excel

Postby Steve-o » Wed Mar 12, 2008 10:08 am

I thought I'd put this in here rather than the leftovers because it is not really about baseball.

I am trying to take stats displayed in Firefox/IE and move them into an excel spread sheet. I've tried just copying and pasting, but the formating gets screwed up (each stat is not getting a separate cell or all the information is being copied into only one cell). Does any one know a way to save these stats as a comma delineated or tab delineated file (I think it's called a csv file).

The particular stats are from this page or this page

Thanks!
In my fridge: Founders Kentucky Breakfast Stout (KBS), Central Waters Peruvian Morning, Bell's Batch 10,000, Dale's Pale Ale, Capital Brewery Amber, New Glarus Moon Man, and Guinness.
Steve-o
Major League Manager
Major League Manager

User avatar

Posts: 1879
Joined: 7 May 2004
Home Cafe: Baseball
Location: Finally back home. A sweet 15 mi from Miller Park.

Re: Computer help. Stats to Excel

Postby knapplc » Wed Mar 12, 2008 10:18 am

I was able to get both of those into a spreadsheet with simple copy/paste. You have to do a bit of work to sort them out, since they don't go straight into a table all lined up nice and neat, but that's not too difficult.

The problem you're having is a result of trying to get one kind of table to correlate to another kind. Internet stats are laid out in a table designed for viewing on web pages, not spreadsheets, so there isn't a 1:1 relationship. If you're going to grab stats off of web pages like this, you're going to have to expect to do some legwork to clean them up for use.

Are you using a Mac or a PC? What versions of FF and IE are you using? What generation of Excel?
Keep wreves in General Talk in 2011!
knapplc
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicGolden Eagle Eye
Posts: 7870
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's "ell see." ELL SEE!!!

Re: Computer help. Stats to Excel

Postby Steve-o » Wed Mar 12, 2008 10:27 am

PC.
Mozilla 2.0.0.12
IE 7.0.5730.11
Excel 2002 (I've got the latest version of office at home, if you think it will help)

It's the legwork that I wanted to avoid. I wanted to avoid having to take the time to break down a line like this:

12 41 6 17 3 1 0 8 22 2 6 2 0 .442 .537 .415

into separate cells. Maybe I can't though...

In the past I have ended up manually breaking down similar information into separate cells so that I can manipulate it. I was hoping there was a shortcut. I usually get previous years info from Lahman or Doug's, but I wanted to play with the ST stats a bit more this year.
In my fridge: Founders Kentucky Breakfast Stout (KBS), Central Waters Peruvian Morning, Bell's Batch 10,000, Dale's Pale Ale, Capital Brewery Amber, New Glarus Moon Man, and Guinness.
Steve-o
Major League Manager
Major League Manager

User avatar

Posts: 1879
Joined: 7 May 2004
Home Cafe: Baseball
Location: Finally back home. A sweet 15 mi from Miller Park.

Re: Computer help. Stats to Excel

Postby knapplc » Wed Mar 12, 2008 10:46 am

I'm kind of confused why it would be all in one line like that. Maybe it's the 2002 generation of Excel? Like I said, I did a copy/paste just now and it was separated into individual cells. You're not doing a "Paste Special" or something like that, are you? You're just doing control-c/control-v, right?

I've had that kind of stuff happen before, but never when getting stats from MLB or CBS. Usually it happens when I grab stuff from Yahoo.

If worse comes to worse, I'll try to grab those two pages for you and host the file somewhere sometime today. But it would be good for you to figure out why you're getting that all-in-one-line thing happening.
Keep wreves in General Talk in 2011!
knapplc
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicGolden Eagle Eye
Posts: 7870
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's "ell see." ELL SEE!!!

Re: Computer help. Stats to Excel

Postby Tavish » Wed Mar 12, 2008 10:51 am

Do a web query.

1. Data > Import External Data > New Web Query
2. Copy/Paste the address into the address bar.
3. Select the table you want to import.
4. ????
5. Profit!
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 34)
Joined: 3 May 2004
Home Cafe: Baseball

Re: Computer help. Stats to Excel

Postby Steve-o » Wed Mar 12, 2008 11:01 am

knapplc wrote:I'm kind of confused why it would be all in one line like that. Maybe it's the 2002 generation of Excel? Like I said, I did a copy/paste just now and it was separated into individual cells. You're not doing a "Paste Special" or something like that, are you? You're just doing control-c/control-v, right?

I've had that kind of stuff happen before, but never when getting stats from MLB or CBS. Usually it happens when I grab stuff from Yahoo.

If worse comes to worse, I'll try to grab those two pages for you and host the file somewhere sometime today. But it would be good for you to figure out why you're getting that all-in-one-line thing happening.


Yup. Straight ctrl-c. (also did right click copy). I want to figure it out for the future so that I can do it. I'll try it at home during lunch and see if it copies better in a newer version of excel. I know I have had this problem in the past with other sites, so I wanted to put it out there to see if there was a workaround anyone knows about.
In my fridge: Founders Kentucky Breakfast Stout (KBS), Central Waters Peruvian Morning, Bell's Batch 10,000, Dale's Pale Ale, Capital Brewery Amber, New Glarus Moon Man, and Guinness.
Steve-o
Major League Manager
Major League Manager

User avatar

Posts: 1879
Joined: 7 May 2004
Home Cafe: Baseball
Location: Finally back home. A sweet 15 mi from Miller Park.

Re: Computer help. Stats to Excel

Postby AussieDodger » Wed Mar 12, 2008 11:25 am

Tavish wrote:Do a web query.

1. Data > Import External Data > New Web Query
2. Copy/Paste the address into the address bar.
3. Select the table you want to import.
4. ????
5. Profit!


This is Excel not underpants gnomes }:-)
Image
AussieDodger
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle Eye
Posts: 11354
(Past Year: 16)
Joined: 22 Jan 2006
Home Cafe: Baseball
Location: What do you mean, Flash Gordon approaching?

Re: Computer help. Stats to Excel

Postby Steve-o » Wed Mar 12, 2008 11:27 am

Tavish wrote:Do a web query.

1. Data > Import External Data > New Web Query
2. Copy/Paste the address into the address bar.
3. Select the table you want to import.
4. ????
5. Profit!


Sweet! Thanks Tavish.
In my fridge: Founders Kentucky Breakfast Stout (KBS), Central Waters Peruvian Morning, Bell's Batch 10,000, Dale's Pale Ale, Capital Brewery Amber, New Glarus Moon Man, and Guinness.
Steve-o
Major League Manager
Major League Manager

User avatar

Posts: 1879
Joined: 7 May 2004
Home Cafe: Baseball
Location: Finally back home. A sweet 15 mi from Miller Park.

Re: Computer help. Stats to Excel

Postby Tavish » Wed Mar 12, 2008 7:57 pm

AussieDodger wrote:
Tavish wrote:Do a web query.

1. Data > Import External Data > New Web Query
2. Copy/Paste the address into the address bar.
3. Select the table you want to import.
4. ????
5. Profit!


This is Excel not underpants gnomes }:-)

The philosophy is all-encompassing. ;-D
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 34)
Joined: 3 May 2004
Home Cafe: Baseball

Re: Computer help. Stats to Excel

Postby thedude » Wed Mar 12, 2008 8:31 pm

You can also just cut and paste and click "text to colums" under data.
"I do not think baseball of today is any better than it was 30 years ago... I still think Radbourne is the greatest of the pitchers." John Sullivan 1914-Old athletes never change.
thedude
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicPick 3 Weekly Winner
Posts: 8413
(Past Year: 4)
Joined: 18 Dec 2004
Home Cafe: Baseball
Location: The Good Life

Next

Return to General Talk

Who is online

Users browsing this forum: assiquate and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Jul. 26
(All times are EST, weather icons show forecast for game time)

Toronto at NY Yankees
(1:05 pm)
St. Louis at Chi Cubs
(4:05 pm)
Washington at Cincinnati
(4:05 pm)
Baltimore at Seattle
(4:10 pm)
Arizona at Philadelphia
(7:05 pm)
Boston at Tampa Bay
(7:10 pm)
indoors
Chi White Sox at Minnesota
(7:10 pm)
NY Mets at Milwaukee
(7:10 pm)
Cleveland at Kansas City
(7:10 pm)
Miami at Houston
(7:10 pm)
San Diego at Atlanta
(7:10 pm)
Oakland at Texas
(8:05 pm)
Pittsburgh at Colorado
(8:10 pm)
Detroit at LA Angels
(9:05 pm)
LA Dodgers at San Francisco
(9:05 pm)

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