RosterResource Excel Workbook Downloads Are Now Available for FanGraphs Members

by
September 1, 2021

Historically, we have made many data tables available for download in a comma-separated values (CSV) format text file. Most of our data grids are rather straight forward and can be translated easily into a CSV file to be consumed by your data analysis tool of choice. Starting today, we are making RosterResource Excel workbook downloads available for FanGraphs Members. You can find the download button to the right of the page underneath the RosterResource navigation.

RosterResource tables presented an interesting challenge, because the tables are not always uniform on a given page. For this reason, we decided to use Excel workbooks to facilitate data downloads. This way you will be able to ingest the data with the correct data headers. Each table will have its own worksheet, so if you download the Padres’ Depth Chart page, you’ll have a separate sheet for the starting lineup, bench, starting rotation, bullpen, etc. To keep everything consistent, all separate tables have their own separate sheets regardless of how similar they might be to other sheets.

A few notes:

  • We have included FanGraphs player ids in the download files.
  • Most downloads are clones of the data grids visible on the RosterResource tool, not the raw data behind the tools.
  • The ancillary data (Latest Roster Moves, Schedule, etc.) at the top of the Depth Charts page is not included.
  • There is only one workbook downloaded per page. We aren’t packaging different tools or teams together.
  • Formatting could be lost from website to Excel worksheet, especially cell color.

Please let us know if there are any issues or bugs. And thank you for being a Member! Your support makes all of our work possible, including new features like this.

You Aren't a FanGraphs Member
It looks like you aren't yet a FanGraphs Member (or aren't logged in). We aren't mad, just disappointed.
We get it. You want to read this article. But before we let you get back to it, we'd like to point out a few of the good reasons why you should become a Member.
1. Ad Free viewing! We won't bug you with this ad, or any other.
2. Unlimited articles! Non-Members only get to read 10 free articles a month. Members never get cut off.
3. Dark mode and Classic mode!
4. Custom player page dashboards! Choose the player cards you want, in the order you want them.
5. One-click data exports! Export our projections and leaderboards for your personal projects.
6. Remove the photos on the home page! (Honestly, this doesn't sound so great to us, but some people wanted it, and we like to give our Members what they want.)
7. Even more Steamer projections! We have handedness, percentile, and context neutral projections available for Members only.
8. Get FanGraphs Walk-Off, a customized year end review! Find out exactly how you used FanGraphs this year, and how that compares to other Members. Don't be a victim of FOMO.
9. A weekly mailbag column, exclusively for Members.
10. Help support FanGraphs and our entire staff! Our Members provide us with critical resources to improve the site and deliver new features!
We hope you'll consider a Membership today, for yourself or as a gift! And we realize this has been an awfully long sales pitch, so we've also removed all the other ads in this article. We didn't want to overdo it.




 

I build things here.

11 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Bruce LetterleMember since 2025
4 years ago

You guys at Fangraphs are outstanding!

19