Share via

Automatically pull data from website into excel

Anonymous
2021-04-11T04:29:54+00:00

Hi.

I need help with my personal project. I am trying to pull data from the following website into an excel spreadsheet:

https://www.whoscored.com/Players/107941/Show/Michael-Keane

The data that I need is in the "Latest matches" table. All I need actually is the last three rows of data, more specifically what is in the "played" and "rating" columns. Excel web query doesn't recognize div tables. Can you please help me figure out a way. Also in this table every few days there is going to be a new row added when the player is in action. I want to make this process automatic and always I am going to need only the last three rows of data.

Any ideas?

Microsoft 365 and Office | Excel | For home | 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

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-04-11T10:30:12+00:00

    Hi

    There are plenty of other websites with that information. So do not limit yourself to that one

    https://www.transfermarkt.co.uk/michael-keane/leistungsdaten/spieler/118534/saison/2020/plus/1#GB1

    Using POWER QUERY you could extract and manipulate the data you want

    I extracted this data from the above site

    The video below will help you

    https://www.youtube.com/watch?v=VkDpwSGWPmk

    I hope this helps you and gives a solution to your problem

    Do let me know if you need more help

    On the other hand,

    If the answer helped you.

    Please, consider marking this thread as answered.

    It would help others in the community with similar questions or problems.

    Thank you in advance

    Regards

    Jeovany

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-04-11T07:17:51+00:00

    Hi reszler!

    I'm Jen, an independent advisor and a Microsoft user like you. I'd be happy to help you out with this issue.

    Here's an article that provides a macro as well as a training video that may help you how to scrape data automatically from Websites into Excel.

    https://www.exceltrainingvideos.com/scrape-data...

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

    Best Regards!

    Jen :)

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-04-11T19:28:57+00:00

    Hi. 

    I am aware of the website you are using. Unfortunately it doesn't have all the data that I need. The rating of the player is very important to me.

    OK

    Well... I kindly offered you a solution which is POWER QUERY,

    It is up to you now to find another website that matches your requirements

    0 comments
  4. Anonymous
    2021-04-11T16:42:49+00:00

    Hi. 

    I am aware of the website you are using. Unfortunately it doesn't have all the data that I need. The rating of the player is very important to me.

    0 comments
  5. Anonymous
    2021-04-11T16:39:03+00:00

    Thanks for your reply. Unfortunately I am not a pro. I thought Excel was able to pull data from the website that I mentioned without any coding.

    0 comments