IMPORTHTML in Google Sheets with error

Question

I’m trying to create a file to get the data from Alexa’s Audience Geography area/table (https://www.alexa.com/siteinfo/twitter.com) but google Sheets whenever I try to pull appears an error.

=IMPORTHTML("https://www.alexa.com/siteinfo/twitter.com";"//*[@table='demographics_div_country_table']") 

The error says "The IMPORTHTML Function value parameter 2 is [@table='demographics_div_country_table'], but it should be one of the following: table, list'."

How to get data from this table (with countries, percentage and rank)?

Answer 1

I got it using the following requisition:

=IMPORTHTML("https://www.alexa.com/siteinfo/twitter.com";"table";2)

Answer 2

To use Xpath as you mentioned, you need to use IMPORTXML instead of IMPORTHTML.

Example:

=IMPORTXML("https://en.wikipedia.org/wiki/Moon_landing"; "//a/@href")

Reference: https://support.google.com/docs/answer/3093342