Importing specific table from html not working (Googlesheet/Excel 2010)

Hello,

In theory the case is simple, I want to use =importhtml and have a table from a site to be in my excel.

But...
I want to import a specific table from

s5.sir.sportradar.com/betradar/en/6/season/85912/standings

When you get there u see 4 tabs (ALL, home, away, LONG) and my aim is to import the LONG version. However the site itself is not generating any specific html for this particular table so every time I am importing to excel it gives me table ALL.

I can also have Home + away and sum it myself, but that's not working either. So from 4 tables available I get every time the only one I'm not interested.

I have tried in source code to find for URL, but nothing there.

All above my skills, maybe someone knows how to solve it.

Thanks,

Is this for Google Sheets?

Administrative Note

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. Thanks.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you this time: https://www.mrexcel.com/board/thread...-html.1185178/)

Thank you, always trying to stick to the forum rules, didn't know that.

https://www.excelforum.com/forum-rul...rum-rules.html