Export All Players to Excel?

Riobard · 09-26-2020, 01:49 PM

I'm looking for a way to export the ratings of all of my players (i.e., active, reserve and inactive) - to Excel. Is there a simple way to do this? Currently I have only been able to export my active and reserve players.

I'm a relatively new player, sorry if this is obvious.

Thanks!

ROY_Angel_Berroa · 09-26-2020, 01:55 PM

I would love to be able to do this too - but I've only been able to do it with my Active and Reserve Roster.

I sign up for a Tourney that is a ways off so I can rotate through my rosters to get all players exported. It takes a lot of time. I focus on batters first and then did pitchers and go by level (Bronze, Iron, etc.)

If anybody else knows a faster way - I'm all ears!

tomnov · 10-01-2020, 02:28 PM

That is about the only way.
It would be nice if they created a way to write a report directly from the manage inactive cards screen. I'm loudly suggesting that when they create a post for suggestions for next year's edition.

One way to cut down on the number of exports you have to make, is use player search to list players from every team, then use duplicate finder within Excel to eventually capture the entire universe of player cards, and use a column in that spreadsheet to mark your players, and copy those to a separate page of the spreadsheet. You then also have the entire card list you can use to find desired players to target in the AH.

Another thing I do, when just exporting stats like that, is setting up a view that shows all stats - pitching & batting - in one view.
Not much to look at with the in-game viewer, but when you export, you get nice neat columns just the same. Cuts the number of exports you need to do in half.
I don't know if there is a physical limit of columns you can display this way -- I'm tempted to export detailed fielding ratings at this point also, now that those often make quite a difference in the quality of players in the higher ranks. Wondering if I can export that many columns at once or if I'd have to break it down.

Vanost · 07-28-2021, 06:26 PM

Trying to figure out how to do this myself from OOTP GO, on a side note they have a nice database available:
https://www.ootpdevelopments.com/per...all-card-list/

09-26-2020, 01:49 PM	#1
Riobard Bat Boy Join Date: Sep 2020 Posts: 4	Export All Players to Excel? I'm looking for a way to export the ratings of all of my players (i.e., active, reserve and inactive) - to Excel. Is there a simple way to do this? Currently I have only been able to export my active and reserve players. I'm a relatively new player, sorry if this is obvious. Thanks!

10-01-2020, 02:28 PM	#3
tomnov Minors (Double A) Join Date: Nov 2017 Posts: 118	That is about the only way. It would be nice if they created a way to write a report directly from the manage inactive cards screen. I'm loudly suggesting that when they create a post for suggestions for next year's edition. One way to cut down on the number of exports you have to make, is use player search to list players from every team, then use duplicate finder within Excel to eventually capture the entire universe of player cards, and use a column in that spreadsheet to mark your players, and copy those to a separate page of the spreadsheet. You then also have the entire card list you can use to find desired players to target in the AH. Another thing I do, when just exporting stats like that, is setting up a view that shows all stats - pitching & batting - in one view. Not much to look at with the in-game viewer, but when you export, you get nice neat columns just the same. Cuts the number of exports you need to do in half. I don't know if there is a physical limit of columns you can display this way -- I'm tempted to export detailed fielding ratings at this point also, now that those often make quite a difference in the quality of players in the higher ranks. Wondering if I can export that many columns at once or if I'd have to break it down. __________________ wasting my time playing PT

09-26-2020, 01:55 PM	#2
ROY_Angel_Berroa Minors (Single A) Join Date: Mar 2020 Posts: 88	I would love to be able to do this too - but I've only been able to do it with my Active and Reserve Roster. I sign up for a Tourney that is a ways off so I can rotate through my rosters to get all players exported. It takes a lot of time. I focus on batters first and then did pitchers and go by level (Bronze, Iron, etc.) If anybody else knows a faster way - I'm all ears!

07-28-2021, 06:26 PM	#4
Vanost Bat Boy Join Date: Jul 2021 Location: Texas Posts: 2	Trying to figure out how to do this myself from OOTP GO, on a side note they have a nice database available: https://www.ootpdevelopments.com/per...all-card-list/