Hello everyone,
I created an NBA player database spreadsheet, and I am making it public for the community to use.
Since the official spreadsheet is missing some key metrics, I built this sheet to include stats that help with roster construction, including:

• TS% (true shooting percentage)
• To% (turnover percentage)
• FP48 (fouls per 48 minutes)

This spreadsheet includes every single player in the database, fully updated up to the 2025-26 season. I have also included an NBA/ABA filter so you can easily separate the leagues.
Here is the link to access the database:
https://docs.google.com/spreadsheets/d/17yCFxKj9MWUsyZ6khNBnEb1MfLblBzLKv3QFQru7sm0/edit?usp=sharing
To use it for your own leagues, just open the link, go to the top menu, click File, and select Download to save the file to your computer.
Let me know if you have any questions or feedback!

Excellent! I have painstakingly kept up a database over the years where I manually entered in players. It was laborious and often erroneous. Having the actual data is leagues better than what I attempted.
I have three questions and one piece of feedback:

1) Will your original document auto-update when new players are added?
2) What is PID? Player ID?
3) In WIS original database, iirc, it had the actual player position effectiveness not rounded to the whole number. Any chance we can incorporate this?

Feedback: Fouled% - it's the number the sim uses to help determine when a foul occurs. I've always assumed this is the third part of the usage formula but never seen confirmation. If you're data-scraping, I would imagine it would appear and we can confirm. If it doesn't, then I guess doing it the old fashioned way & guessing is easy enough.

Thanks again for your work and for sharing!

Posted by ashamael on 7/6/2026 4:03:00 PM (view original):
Excellent! I have painstakingly kept up a database over the years where I manually entered in players. It was laborious and often erroneous. Having the actual data is leagues better than what I attempted.
I have three questions and one piece of feedback:

1) Will your original document auto-update when new players are added?
2) What is PID? Player ID?
3) In WIS original database, iirc, it had the actual player position effectiveness not rounded to the whole number. Any chance we can incorporate this?

Feedback: Fouled% - it's the number the sim uses to help determine when a foul occurs. I've always assumed this is the third part of the usage formula but never seen confirmation. If you're data-scraping, I would imagine it would appear and we can confirm. If it doesn't, then I guess doing it the old fashioned way & guessing is easy enough.

Thanks again for your work and for sharing!

I added foul% to the spreadsheet and fixed some inaccuracies in regard to calculating advanced stats for shortened seasons (e.g. 2019-20, 2020-21, ect.). My document is something I would have to update manually although if it's possible, I'll look into possibly implementing an auto-update feature. PID is player ID I thought I'd that that to the document because I thought maybe somebody would find a use for that. As for your third question, I'm aware that position effectiveness and other advanced are rounded. I'm pulled all the data directly off the draft center. Is there a way to visually see the unrounded number on the website?

Awesome work. Thank you!