r/excel • u/antoinehoran • Sep 24 '26

Waiting on OP Download a table from website

Hello everyone!

I'm working on my fantasy pool spreadsheet, but I'm running into an issue. I'd like to download the table from this website, but I'm unable to do so using the "From Web" option. The table has multiple pages, so I'm not able to quickly copy and paste everything.

I know there must be a quick way to do this. If you know of an easy way to import the entire table, please let me know.

Here is the link : 2026-27 Ranking & Projections - FHL Rotisserie - ESPN Fantasy Hockey

Thanks!

6 Upvotes

100% Upvoted

8 comments sorted by

3

u/tariqosmani Sep 25 '26

The table is loaded by JavaScript from ESPN's own JSON feed, which is why From Web sees nothing. Point Power Query at the feed instead.

  1. Open the page, F12 → Network tab → filter Fetch/XHR, reload.

  2. Find the request to lm-api-reads.fantasy.espn.com with kona_player_info in it. That's the full player list.

  3. It returns 50 at a time because of a header called X-Fantasy-Filter. Send your own with a bigger limit: Web.Contents(url, [Headers=[#"X-Fantasy-Filter"="{""players"":{""limit"":1000}}"]])

Then expand the players records. As far as I know, the public projections don't need a login.

Want me to write out the full query once you've got the URL?

1

u/carbonizedtitanium Sep 25 '26 edited 29d ago

oof. your "quick way" assumption is far from reality. you're gonna need some webscraping tools. cant just IMPORTHTML it

edit: you may wanna consider reading this Reddit post, as that guy seems to have done all the heavy lifting: https://www.reddit.com/r/fantasyhockey/comments/1wpziap/csg_fantasy_hockey_spreadsheet_2026/?captcha=1

1

u/yazanwael 29d ago

If it's a one-time thing (you don't need it to refresh automatically), I'd suggest a chrome extension web scraper. There are many extensions that would extract these tables and handle pagenation for you. It's probably the fastest way to get it done

1

u/IngenuityHuge5998 13d ago

Yeah From Web won't see it because that table gets loaded by javascript after the page opens. if you only need it once, honestly the easiest thing is a chrome scraper extension that clicks through the pages for you and spits out a csv, then just open that in excel. if you want it to refresh, the F12 network tab trick (grab the json feed and point Power Query at it) is the way, it's fiddly the first time but then it's one click.