Import table not working? GoogleSheets

[Nightcrawller]

Hi,

Import table is not working for this site.

http://www.oddsportal.com/cricket/north-central-america/caribbean-premier-league/results/

=importhtml("http://www.oddsportal.com/cricket/north-central-america/caribbean-premier-league/results/", "table", 2)

I tried all table numbers.

 

[igold]

Re: Import table not working?

You do realize that importhtml is a Google sheets function. That said, when I tried your formula on a Google worksheet it returned the below results. You would have to add the Index function to isolate any particular cell.

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"></colgroup><tbody>[TR]
[TD]Premier League[/TD]
[TD]LaLiga[/TD]
[/TR]
[TR]
[TD]Serie A[/TD]
[TD]Ligue 1[/TD]
[/TR]
[TR]
[TD]Bundesliga[/TD]
[TD]ATP US Open[/TD]
[/TR]
[TR]
[TD]WTA US Open[/TD]
[TD]WNBA[/TD]
[/TR]
[TR]
[TD]MLB[/TD]
[TD]NFL[/TD]
[/TR]
</tbody>[/TABLE]

For example this command:

=index(importhtml("http://www.oddsportal.com/cricket/north-central-america/caribbean-premier-league/results/", "table", 2),1,1)

returned this:

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Premier League

 

[Nightcrawller]

Re: Import table not working?

I want this part to be imported: results>year

https://s33.postimg.cc/rysem1mwf/Screenshot_2018-09-01-22-05-19.png

I am using google sheets android.

 

[igold]

Re: Import table not working?

I am using Excel 2010.

Unless you are having as issue with Excel, you may be on the wrong form.

If you are trying to import information into Excel, you are going to have provide more information on what you are trying accomplish.

 

[Fluff]

Re: Import table not working?

I am using google sheets android.

As this is a googlesheets question I have moved it to the correct board & modified the title.

 

[sandy666]

Re: Import table not working?

with Excel
use PowerQuery (free add-in for 2010/2013, built-in - 2016 and higher)
after import you can do what you want with data

edit:
ops, I missed it's googlesh(ee)t