Roster editing stat conversion

[dante24]

Here's a quick vid on how to do it all.

I use Libre calc it's a cheap excel copy but the file is saved in excel so should work for everyone. But let me know if not and I'll try upload it on google sheets or something.

phpBB [video]

Note: if you see "~N/A" in the "Paste into 2k tool" sheet it's because the sheet cannot find the team abbreviation name. So TOT is changed to ATL in my vid

2K stats conversion tool.xlsx

[positive_comment_guy]

You can just use some excel formulas and copy paste from Bball Ref then copy right back in using the roster edit tool. I’ll look to see if I still have my sheet.

[dante24]

Appreciate that man,

If I get something working I'll share it with the community as well

[dante24]

If you like to have real nba stats in your created rosters just like me then hopefully this spreadsheet can make pasting the data into Looyh 2K tool a lil bit easier.

20221026130719_1.jpg

1. Simply export the Totals data from basketball reference (of your desired player) to excel

bball data.PNG

2. Then copy the raw totals (Everything under the header) and paste into the 2k stats conversion spreadsheet (Orange tab) in sheet tilted "BBall ref"

exported stats.PNG

3. In the 2k stats conversion spreadsheet go to the blue coloured sheet (titled "Paste into 2k tool") and copy the line for the stat year that you want to import into 2k23. Please note DO NOT copy the first column titled year this is just to help you navigate which line of stats you want.

copied data.PNG

4. Go into Looyh 2K tool and in the stats section click the drop down on the desired stat line (it doesn't have to be empty but will obviously overwrite if something is there) and then inside the "player stats editing" page click the 3 horizontal lines to paste from clipboard

pasting into 2k tool.PNG

Hopefully that's easy to follow if you need multiple years then you just repeat steps 3-4 for each stat line. I would have rather used something more sophisticated but excel/libre calc is what I have to hand.

Big thanks to Looyh for making such an incredible tool

[onlyfg]

may I know the version of excel that ur using my guy

[snake212]

Guys i need to start making rosters. But i dont know how to start or how its done. Is there a tutorial out there that can help me start creating rosters and modding them. Because so far no one has created any finished rosters. I gotta do myself i think

[dante24]

may I know the version of excel that ur using my guy

I use Libre calc but saved it in excel 2007-13

[dante24]

Guys i need to start making rosters. But i dont know how to start or how its done. Is there a tutorial out there that can help me start creating rosters and modding them. Because so far no one has created any finished rosters. I gotta do myself i think

It would be better to start a new thread for this question bro that way more people will see.

But I can tell you that you just need Looyh's 2K tool to changes team/player data

[dmx_133]

It's possible to make a little tuto on video ?

[dante24]

It's possible to make a little tuto on video ?

Sure bro. No audio but it's straight forward enough

[dmx_133]

Thanks

[jtc324]

Hey man tried this out but i get an unrecognized text error in the formula on the blue colored sheet whenever i paste the data

[dante24]

Hey man tried this out but i get an unrecognized text error in the formula on the blue colored sheet whenever i paste the data

What's the abbreviation for the team that the player played on that year?

If the abbreviation in "Tm" is not recognised by the sheet then you'll get "Ref.. error"

"TOT" for example just needs to be changed (in the bball ref sheet) to an actual nba team abbreviation for it to work