You Can Now Export Free Agent Lists To Excel

Greg Ambrosius · Post by **Greg Ambrosius** » Wed Apr 22, 2015 7:50 am

Several NFBC owners have been asking for an easier way to view all Free Agents in their leagues and one of the suggestions was to add an Export To Excel function. Well, today if you go to the Free Agents New page under Transactions, you will find that Export To Excel button on the right hand side. Enjoy.

Once you open that Excel file, you'll see that all of the players are loaded by position and each position is a separate tab. All categories are right there for you and everything is loaded immediately. In fact, all three sets of stats (Fantasy, Standard and Overview) are displayed on each position's tab. It looks pretty sweet from first glance.

Take a look at it and let us know what you think. Hopefully this again saves you time each week as you manage all of your NFBC teams. Thanks all and good luck.

Hells Satans · Post by **Hells Satans** » Wed Apr 22, 2015 7:52 am

Awesome.

Edwards Kings · Post by **Edwards Kings** » Wed Apr 22, 2015 8:14 am

That is freakin' great!

Cocktails and Dreams · Post by **Cocktails and Dreams** » Wed Apr 22, 2015 3:53 pm

I am not very good at much, and technology is not on that short list. Getting a message that says "The file you are trying to open is not a valid Excel XML Speadsheet."

You can open the file as text in Excel. Then a bunch of jibberish comes up that is not free agent information. If anyone has any simple tip that might help, it would be much appreciated.

Red Sox Nation- · Post by **Red Sox Nation-** » Wed Apr 22, 2015 4:37 pm

Cocktails and Dreams wrote:I am not very good at much, and technology is not on that short list. Getting a message that says "The file you are trying to open is not a valid Excel XML Speadsheet."

You can open the file as text in Excel. Then a bunch of jibberish comes up that is not free agent information. If anyone has any simple tip that might help, it would be much appreciated.

I get the same message.

Navel Lint · Post by **Navel Lint** » Wed Apr 22, 2015 4:52 pm

I was able to open the file, but the stats were not sortable.
I would guess there is a way to do it, but this file doesn't seem to be a straight forward EXCEL download.

Hells Satans · Post by **Hells Satans** » Wed Apr 22, 2015 4:53 pm

It works fine for me

Lunatic · Post by **Lunatic** » Wed Apr 22, 2015 5:13 pm

I saw the export message and got excited and like Chad, not very good at excel (maybe I'll take a class, NOT)

KJ Duke · Post by **KJ Duke** » Wed Apr 22, 2015 8:35 pm

Worked fine for me too. Everything is sortable in excel, just use the sort function.

Cocktails and Dreams · Post by **Cocktails and Dreams** » Wed Apr 22, 2015 11:50 pm

There is nothing to sort is the problem. Thus the message.

Edwards Kings · Post by **Edwards Kings** » Thu Apr 23, 2015 5:28 am

The computer I have tried the function with uses Excel 2007. I get a message saying that the file format is different from what is expected from the extension (*.xls). I can open the file by confirming the source is reliable. When I go to save the file, the default extension on the file I am trying to save is XML 2003. I can convert to XLS, but the cell formats are "General" (i.e. not "Number" or "Custom" as you would expect). I can work with it and it is quasi-sortable, but I guess there are file format issues of varying degrees depending on what version of excel you use.

Deadheadz · Post by **Deadheadz** » Thu Apr 23, 2015 5:49 am

.

May I suggest an Export to CSV would serve many more people than Export to Excel?

.

Greg Ambrosius · Post by **Greg Ambrosius** » Thu Apr 23, 2015 8:42 am

We are meeting with IT in the next hour and have sent your posts to them. I'm sure it has something to do with newer Excel files, but we'll definitely figure it out and find a way to make this an easy download for everyone. When it's working for you, it really works nicely and all stats are right there with tabs for each position. It's a nice feature, but now we have to get this accessible for everyone. We're on it.

Lunatic · Post by **Lunatic** » Thu Apr 23, 2015 3:43 pm

No problem with the excel feature; I was able to access and sort; great feature

mattjb · Post by **mattjb** » Sun Apr 26, 2015 6:46 am

This is very helpful, thank you.

Greg Ambrosius · Post by **Greg Ambrosius** » Sun Apr 26, 2015 8:37 am

mattjb wrote:This is very helpful, thank you.

Thanks. We do realize that the issue some folks may be having is with older Excel documents on their computers. We are looking at ways to make sure everyone can download this easily, but it's obvious that those who can download these files to Excel are saving time on FAAB. That was the goal.

Deadheadz · Post by **Deadheadz** » Sun Apr 26, 2015 5:32 pm

Greg Ambrosius wrote:
Thanks. We do realize that the issue some folks may be having is with older Excel documents on their computers. We are looking at ways to make sure everyone can download this easily, but it's obvious that those who can download these files to Excel are saving time on FAAB. That was the goal.

I've downloaded the very latest version of Microsoft Excel from the App store and when I try to use it to open the file which downloads from my Export to Excel I get the message: "Excel can't open this workbook"

Greg Ambrosius · Post by **Greg Ambrosius** » Sun May 03, 2015 11:04 am

This should be fixed now and you won't get that error message again. It wasn't popping up because of old Excel documents; I'm not sure exactly why that was popping up. But everyone should be able to use this now without any problems. If you see any issues, let me know, but take advantage of this nice feature. Good luck all and enjoy.

Red Sox Nation- · Post by **Red Sox Nation-** » Sun May 03, 2015 1:28 pm

Greg Ambrosius wrote:This should be fixed now and you won't get that error message again. It wasn't popping up because of old Excel documents; I'm not sure exactly why that was popping up. But everyone should be able to use this now without any problems. If you see any issues, let me know, but take advantage of this nice feature. Good luck all and enjoy.

I still can't export to Excel. I get the same problems that Cocktails referenced above.

Greg Ambrosius · Post by **Greg Ambrosius** » Sun May 03, 2015 6:50 pm

Red Sox Nation- wrote:
Greg Ambrosius wrote:This should be fixed now and you won't get that error message again. It wasn't popping up because of old Excel documents; I'm not sure exactly why that was popping up. But everyone should be able to use this now without any problems. If you see any issues, let me know, but take advantage of this nice feature. Good luck all and enjoy.
I still can't export to Excel. I get the same problems that Cocktails referenced above.

Shoot me an email Jason with the error message you're getting and any other info. I will send to IT once again. Thanks and sorry.

Deadheadz · Post by **Deadheadz** » Sun May 03, 2015 8:59 pm

MS Excel on iOS still won't open it.

OpenOffice reads XLS files but says this is an XML file and just shows the first page of code.

Perhaps raw data rather than a fancy workbook would be helpful to more people than the handful using the correct version of Excel?
Is it possible to ask IT to make it a true XLS file with no XML code in it? I think that's the "gobbledy gook" some people are reporting.

.

Greg Ambrosius · Post by **Greg Ambrosius** » Mon May 04, 2015 8:17 pm

This was my fault: During Friday's meeting I was told this was completed and would go live this week. I guess I tuned out the "live next week" part. I'll post when this is live, but it should work for everyone this week.

Greg Ambrosius · Post by **Greg Ambrosius** » Fri May 08, 2015 7:59 am

Okay, now try the Export Free Agent list to Excel. This has been adjusted so that the error message won't occur. Now hopefully everyone should be able to download this.

NFBC Message Boards

You Can Now Export Free Agent Lists To Excel

You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel

Re: You Can Now Export Free Agent Lists To Excel