Changing mulitple players data at once

[jparker2112]

So i have been trying to find an easy way to change mass players ages all at once. I tried exporting the file to text but there is so much listed that its impossible to do. I tried via excel and the same thing happened....how do i get it to separate column by column? (meaning age as one column/ml experience as one column/etc...)

is this possible? any help is appreciated

I posted this in the database forum as well

[battists]

Originally Posted by jparker2112

So i have been trying to find an easy way to change mass players ages all at once. I tried exporting the file to text but there is so much listed that its impossible to do. I tried via excel and the same thing happened....how do i get it to separate column by column? (meaning age as one column/ml experience as one column/etc...)

The rosters export in comma-separated format. So here's one approach assuming you're comfortable in Excel:

1. Export the rosters to a text file.
2. Open the text file in Excel. You can do this through the "File/Open" option, or from the Data tab select "Get External Data - Text File." You should get a text import wizard. Select Delimited, and then on the next screen select "comma". That should get you an Excel file with everything divided into columns. (There will be a bunch of commented rows on the top of the file that show the team IDs. You can ignore those and just skip down to the data.)
3. Assuming you just want to change birth year and not month/day, it can be found in column K. Change the dates you want to change.
4. Save the file.
5. Go back into OOTP and import the rosters.

[jparker2112]

good god it worked!!! thanks SOOO much!!

[battists]

Originally Posted by jparker2112

good god it worked!!! thanks SOOO much!!

Any time! Glad it worked; it's been years since I've done this.