Import XML into Google Sheets

Question

I am trying to import some data from a website which are updated monthly in google sheets. I am particularly interested in this number: "1910" see this picture.

I typed:

=IMPORTXML("https://ratings.fide.com/card.phtml?event=36050601";"//table[@class='contentpaneopen']/tr[2]//tr[1]//tr[4]//tr[1]/td[1]")

My problem is that it imports both std. and then 1910, because they are in the same cell. Is it possible to get rid of this std. and import only the value 1910?

Ed Nelson · Accepted Answer · 2018-10-20 21:40:06Z

1

You can use index to get the third returned value like this:

=index(IMPORTXML("https://ratings.fide.com/card.phtml?event=36050601","//table[@class='contentpaneopen']/tr[2]//tr[1]//tr[4]//tr[1]/td[1]"),0,3)

answered Oct 20, 2018 at 21:40

Ed Nelson

10.4k2 gold badges32 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Import XML into Google Sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related