CODEWITHSUNDEEP
xmlgoogle-sheets
Bachi
Bachi

Reputation: 6517

ImportXML Google Spreadsheet - can't get xml data

I can't seem to get this very simple example to import anything into Google Spreadsheets:

=ImportXML("http://www.w3schools.com/xml/note.xml","/note/to")

Tried different xml path arguments, but always get an 'analyzing error' and never a value. What am I doing wrong?

Upvotes: 0

Views: 268

Answers (2)

Aurielle Perlmann
Aurielle Perlmann

Reputation: 5529

You need to add two slashed in your xpath:

=IMPORTXML("http://www.w3schools.com/xml/note.xml","//note")

Upvotes: 0

mpietrewicz
mpietrewicz

Reputation: 90

Change the sign in the formula from "," to ";;"

=ImportXML("http://www.w3schools.com/xml/note.xml";"/note/to")

Upvotes: 1

Related Questions