CODEWITHSUNDEEP
google-sheetsxml-import
Ewmi
Ewmi

Reputation: 55

Google sheet - simple importxml formula does not work

I have tried the below simple importxml formula in a cell

=importxml("https://en.wikipedia.org/wiki/List_of_T_postal_codes_of_Canada", "//td")

But this always returns a "formula parse error" message.

I don't get it, this example is soo simple. It should work fine.

Upvotes: 0

Views: 751

Answers (1)

Marios
Marios

Reputation: 27350

I would make the assumption that you are from Canada. Canada (French) locale uses ; instead of , so most likely it has to do with the spreadsheet locale.

Replace , with ;:

=importxml("https://en.wikipedia.org/wiki/List_of_T_postal_codes_of_Canada"; "//td")

Another solution would be to change the locale settings, please read more here on how to do that.

Upvotes: 1

Related Questions