Excel Spreadsheets?

[BronXBombers51]

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?

[Amazinz]

On the Excel menu...

Data-> Import External Data-> New Web Query

[BronXBombers51]

On the Excel menu...

Data-> Import External Data-> New Web Query

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

[fiz]

do you have you import 25 at a time?

[BGbootha]

On the Excel menu...

Data-> Import External Data-> New Web Query

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

you should see what that guy does with baseball stats!!!!!!!!

[pmix]

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.

[Sixxgunn]

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...

[Amazinz]

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.

[Amazinz]

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

[BronXBombers51]

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