Social PostScore 100
Here's a Google Sheets doc I made to export all of your Sleeper fantasy football data (version 8 update)
Jul 2, 2026/u/BlitzAce71r/DynastyFF
Getting things ready
Loading Fantasy Redzone…
Player mentions
Article text
Hi all, If you're a fantasy player or commissioner like me, you might want your Sleeper data to be a little more accessible. Maybe your league has special rules that Sleeper doesn't support, or maybe you have payouts for weekly high scores, or you like to keep detailed record books of matchup history and player ownership and all of the other little details and stats that us sports people obsess over. If that sounds interesting to you, I've developed a Google Sheets doc that lets you see all of your Sleeper league info in one place. This sheet will let you see weekly and yearly results for each team and player (every player's weekly info for Owner, League, Year, Week, Position, NFL team, Fantasy position that week, Points, Fantasy Opponent, Projected Points, Age, and relevant stats like yards, touchdowns, etc.). It will also pull in your league's schedule, draft results, transaction history, owned draft picks, free agents, and standings. New in v8, a Rosters tab shows the most recent Rosters for every team for a given league and year. For a snapshot of the rosters by week, check the Player Results tab. But for leagues in the offseason, the Rosters tab will show you today's rosters. When you click the link, it will take you to Google Sheets. First go to File - Make A Copy and make your own copy of my document. From there, the instructions are on the first Info tab, but first you will need to authorize it through Google. On the Google warning screen, if you click Advanced you can then go to Go to Sleeper API and it will bring up a window for what permissions to allow. I've published versions of this sheet on Reddit for many years, and I promise that the authorization is not doing anything other than letting the script insert rows into the document. You could even open up Apps Script (Extensions - Apps Script) and run the whole code by an LLM and ask if it's doing anything weird before you authorize. Once you authorize, plug your Sleeper name and the season into the first page and then it will take a few minutes to gather all of the data. One caveat is that the player info (such as which team they play for) is stored in one live source by Sleeper, not as historical data. Which means if you look up a league from 2018 and find, let's say, DeAndre Hopkins, it will show him as WR for BAL even though obviously he was on Houston at the time and has moved around several times since then. My point is, my sheet reads from Sleeper, so if you have any complaints about that data then they're the ones in charge of that. If anyone has any questions, you are welcome to post here or I've put my contact info in the sheet. The goal is just to share this tool with you all because I've found the need to pull data out of Sleeper to be vital to a lot of the various rules and bookkeeping and responsibilities of being a fantasy commissioner and I hope it saves you some time or gives you new ideas or fun projects to work on for your leagues. Link: https://docs.google.com/spreadsheets/d/1SraZo8r6YAR3Utd_x6QCman_lT3qHH3tU6K2RWvabEo/ Dear Mods: I see the message that says "All Apps/Tools/Websites/Platforms/Etc are to be posted in our bi-weekly megathread on Fridays. No individual posts accepted." but I don't see the bi-weekly megathread anywhere. Sorry if this is the wrong place for this. submitted by /u/BlitzAce71 [link] [comments]