Stats Exportable to Excel

[The Loveable Losers]

I have some numbers I want to crunch to rank pitchers but I can't find a good site to export/copy-paste the number from into Excel that brings them into Excel as values (everything's coming in as labels for me and then I can't do any number crunching).

Anyone know of any good place to get current and previous season totals that either will export to Excel or paste in as values?

[Mordraken]

I'm sure there are better sites, or methods, but I go through the "all players" listings in Yahoo and copy/past special text. It takes a while, but it works, and the numbers come in as numbers and not lables/text.

Here's the page:
http://sports.yahoo.com/mlb/stats

Chose a position and start selecting, copying and pasting.

[yellowdog]

http://www.dougstats.com/2005.html

[acsguitar]

I know that there is a way with excel to have it constantly updated using Macros I think or some formula...i konw with like the stock market you can keep stats updated via online ... I'd have to look into it but it would keep your spreadsheet constantly updated.

[StlSluggers]

http://www.dougstats.com/2005.html

I use this one religiously. Easy to work with and even tracks odd stats like Quality Starts. Saves as a text file, but that's easy enough to convert.

Highly recommended!

[The Loveable Losers]

Thanks a ton! I'm working on trying to equally weight the team's offense (which is the primary predicter of wins outside of the pitcher's stats), K/9, WHIP and ERA (for a 5x5 league). If I had more time I'd weight the pitcher's past performance too but this is just a nice little side project to look for pitchers whose value isn't reflected in Yahoo rankings. Unfortunately it will be skewed toward early success this year since I'm not taking the time to post in previous year's stats but a bit of common sense can go a long way there.

[rmeesig]

When pasting into Excel, choose Paste Special...then choose TEXT instead of HTML

[Rirruto]

Saves as a text file, but that's easy enough to convert.

Do you mind filling me in? Never done it before.

[Q]

I have actually created an entire excel file which includes career statistics from every noteworthy pitcher in the league and pasted in formulas that show their hit percentage, walk rate, strikeout rate and home run rate. I used Yahoo's. Those paste in pretty well.

[Amazinz]

There's another alternative to copy/paste called "Web Queries" in Excel. There are plenty of tutorials online, just Google it. They're really easy to use and it's mostly automated. It makes importing data from the Web really easy and it will auto-update itself.