Recently, EA released a blog in which Russ Kiniry explained that there are now CSV files (data files) available for things like the recruiting class, rosters, schedules, and the like. This was big for me, because i'm a spreadsheet kinda guy. I love using them. From your online dynasty (http://dynasty.easports.com) you can go to the recruiting section, and it will say something like "download class" If you save this file and then open it with excel... You can then save it as an excel file. Now... Look at the data. It's pretty jumbled up. A lot of it doesn't make any sense at all at first glance. What you have here is one profile for each position player... And 15 profiles for each athlete. (one for every position except kicker/punter). What we have to do with this jumbled data is sort it (to separate the athletes from all the other positions) and then establish the correct ratings headers for every position. So here's how I go about it and it's pretty easy to do. Once you make a spreadsheet for yourself, you can save that and then open up a new one for every year. This process should take about 10 minutes if you know what you're doing and know Excel. Now... At the very top of the file is a labeling for those ratings. Ignore that, I think it's only good for one position (QB). If you were to do this from scratch you'd have to go through and figure out what order (and which) ratings are there for each position. I'll at least be able to give you that. first we will sort the data. If you don't know how to use excel at all, there are tons of help forums all over the net. You can find easy answers to almost anything on there. I had to teach myself all this crap, so... Remember now you're working with an excel file not a CSV file. Do a double-layered sort. Position (A-Z) Overall Ranking (Low to High) This should create a situation where you see the top athlete at the very top. There will be 15 profiles for him... and then 15 profiles for EACH athlete thereafter. This is a bitch to work with. Below I will list what the ratings are for each position. The ATHLETES have 15 profiles so they have the ratings for just about everything other than Kicking in there. Now... I recommend creating a separate tab for every position. With the athletes I just put all that data that on its own page. I make use of it (quite in depth in fact) but for now I'll challenge you to figure out what you want to do with it Here are the ratings that are included for every position. Again, just finding these out takes quite awhile because it's not included with the file. There may be mistakes. If something is incorrect please notify me. When you start pasting the data for each position into its own tab, here is what you will label them with at the top: QB: SPD AWR THP THA AGI BTK ELU TRK CAR STA INJ HB: SPD AWR BTK CAR TRK ELU AGI BCV STR CTH SFA SPM JKM RTE IBL RBK PBK ACC STA INJ FB: SPD AWR BTK CAR STR TRK RBK RBS RBF PBK PBS PBF IBL AGI SFA BCV CTH ELU STA INJ WR: SPD AWR CTH RTE CIT SPC JMP REL CAR BTK ELU AGI JKM SPM SFA STA INJ TE: SPD AWR CTH CIT RTE RBK RBS RBF PBK PBS PBF IBL AGI RLS BTK STR STA INJ T: SPD AWR RBK RBS RBF PBK PBS PBF IBL AGI STR STA INJ G: SPD AWR RBK RBS RBF PBK PBS PBF IBL AGI STR STA INJ C: SPD AWR RBK RBS RBF PBK PBS PBF IBL AGI STR STA INJ DE: SPD AWR STR AGI TAK PMV (Invalid... All F's) BSH PUR HPW JMP ZCV STA INJ (right after power move for the DE's and DT's there's a rating that doesn't tie in with anything where I guess FMV should have been)... I have a suspicion it's something legitimate and may be useful for athletes... But haven't figured it out yet. Kick power? Who knows. I leave a space on the spreadsheet for this just so I can paste it easily in there... But I ignore it. DT: SPD AWR STR AGI TAK PMV (Invalid... All F's) BSH PUR HPW JMP ZCV STA INJ OLB: SPD AWR ACC AGI TAK PRC (Invalid... All F's) BSH PUR HPW JMP ZCV STA INJ MLB: SPD AWR ACC AGI TAK PRC (Invalid... All F's) BSH PUR HPW JMP ZCV STA INJ CB: SPD AWR MCV ZCV PRS CTH AGI PRC PUR TAK STR JMP HPW BSH ACC STA INJ FS: SPD AWR MCV ZCV PRS CTH AGI PRC PUR TAK STR JMP HPW BSH ACC STA INJ SS: SPD AWR TAK MCV ZCV PRC HPW CTH PUR STR PRS AGI JMP BSH ACC STA INJ K: SPD AWR KPW KAC AGI STR THP THA STA INJ P: SPD AWR KPW KAC AGI STR THP THA STA INJ So... From that sorted data section I highlight all the centers (and their attributes) and copy it, and paste it into cell A2. Row 1 is used for the ratings, headers, etc. Then do the same thing for cornerbacks... And right down the line. doing it once is a chore, but from then on you will have something easy to work with that you can look at the entire class. If you want to translate the grades into actual numbers... consider a VBLOOKUP table. (find out how to make these by searching online) You have to create something off to the side where you have each rating and the corresponding number side by side, and then make another complete heading section for all the ratings, etc... Easy to do. I use an estimate like this: A+ 98 A 95 A- 92 B+ 88 B 85 B- 82 C+ 78 C 75 C- 72 D+ 68 D 65 D- 62 ...except for with awareness, D- can really be around a 50... but whatever. I just go with 62. From here you should have a pretty easy way to look at all the recruits at once. You can really get as in depth as you want with this. Good luck.