Home > Back-end >  Get specific information from wikipedia on google spreadsheet (not the entire table)
Get specific information from wikipedia on google spreadsheet (not the entire table)

Time:05-09

I have a table from "Lead rolling actors" from Wikipedia and I want to add some columns to the table with the dates of birth, years active etc for every actor.

enter image description here

Sample 2:

In this sample, 1970–present is retrieved from https://en.wikipedia.org/wiki/Robert_Downey_Jr.

=IMPORTXML("https://en.wikipedia.org/wiki/Robert_Downey_Jr","//td[@class='infobox-data' and ../th[contains(text(),'active')]]")

enter image description here

Note:

  • Although I'm not sure about your current URL of Robert Downey Jr, for example, how about checking the URL again? Because when I use the URL of https://en.wikipedia.org/wiki/Robert_Downey_Jr, your expected values could be retrieved.
  • Related