Excel Spreadsheets? - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to Football Talk

Excel Spreadsheets?

Moderator: Football Moderators

Excel Spreadsheets?

Postby BronXBombers51 » Wed Aug 03, 2005 3:27 pm

Does anyone know how to get the Yahoo player rankings and stats into a Microsoft Excel spreadsheet? I can cut and paste it from ESPN, but when you post the QBs for example, you only get the passing stats and not rush yds/tds or other things like 2 pt conversions.

My league has categories like receptions and such, so I don't know if I could borrow one from someone, as my league's scoring would be different. Everytime I try to cut and paste them from Yahoo, it gets all messed up in Excel. How did you guys do this?
BronXBombers51
Offensive Coordinator
Offensive Coordinator


Posts: 659
(Past Year: 1)
Joined: 7 Apr 2005
Home Cafe: Baseball

Postby Amazinz » Wed Aug 03, 2005 3:28 pm

On the Excel menu...

Data-> Import External Data-> New Web Query
Image
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Postby BronXBombers51 » Wed Aug 03, 2005 3:34 pm

Amazinz wrote:On the Excel menu...

Data-> Import External Data-> New Web Query


Wow, I've never seen that before. Thanks alot Amazinz. ;-D
BronXBombers51
Offensive Coordinator
Offensive Coordinator


Posts: 659
(Past Year: 1)
Joined: 7 Apr 2005
Home Cafe: Baseball

Postby fiz » Wed Aug 03, 2005 3:40 pm

do you have you import 25 at a time?
fiz
Special Teams Staff
Special Teams Staff

User avatar

Posts: 317
Joined: 24 Mar 2004
Home Cafe: Baseball
Location: chillin' out maxin' and relaxin' all cool and all shooting some bball outside of the school

Postby BGbootha » Wed Aug 03, 2005 3:55 pm

BronXBombers51 wrote:
Amazinz wrote:On the Excel menu...

Data-> Import External Data-> New Web Query


Wow, I've never seen that before. Thanks alot Amazinz. ;-D


you should see what that guy does with baseball stats!!!!!!!! 8-o
Image
BGbootha
General Manager
General Manager

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeCafe Blackjack Weekly Winner
Posts: 3830
Joined: 18 Feb 2003
Home Cafe: Football
Location: Teaching is the Greatest Job in the World!!! (during the Summer)

Postby pmix » Wed Aug 03, 2005 4:25 pm

Amazinz wrote:On the Excel menu...

Data-> Import External Data-> New Web Query


Could you elaborate quickly on the process. I love messin around with Excel spreadsheets but have never known how to do what you just shown. Some quick basic instructions would be nice. If not I will have some homework to do.
pmix
Head Coach
Head Coach

User avatar
Mock(ing) Drafter
Posts: 1206
Joined: 25 Sep 2002
Home Cafe: Football
Location: Go Zygi Go

Postby Sixxgunn » Wed Aug 03, 2005 4:26 pm

pmix wrote:
Amazinz wrote:On the Excel menu...

Data-> Import External Data-> New Web Query


Could you elaborate quickly on the process. I love messin around with Excel spreadsheets but have never known how to do what you just shown. Some quick basic instructions would be nice. If not I will have some homework to do.


I'm curious as well... ;-D
[url=http://imageshack.us][img]http://img170.imageshack.us/img170/1065/sixgunn7ao0rc.jpg[/img][/url]
Sixxgunn
General Manager
General Manager

User avatar

Posts: 4887
(Past Year: 3)
Joined: 20 Jul 2004
Home Cafe: Football
Location: Who?

Postby Amazinz » Wed Aug 03, 2005 5:04 pm

pmix wrote:
Amazinz wrote:On the Excel menu...

Data-> Import External Data-> New Web Query


Could you elaborate quickly on the process. I love messin around with Excel spreadsheets but have never known how to do what you just shown. Some quick basic instructions would be nice. If not I will have some homework to do.

Sure. After you click New Web Query a mini-browser pops up. Just go to the page that has the stats you want to import. It'll take a few seconds for Excel to do it's thing (parse the HTML) and it will break the web page down into tables. Excel highlights the tables with yellow boxes that have black arrows in them. When you put your mouse over any of the arrows it will show what section of the page it is indicating. Most of the time you can tell just by looking. Then you click all of the boxes of each table you want to import and then click the IMPORT button. That's it. You can do a lot of advanced stuff with it too once you get comfortable with it but that's the basics. If you have any other questions just let me know.
Image
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Postby Amazinz » Wed Aug 03, 2005 5:14 pm

Here's a pic of what it should look like. In this example I'm importing '04 QB stats from ESPN:

Image
Image
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Postby BronXBombers51 » Wed Aug 03, 2005 8:37 pm

Yeah, I figured it out immeadiately. That's a great tool, makes creating ranking a whole lot easier. Thanks for the knowledge again. ;-D
BronXBombers51
Offensive Coordinator
Offensive Coordinator


Posts: 659
(Past Year: 1)
Joined: 7 Apr 2005
Home Cafe: Baseball

Next

Return to Football Talk

Who is online

Users browsing this forum: No registered users and 5 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


Get Ready...
The 2014 NFL season kicks off in 7:43 hours
(and 36 days)
2014 NFL Schedule


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