(I put your League ID above, but it didn't work, so I'm guessing you are not publicly viewable.) Then I use the below formulas to parse out the data. I can share a page if you want to see it. Use that formula to pull each 'page' of ranks, so the next set of data count=25, 50, etc. Then, use the following formulas to pull the data needed: =importhtml('','table',0) You need to make the league 'Publicly Viewable' in the settings. I would love it if someone could point me in the right direction. =IMPORTXML('', //* have tried all kinds of tweaks suggested on SO and other sites, including changing ' to ', and adding after div, but nothing seems to be working.Īny helpful hints? I have never tried to do any kind of coding before, but it has been thrilling to build my spreadsheet in the last few weeks and learn. I watched a few videos and read a few blogs that basically said you put the copy of XPATH information into the IMPORTXML, but that keeps giving me an error.įor example, I tried to grab the position/name/stats for Matt Stafford.

Here is an example of one of our team pages: I recently discovered the IMPORTXML function and I have been trying to figure out how I can use it to grab data from various pages of our league.

Mainly I have been using IMPORTHTML to bring tables of information from my league into the Google Spreadsheet, and then processing the data there. I am building a Google Spreadsheet to help synchronize the activity on the Yahoo page with a Google Spreadsheet. I am starting a fantasy football league with some friends, and we will be operating it in the offseason (dynasty/keeper).

Download yahoo sports fantasy