Google sheet - simple importxml formula does not work

Question

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.

Answer 1

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.