# Export Player Database as CSV

**URL:** <https://community.ottoneu.com/t/export-player-database-as-csv/6036>\
**Category:** Ottoneu Fantasy Football\
**Created:** [August 22, 2019, 7:17pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036 "2019-08-22T19:17:01Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![bilbo](https://community.ottoneu.com/letter_avatar_proxy/v4/letter/b/90ced4/32.png) [@bilbo](https://community.ottoneu.com/u/bilbo)\
**Post date:** [August 22, 2019, 7:17pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/1 "2019-08-22T19:17:01Z")

</div>

Is there a way to export the player database as an Excel/CSV file? For a new league, there are no rosters to export, so I’d like to start with a view of all the available players. Looking for something that will give me player name, position, team, 2018 points and (if possible) Ottoneu average salary.

---

<div class="post-metadata">

**Author:** ![doorbot](https://community.ottoneu.com/user_avatar/community.ottoneu.com/doorbot/32/59_2.png) [@doorbot](https://community.ottoneu.com/u/doorbot)\
**Post date:** [August 22, 2019, 7:20pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/2 "2019-08-22T19:20:57Z")

</div>

The average salaries page has an export:  
[https://ottoneu.fangraphs.com/averageValues](https://ottoneu.fangraphs.com/averageValues)

---

<div class="post-metadata">

**Author:** ![nivshah](https://community.ottoneu.com/user_avatar/community.ottoneu.com/nivshah/32/613_2.png) [@nivshah](https://community.ottoneu.com/u/nivshah)\
**Post date:** [August 22, 2019, 7:24pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/3 "2019-08-22T19:24:01Z")

</div>

True for football too:

[https://ottoneu.fangraphs.com/football/average\_values](https://ottoneu.fangraphs.com/football/average_values)

---

<div class="post-metadata">

**Author:** ![doorbot](https://community.ottoneu.com/user_avatar/community.ottoneu.com/doorbot/32/59_2.png) [@doorbot](https://community.ottoneu.com/u/doorbot)\
**Post date:** [August 22, 2019, 7:24pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/4 "2019-08-22T19:24:45Z")

</div>

Ha, just noticed it was football…those conversation tags elude me all the time.

---

<div class="post-metadata">

**Author:** ![bjsperling21](https://community.ottoneu.com/letter_avatar_proxy/v4/letter/b/45deac/32.png) [@bjsperling21](https://community.ottoneu.com/u/bjsperling21)\
**Post date:** [August 24, 2019, 2:42pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/5 "2019-08-24T14:42:16Z")

</div>

The average values page doesn’t show 2018 points as a column. Is there anywhere we’d be able to export that to help formulate our own auction values?

---

<div class="post-metadata">

**Author:** ![nivshah](https://community.ottoneu.com/user_avatar/community.ottoneu.com/nivshah/32/613_2.png) [@nivshah](https://community.ottoneu.com/u/nivshah)\
**Post date:** [August 24, 2019, 3:23pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/6 "2019-08-24T15:23:24Z")

</div>

I think for auctions you probably don’t want to pay for past results. I can add past season and/or current season points to the average values exports, but I’m not sure they are exactly what you want when considering value for the season ahead.

Paging @vibbot on this too.

---

<div class="post-metadata">

**Author:** ![bilbo](https://community.ottoneu.com/letter_avatar_proxy/v4/letter/b/90ced4/32.png) [@bilbo](https://community.ottoneu.com/u/bilbo)\
**Post date:** [August 26, 2019, 2:47pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/7 "2019-08-26T14:47:36Z")

</div>

True… I guess what would be most useful for new leagues would be the average auction values for players in startup leagues (since auction values for existing leagues will be impacted by inflation). But that is probably too specific a data set to be useful to many folks.

---

<div class="post-metadata">

**Author:** ![nivshah](https://community.ottoneu.com/user_avatar/community.ottoneu.com/nivshah/32/613_2.png) [@nivshah](https://community.ottoneu.com/u/nivshah)\
**Post date:** [August 26, 2019, 3:13pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/8 "2019-08-26T15:13:04Z")

</div>

Yeah, that is definitely on my radar:

> [@Question About Average Auction Values](https://community.ottoneu.com/t/question-about-average-auction-values/4005/4):
>
> So, no average values for either baseball or football are first-year only. I have a hidden first-year only flag for baseball that I need to make an interface for, and I need to do the same work for football. I was just talking to an advisor about how filtering down to just first year + live auction prices would be more useful for new owners than seeing the overall averages. Some players are kept at very low prices, and it skews the averages badly. So, consider this noted as a wishlist item of …

I have some work done towards this, and I’ll continue on it today.

---

<div class="post-metadata">

**Author:** ![nivshah](https://community.ottoneu.com/user_avatar/community.ottoneu.com/nivshah/32/613_2.png) [@nivshah](https://community.ottoneu.com/u/nivshah)\
**Post date:** [August 27, 2019, 5:30pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/9 "2019-08-27T17:30:43Z")

</div>

Ok, I’ve made some additions to the Average Values page and the related CSV and XML exports.

These now include an average value for new leagues only, as well as an average value for adds only. The former only includes transactions for leagues created within 1 calendar year of the current date. The latter includes only acquisitions, not trade or inflation transactions.

I think this should help when figuring what players are going for right now, both in fresh leagues and in recent auction drafts / in-season auctions.

---

<div class="post-metadata">

**Author:** ![bilbo](https://community.ottoneu.com/letter_avatar_proxy/v4/letter/b/90ced4/32.png) [@bilbo](https://community.ottoneu.com/u/bilbo)\
**Post date:** [August 27, 2019, 5:42pm UTC](https://community.ottoneu.com/t/export-player-database-as-csv/6036/10 "2019-08-27T17:42:23Z")

</div>

Awesome! Thanks very much. And just in time for the draft in my new league tonight!! 😀
