Extract Data from Transfermarkt to Google Sheets

Vampire 0
Viewed 53

I am looking for a method to Extract Data from Tranfermarkt.com website, I want to extract stats for any specific player. I tried with

=IMPORTHTML("https://www.transfermarkt.com/zlatan-ibrahimovic/leistungsdatendetails/spieler/3455", "Table", 1)

but couldn't find it working in subject website. Anyone know any method to achieve it?

google-sheets-formula google-sheets
1 Answers

By reading your question update I understand that you want to scrape the table under the Compact tab (see example). Unfortunately that isn't possible. Using any other scraping method, like IMPORTXML will return the same error (Resource at URL not found), implying that this particular webpage has blocked scrapping. You can workaround such circumstances by either looking for a different webpage or modifying your project.

Jacques-Guzel Heron0
Related