IMPORTHTML on Google Sheets with error

0

I'm trying to create a file to grab Alexa's Audience Geography area / table data ( link ) but google sheets whenever I try to pull an error appears.

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

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

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

    
asked by anonymous 05.11.2018 / 14:50

1 answer

0

I was able to use the following request:

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