CODEWITHSUNDEEP
xpathgoogle-sheets
ybi
ybi

Reputation: 181

extract title using ImportXML in google spreadsheets

I am trying to extract the title of http://help.sketchup.com/en/article/56085 in google spreadsheets using =importxml("http://help.sketchup.com/en/article/56085","//title"). I am getting an error.

What am I doing wrong?

Thx

=importxml(Url,"//title/text()") worked on most of the links except the following three....anyideas?

Example1 Example2 Example3

Upvotes: 1

Views: 9410

Answers (3)

Daniel
Daniel

Reputation: 21

I found the solution:

//td/@title

Upvotes: 2

Aurielle Perlmann
Aurielle Perlmann

Reputation: 5509

All 4 of your links worked completely fine in my sheets with this:

=importxml("url","//title")

This is the same formula you have listed in your questions so I'm not quite sure what the problem is? What kind of an error did you get?

Upvotes: 1

Brianj
Brianj

Reputation: 51

It should be //head/title or to be exact =IMPORTXML("http://help.sketchup.com/en/article/56085", "//head/title")

Upvotes: 5

Related Questions