Share via

Best way to extract a table from a website (ESPN) into Excel

Anonymous
2022-08-24T11:53:21+00:00

I have a Page in My ESPN.com league that has a lot of data I'd like to extract to excel. I've included a screenshot below.

I've tried simply copy and pasting but the player images get in the way. I've also tried web grabbing Chrome extensions like Blackbox (which will let you highlight an area and paste values), however, it's not clean, you can only do one column at a time and you can't scroll down (the page has about 500 names).

I've also tried to go through Excel and do a Get Data from web query but I can't seem to navigate all the way to that page within Excel.

I know this is a silly-ish ask but it's genuinely bothering me that I can't think of a good way to accomplish this.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2022-08-24T13:14:27+00:00

    Open the side in your browser, right-click and save a .HTML or .HTM

    Open Excel, Data \ Import from Text \ Change the extension to All files \ Select the HTML file and transform/load it.

    Andreas.

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-08-24T12:58:42+00:00

    Re: "I've tried simply copy and pasting but the player images get in the way."

    Remove the images?...

    Note...

    "Objects" is selected.

    Click OK

    Press the delete key

    '---
    Nothing Left to Lose

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    (free excel programs)

    0 comments