RosterResource Excel Workbook Downloads Are Now Available for FanGraphs Members

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.





I code a bunch of things here. I really need to update my blog about statistics at stats.seandolinar.com.

newest oldest most voted
Bruce Letterle
Member
Member
Bruce Letterle

You guys at Fangraphs are outstanding!