Forum Topic

   Back to Forum Search Topics Edit User Settings Scroll to Bottom

 You can add an avatar image from your User Settings page.

avatarsangamc  9/20/2017 4:55 PM

A long shot question but you might be able to help.

I'd like to pull my entire ESPN league into a spreadsheet so I can match players up with FBM projections. THis way I can see free agents that can be picked up without boucing back and forth between 2 web pages.

can you provide any insight into how you do team import for Basbeball and Basketball monster?

i understand it may be too advanced to do with simple spreadsheet importhtml functions but any pointers would help.


0% Agree (0 votes)
avatarsangamc  9/22/2017 10:41 AM

I found a way to do this. It wasnt as bad as i thought




to extract the player names without the fluff, put the following in row1 to the left of the roster data and copy all the way down


=iferror(if(iferror(find("D/ST",C1),0)>0,REGEXEXTRACT(C1,"(.*) D\/ST "),REGEXEXTRACT(C1,"(.*)\,")),"")


0% Agree (0 votes)
avatarkslight  9/22/2017 11:25 AM

Does this only work with public leagues?

0% Agree (0 votes)
avatarsangamc  9/22/2017 12:24 PM

Yes it appears public leagues onlu. I tried it on one of my leagues that is not set to public and the formula returns "imported content does not have query with give index" :(


0% Agree (0 votes)

    Scroll to Top