0

I try to import a HTML table into a Google spreadsheet, but I get an error, that the URL can not be loaded, although it is a pretty simple plain HTML file via a pretty simple plain HTTP connection.

This is what I tried:

=IMPORTHTML("http://classic.battle.net/diablo2exp/basics/levels.shtml";"table";1)

I do not understand why this can not be loaded. Can anybody explain?

2
  • I haven't used IMPORTHTML before so someone could correct me, but it appears that the source has two tables in a single table (to format it in such a way that the two tables will be side-by-side), so could this be causing the error? But I do have a solution. Just copy and paste it into google sheets instead of using IMPORTHTML.
    – David Tan
    May 4 at 12:00
  • The source file pointed by the URL in the formula has several tables. What is the table that you want to import? Also please read webapps.stackexchange.com/q/115664/88163
    – Rubén
    May 4 at 14:21

1 Answer 1

0

try to import table 13

=importhtml("http://classic.battle.net/diablo2exp/basics/levels.shtml","table",13)

and table 14

=importhtml("http://classic.battle.net/diablo2exp/basics/levels.shtml","table",14)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.