I try to import on my sheets a table o this url
http://travian.kirilloid.ru/build.php#b=18&mb=1&s=1.45
I use this sintaxis:
=IMPORTHTML("http://travian.kirilloid.ru/build.php#b=18&mb=1&s=1.45";"table";1)
What is the error?
Google-sheets – IMPORTHTML – unable to import table
google sheetsimporthtml
Related Solutions
Seems to work for me:
Your formula is in K4. Maybe the first part of what you are concatenating has to be a valid address itself?
- The reason the numbers are duplicated is because they use the ~ wiki template for the purpose of sorting
| {{~|001627}}1 627 - the new better way to sort is: https://meta.wikimedia.org/wiki/Help:Sorting#Specifying_a_sort_key
- I was able to clean with formulas, eg
source cleaned halved check 101240102 709 101240102709 102709 FALSE
Using these formulas:
- cleaned:
=REGEXREPLACE(TEXT(source,"0"),"^0+| ","") - halved:
=replace(cleaned,1,len(cleaned)/2,"") - check:
=cleaned=concat(halved,halved)
A few values don't check out, but the difference between the two halves is small, so that's ok
Related Topic
- Google Sheets IMPORTHTML – Fix ‘Could Not Fetch URL’ Error
- Google Sheets ImportHTML – Import Table Without Forcing Date Format
- Google-sheets – Inability to use `IMPORTHTML` in Google sheets
- Google-sheets – Import table using IMPORTXML
- Google-sheets – Extract table from moneycontrol.com
- Google-sheets – =IMPORTHTML forces content to date format
Best Answer
IMPORTHTML is only able to import data from a well formed web page that include on its source code the table to be imported a HTML tags (table, thead, tbody, tr, th, td) but the table is populate by using JavaScript.
First you should do a further analysis of the page. To do this will need to learn about HTML, JavaScript and CSS.
Related