google-sheetsxml-import

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.


Solution

  • 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.