ImportXML function to extract data

waldymar

Board Regular
Joined
Feb 19, 2009
Messages
238
Dear All,

Kindly need your help. I have a task to extract some data for multiple websites. I found out that it's possible to do with ImportXML in Google Docs. That would be superb but I'm a bit lost how to write the formula. An example, I need to extract the ranking number from the following website:
  • Website - https://www.similarweb.com/website/gazette.com
  • To extract the country (United States) ranking number = 12282
  • Formula I was using was "=importxml("http://www.similarweb.com/website/gazette.com","//div[@class='websiteRanks-valueContainer js-websiteRanksValue']")". However, it didn't work
​Kindly assist me!
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,100,139
Messages
5,472,747
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top