I'm trying to import two rating scores from a website into google sheets. but I am unable to ge-CodePudding

Home > database > I'm trying to import two rating scores from a website into google sheets. but I am unable to ge

I'm trying to import two rating scores from a website into google sheets. but I am unable to ge

Time：12-22

I want to import the PVE and PVP scores Example

Website:

What ive tried:

=IMPORTXML("https://www.light.gg/db/items/4164201232/1000-yard-stare/","//div[@class=’col-xs-6’]")

CodePudding user response：

You can use

=transpose(importxml(A1,"//div[@class='col-xs-6']/span"))